excel and labview

[mdjaved]

Hii all

I am having Labview 8.2.. And i need to convert the excel file containing 2 or more columns into waveform in labview.
I need the block diagram specifying the input to read from spreadsheet.vi .

Thank you

[mikeporter]

If the file is truly an Excel datafile, check the ActiveX examples that ship with LV. They show how to interface to Excel. If the file is fundamentally a text file that Excel is just opening, the standard file IO routines will work for opening it.

Mike...

[mdjaved]

Hii

Is there any other way rather than ActiveX.

Thanks

[mikeporter]

No, you can also use the ADO database interface to sometimes read Excel files, but that is also ActiveX.

Mike...

[mdjaved]

hii mike

Can you provide me an complete example of doing that with activeX.

Thank

[mikeporter]

Check the examples that ship with LV. I don't have acces to V8 anymore.

Mike...

[JÞB]

---

@mdjaved wrote:

Hii

Is there any other way rather than ActiveX.

Thanks

---

Sure,  Just write yourself a parser for the the Microsoft Office XML format read the file on disk and viola!  Or, you can use a automation reference to an application that supports the file format natively such as an Active X reference to Excel

[Dennis_Knutson]

There are examples that come with the Report Generation Toolkit. And, if you search the forum for Excel, you'll find hundreds, if not thousands of threads and many have example code. It's do much easier to save your excel file as a csv file, though.

[Hooovahh]

---

@JÞB wrote:

---

@mdjaved wrote:

Hii

Is there any other way rather than ActiveX.

Thanks

---

Sure,  Just write yourself a parser for the the Microsoft Office XML format read the file on disk and viola!  

---

If you do go down that crazy rabbit hole please do report your results here.  I'm not sure I would use it but I would find it facinating. 

[Hooovahh]

Interestingly enough I did find a tool that does command line XLSX to CSV conversions.

http://www.softinterface.com/Convert-XLS/Convert-XLS.htm

OpenOffice also has some kind of command line utility that could do something similar.