how to use write to spreadsheet.vi

[srikrishnaNF]

Hi hafiz,

   Why dont you do the cntrl-h and look at context help.And you hadn't told anything about the problem?

Thanks and regards,

srikrishnaNF

[RavensFan]

What would you like to know?

You have data going into the Write to Spreadsheet file VI.  That is a good start.

You might want to wire a path control or path constant into that VI so it doesn't pop up a dialog box asking you for the filename on every iteration.

Is there anything else you'd like to know?

I'd recommend doing a Block Diagram Cleanup on yor code to eliminate the extra bends, backwards wires, and hidden functions laying under the while loop.

[hafizzuddin]

now the writing part is ok, but i have a problem on the reading from spreadsheet. i can read the data table but the question is how can i convert it to a graph. i have done it but it turn out that it give an extra reading making my data hard to be read. anyone can help me. here i attached a VI i modified with a friend of mine, shrekt.

[Vaibhav G]

just you have to provide the path name where you wnt to store it.

& pl go to example finder, you will find very easy examples of this kind

All the best

[Vaibhav G]

the data u r reading from your file is it 1-dimension or 2-dimension?

[hafizzuddin]

currently using 2d

[Vaibhav G]

Try this VI

Change the tab to READ., it will read the stored data & will indicate on graph

Let me know, if it is your solution or not?

[hafizzuddin]

hai there, the vi you gave does bring out a contant reading, which is the same problem. you can refer to the picture(comparison) i uploaded, the upper graph(History) is the data taken and saved. when i read it back, it produce a red line graph(saved data) which is similar to the upper graph but with an additional on a blue line graph constant at 1.

[hafizzuddin]

the question is, how can i get rid of that blue line on the saved data graph