Excel to Labview

[ripper6009]

Need help to develop a program for labveiw from a excel spreadsheet (which has two rows). How do you manage to get labveiw to read data from spreadsheet to display histograms?

[BowenM]

The report generation toolkit can read Excel files.  Note however that it not only requires Excel to be installed, it will actually open the report in Excel before reading it - so it is very slow.

[ripper6009]

Thanks for the reply. Just wondering how do you select the excel csv file (which icon) and how do need to format the data to suit developed program

[BowenM]

---

@ripper6009 wrote:

Just wondering how do you select the excel csv file

---

... a csv file is not the same thing as an Excel file.  If you want to read a csv file in, just use Read Delimited Spreadsheet.

[ripper6009]

Sorry its excel spreadsheet so an xlsx file

[Bob_Schor]

Look at BowenM's original suggestion.  Since you did not post any code, we can't tell much about your environment, such as your LabVIEW Version.  Do you have access to the Report Generation Toolkit?  Do you have Excel installed on your PC?

There is third-party software that provides "hooks" into .xlsx files without requiring the RGT, nor (I believe) even Excel.  I apologize to its Developer (whom I've met at NI Week), but don't remember the name of the Product.  However, you can probably do a Web search and find it, and it is also probably on the LabVIEW Tools Network.

Bob Schor

[Gregory]

Hi Bob,

It might be XLR8. 

[Bob_Schor]

Yes, that sounds right to me ...  Thanks.

[TheQ]

You could also look into using ActiveX, but this is what the RGT uses under its hood.  So its almost the same thing where you would have to have Excel installed; however, the you wouldn't need RGT installed.

[PalanivelThiruvenkadam]

Provide Necessary Input and check whether you can read the expected values from the specified excel file