reading a file from excel

[Mrtechie]

hello all , 

 pls give me a solution for this . i have tried to read a excel file using "read delimited spreadsheet " . its read everything as zero not the exact data . i have attached my files excel file and VI . Have a look at this .

[udka]

Look into this : All Zeros Returned when Reading an Excel File: http://digital.ni.com/public.nsf/allkb/0C2969C5673DCEF586257A080055F597

[Alepar29]

Hello,

you don't use the good functions, you have to use the Excel function to read an Excel file.

I have attached a modified VI.

Regards

[JamesSouv]

Hello,

This VI cannot read .xlsx files. Therefore, you have two alternatives:

The first one is to save your excel file under .txt format

for example save as Text (MS-DOS) (*.txt).

Be sure you have selected String as data type and change the indicator as well, since you have some strings in the first row.

The second alternative: I provide you a small program that will allow you to read Excel files (and .txt files) in LabVIEW.

Greetings and Regards,

James.