read excel file without opening excel

[Steve_Block]

I have a bunch of text only excel files that I want to read through to extract data, but the process of opening and closing excel is pretty cumbserome. Does anyone know of any vis that can extract excel spreadsheet data from the raw.xls file as opposed to having to open excel and communicate via the toolkit or activex?

[SunshineDesign]

Open it with Excel and save as Text file. Open in Labview as a text file. Then you don't need excel.....

[Steve_Block]

These are preexisting files so opening and resaving in text format is not a practical option.

[P@Anand]

Is it possible to save the same file as .csv through MS Office? If it is done you can simply use the read from text file VI to read it.

[PhillipBrooks]

If you have the NI Database Connectivity Toolkit, you can use that to open XLS files and read them in as a 2D array of strings.

The trick is the correct connection string. http://support.microsoft.com/kb/257819

See attached LabVIEW 8.6 VI.

[MarcoMauri]

Hi!

I think using ActiveX you can programmatically open Excel keeping it hidden, so maybe you can reconsider avoiding ActiveX.

As an alternative you can batch-convert all your XLS to CSV.

On the web I've found some hints on how to do this...

Regards,

Marco

[Steve_Block]

The issue is execution speed. The toolkit idea might work, but I try to minimize the amount of external toolkits required, because they create a configuration nightmare.

[SunainaK]

Hi Steve,

Good evening. Did the toolkit idea work for you? If not, you might want to look into using TDMS

https://www.ni.com/en/support/documentation/supplemental/06/the-ni-tdms-file-format.html Let me know if this helps or if you need further help.

[Wayne.C]

Steve,

Have you tried starting the Excel application, then opening and closing each file?  Would eliminate starting and stoping the whole app for each file.

[Akiel]

the closest i this i have done is use the report generation toolkit to open and read the file, also in this toolkit is a get refnums which can return the excel application refnum which you can use a activex call to hide it. Once your done excel can be closed this way.

hope it helps

TD