excell

[Ghoniem]

I am trying to import data in an excell worksheet, no heading or text, just values.  I tried using read frpm spreadsheet file, but the all rows and first row outputs remain at 0.. does anyone know of a good and effective way to import data from excell?

[nyc_(is_out_of_here)]

show us you VI and your example Excel file

[RavensFan]

First.  Read From Spreadsheeet File does not read Excel files.  It reads text files that are formatted in a spreadsheet like manner with delimiters between columns, and line feed or carriage return to separate rows.

If you want to read from Excel files, you want to use either ActiveX calls or the Report Generation Toolkit.  Search the forums.  You are not the first person to ask how to do this.  You are not even close to the 1000th person to ask.

[nyc_(is_out_of_here)]

---

@RavensFan wrote:

First.  Read From Spreadsheeet File does not read Excel files.  It reads text files that are formatted in a spreadsheet like manner with delimiters between columns, and line feed or carriage return to separate rows.

If you want to read from Excel files, you want to use either ActiveX calls or the Report Generation Toolkit.  Search the forums.  You are not the first person to ask how to do this.  You are not even close to the 1000th person to ask.

---

Problem is that many here use CSV file and Excel files interchangeably.

We'll know when we get the VI and "Excel" file.

[Dennis_Knutson · Accepted solution]

The Read From Spreadsheet does NOT read a native excel file. This has been explained here countless times and is also explained in the help for the function. You can save the sheet as a csv or tab delimited text file and use the function. There is the Report Generation Toolkit that you can use. There are low level ActiveX functions that you can use. Numerous examples here for all.

[Ghoniem]

Sorry, I am new to this forum but thanks for the info.