how to read manualy typed excel into labview

[TROUBLESHOOTING]

Hi,

I need to read manually typed  excel file in labview 7.1,

as I cannot change labview version to 8,

Please let me know if I can read the normal excel sheet which is typed by operator,

How to read in labview 7.1?

Thanx

Swati.

[MikeS81]

Hi Swati,

you can use the ActiveX functions from Excel. And as far as i know there is a library to do it.

Mike

[parthabe]

Hi Swati,

Read the file as usual using the Open File --> Read File --> Close File method & convert the String data into 2D String Array using the Spreadsheet String to Array function from the String palette, by giving the Delimiter as ",".

This ll do the job for you.

[parthabe]

Does your filehas the extension .csv or something else?

[TROUBLESHOOTING]

Hi Partha,

I tried converting string into array

what shuld be the format?

%s?

i gave delimiter as comma,

didnt read anything,

Thanx.

Swati.

[TROUBLESHOOTING]

No man,

no csv file just one simple excel file where i typed something like any number or string and i am trying to read it in Labview,

and i m not able to do it,

Actually,I have to read a master spreadsheet file at clinet location for reading some parameters in labview,

But this seems to be hard than i ever thought,

Please do help me,

Thanx

Swati.

[MikeS81]

Hi Swati,

see this link: http://zone.ni.com/devzone/cda/epd/p/id/3409. I think this should help you.

Mike

Message Edited by MikeS81 on 03-27-2008 11:37 AM

[Kodeeswaran]

Hi

  Just Save the Excel sheet as csv text files and read the using the read spreadsheet file.vi, its simple and easy

[parthabe]

See the attached code image.

For me, it read both noramal Excel file & CSV file also.

[TROUBLESHOOTING]

Thanx,

It worked,

Only i will have to save that master file with csv format but wil try

thanx

Swati.