Exporting graph to MS Excel

[sky1981]

Hi MikeS81,

Yes, I need a spredsheet file which can be opened by Excel.

On my example when I run it it give me error, I do not know why

Thanks.

sky1981

[MikeS81]

Hi sky1981,

where do you get the error? How many  values do you want to write into your file? Remember Excel can show only a limited number of rows. You should connect a path to the export function.

Mike

[smercurio_fc]

You keep telling us you get an error, but you're not telling us what that error is, which makes it very difficult to help you. If possible, get a screenshot of the error and post it. Please do not post bitmaps. Save the file as a PNG or JPEG.

[sky1981]

When I run the file

The first window was displayed

then when I press OK it keep displaying and it can not let me choose any file even excel files

 when I press cancel the second window was displayed

If I press continue is display the choose file window

 when I press stop the 3rd window was displayed highlighting the export waveforms to spread sheet

This is what is happening with me

[smercurio_fc]

I asked you not to post bitmaps, and what do you do? You post a bitmap by "cleverly" changing the extension. Doing so does not change the file format.

We have already explained what your problem is: You do not have a path wired to the the Export Waveforms to Spreadsheet File VI. With no path wired (or an empty path), the VI will ask you where to save the file. Since you have it in a loop it will do so every time the loop runs. Read the Help on that function. It tells you this:

file path is the path name of the file. If file path is empty (default) or is <Not A Path>, the VI displays a dialog box from which you can select a file. Error 43 occurs if you cancel the dialog box.

[sky1981]

Well, where to connect it to ? :mansurprised:

Thanks

[RavensFan]

Turn on context help with Ctrl-H.

Hover your mouse over the Write Waveform File function.

[SteveR6531]

Hello, I realize that this thread is a number of years old, so I'm hoping I will be able to get some help. I am taking both current and voltage readings from a power supply and the readings are being plotted on the graph. I want to export this data to some kind of file so I can analyze the whole cycle. I have attached a copy of the VI, any help would be really appreciated.