Manipulating read from spreadsheet file

[swchica18]

Hi.

I am trying to read different files into different arrays. Is it possible to manipulate the read from spreadsheet file VI to read different rows of data from the different files? Can you do this by opening the front panel of the read from spreadsheet file VI?

Thanks,

swchica18

[Michael Aivaliotis]

QUOTE(swchica18 @ Oct 10 2007, 07:52 PM)

Can you do this by opening the front panel of the read from spreadsheet file VI?

Yes, you can.

Did you try entering a filepath in the box labeled "file path".

..oh, and then run the VI using the arrow button thingie in the top left corner.

[swchica18]

I'm going to ignore your last comment. I thought this was a place where people discussed LabVIEW questions and problems. I am hoping I can still get your help, because I am very interested in using LabVIEW. I guess what I was trying to ask is how to change which rows you read from within a file. I've been having trouble trying to extract the data from each row of several files. Every time I change something within the front panel, I don't get a change in the rows it extracts. I've attached what it is I've mentioned above.

Thanks for your time and help.

swchica18

QUOTE(Michael_Aivaliotis @ Oct 10 2007, 05:10 PM)

Yes, you can.

Did you try entering a filepath in the box labeled "file path".

..oh, and then run the VI using the arrow button thingie in the top left corner.

[Neville D]

Have you tried entering the #rows and offset?

Are you using this VI as a subVI? Not clear how you are using the front panel of this VI.

In any case, if all this doesn't work, just read the whole file and extract out the rows you want using array subset function from the arrays pallet.

Neville.

[Justin Goeres]

QUOTE(swchica18 @ Oct 12 2007, 02:06 PM)

I'm going to ignore your last comment. I thought this was a place where people discussed LabVIEW questions and problems.

Michael replied that way because your post not only asks a very basic question, it indicates that you put almost no effort into solving the problem yourself before coming here. We're happy to help you, but you need to show some initiative upfront. The members of this community are not your personal army of tutors.

QUOTE

I guess what I was trying to ask is how to change which rows you read from within a file. I've been having trouble trying to extract the data from each row of several files. Every time I change something within the front panel, I don't get a change in the rows it extracts.

What inputs are you changing, and what corresponding output changes do you see? I suspect you've got a fairly basic misunderstanding of what the VI is doing.

Neville's advice is good. It will require you to write a small amount of code of your own. I would encourage you to look at the various examples included with LabVIEW, and to consult the LabVIEW Help to understand what various functions do. If you still can't get your code to work, post what you've got, and describe what you've tried, and you'll get a much warmer reception.