Read from Spreadsheet file

[Veeru]

Good Morning

I need some help in Read from Spreadsheet file.

I writing to the "Write to Excel File",i need to read from that file and plot it in the chart along with the values written further(in the Write to excel file)

Thanks

[Rupali]

Hello... Do you want to write in excel file and read immediately or you want to write first & then read...?

[Veeru]

Thanks Rupali

I need to write 1st and then read

[Rupali]

I did the same vi but in different way.. I read excel file took  the values in array.. I did all this using property node.. Just have a look.. I did this in LabVIEW 7.1.

I hope this will help you.. 🙂

[smercurio_fc]

We seem to have some confusion in terms here. Are you actually dealing with Excel files, or tab-delimited text files? Read From Spreadsheet File operates on tab-delimited text files. It does not read Excel files. Yet you say you used "Write to Excel File". Is there a reason why you have to use Excel files? If not, dealing with tab-delimited text files is a lot easier, and a lot more portable. Also, why do you need to re-read the values? You already have them in the code, since you wrote them out.

As for the plotting part: Are you trying to use a waveform chart, waveform graph, or XY graph? These are all different. Search the examples for graphs. There's a number of examples that show you how to create plots using each of these.

[Veeru]

Thanks Rupali & Smercurio

[Veeru]

I reading back the values because,by mistake if i have closed the chart then i need the chart to run(once i have opened again) with all the plot as it was .

Thanks

[Rupali]

Hello.. 🙂

So you got any help from that code...? Is your problem solved now....? Let me know.. 🙂

[Veeru]

Thanks Rupali

I am not familiar with Activex,so i am just thinking of doing in any other way

Thanks

[parthabe]

Hi Veeru,

There is no other way other than to use ActiveX to read/write Excel files, if you do not have Report Generation toolkit.