Read in spreadsheet file

[nevica]

Hello,

This is a very basic question about reading in spreadsheet files. How do I do it please?

I have a spreadsheet of 1 row and 256 columns. What separates the data in a spreadsheet file? Is it tab.

My current .vi doesnt want to read in the spreadsheet for some reason.

Thanks,

[crossrulz]

---

nevica wrote:

I have a spreadsheet of 1 row and 256 columns. What separates the data in a spreadsheet file? Is it tab.

---

Is that a question?  Do you have a sample file that we can look at?  It is a total shot in the dark without that.

[nevica]

Hi,

Here is the file I am trying to read in attached.

You'll notice that the spreadsheet file is made up of 1 row and an identical column in an attempt to read in the file.

The spreadsheet file input I am using is shown below.

[crossrulz · Accepted solution]

That function does not read xls or xlsx files.  It reads ASCII spreadsheet files.  You could either save your Excel file as a CSV (File->Save As, then change the type to CSV) or a text file and use that VI.  Or you can use some ActiveX commands to read the data from Excel.  Changing the file type is a lot easier.

[RavensFan]

Read from Spreadsheet File DOES NOT read Excel files.

It reads text files that are setup as a 2-D array with with a delimiter between "columns" and an end of line character separating "rows".

[altenbach]

---

@crossrulz wrote:

You could either save your Excel file as a CSV (File->Save As, then change the type to CSV) or a text file and use that VI. 

---

No, never do CSV files, they are evil because some countries use comma as decmal seperator, causing unpredictable results. It is much better to export it as text file as in the second suggestion, which will give you tabs as delimiters and which is aready the default delimiter for "read from spreadsheet file".