Re : Read Specific worksheet in Excel File

[64864050]

HI, i recently jus got the report generation toolkit and i would like to open my excel file

im jus trying here and there and searching in the Excel Thread but cant find much clues..

my purpose of doing this is to open my worksheet 2 in my excel file and display it out in a table

need some help

[Julien_31 · Accepted solution]

Here is something for you : I d'on't understand what's wrong because it seems to work with one of my own Excel files and it doesn't work with the one you attached (values are different) !

Can you please tell me wether or not it works on your PC ?

[RavensFan]

You do know that Read from Spreadsheet File does not open Excel .xls files, don't you?

To work with Excel Files, you have to use ActiveX like krsone used in the attachments he posted.

[KateB]

Use Excel Get Worksheet to specify worksheet.

Then use Excel Get Data to get data.

[64864050]

its not working at all..

[64864050]

i do not know, just learnt labview and trying to generate a report quickly, so was hoping that getting this toolkit can save me from using/learning activex

[64864050]

i got a small problem, from krsone examples, it is able to read from the range values indicated

but if i wan the read ALL the data, how am i gonna change it?

i've tried to remove the range and put ShowAllData, but it doesn't work

[RavensFan]

Why would you use the "Show All Data" invoke node.  The Show All Data method according to VB help "Makes all rows of the currently filtered list visible."

And why would you take a worksheet reference and try to convert it to a 2-D array?

Are you trying to capture all possible data on the worksheet (256 columns by 65536 rows)?  That is a lot of data and I doubt any real spreadsheet of yours will be that full.  If so, you can make your range A:IV and that will be all rows of all 256 columns of data.

[64864050]

my actual excel have about 16000 rows of data or even more, but i will not know the actual numbers of rows as it depends on my testing.

i already have a VI that create an excel file when the test complete.

so i want to open up and display it in LabView (this is only part of it as i need to open serveral more excel file and merge it into 1 excel file)

[64864050]

after much thinking and looking through, i edited some and now it seems that its not working

theres this error message "type mismatch" and i don't get it

all i want is to open the selected excel file and the selected worksheet and display all data.