Problem with reading String from Xlsx file.

[n_dogra]

Hi! I am trying to read string and numerical data from an xlsx file and trying to display its contents in a word file. I tried converting it to a .lvm file too. On using the "Read From Spreadsheet" tool, I get random characters as output. On using " Read From Measurement File" tool, I am getting an error saying "Error 100 occurred at Read From Measurement File->Untitled 1". What do I do? At the end I need to display the output, row by row, in a Microsoft Word file. I am so lost. Please Help.

[bsvare]

labview currently does not read directly from an xlsx file. If you convert the xlsx to an xls file first, then you can use the read from spreadsheet tool to load the data from the file.

[Dennis_Knutson · Accepted solution]

Read From Spreadsheet CANNOT read from an xls file. The Read From Spreadsheet can read from text files. Typically comma or tab separated. In order to read from an xls file, you need to use ActiveX such as the Report Generation Toolkit uses.

[n_dogra]

@bsvare wrote:

labview currently does not read directly from an xlsx file. If you convert the xlsx to an xls file first, then you can use the read from spreadsheet tool to load the data from the file.

---

Hey, I tried doing that. It still just gave the values 0.00 in all the cells of the indicator array. Plus my file has string in it also. The data type in the spreadsheet was "general". Here in the tool, it is "Double". I changed the tool data type to string and spreadsheet to text but I only got gibbrish for my efforts.

Thanks anyway! 🙂

[n_dogra]

---

@Dennis_Knutson wrote:

Read From Spreadsheet CANNOT read from an xls file. The Read From Spreadsheet can read from text files. Typically comma or tab separated. In order to read from an xls file, you need to use ActiveX such as the Report Generation Toolkit uses.

---

I changed the xls file to a txt file and it worked! I can now see the output! Thank you so much!

[Dennis_Knutson]

Then please mark my answer as the solution instead of your thank you. You can click on 'Options' to change it.

[tintin_99]

Thanks Denis. I have the report generation toolkit. Could you please let me know what block should I use?

Thanks