exporting data to excel

[Hendrick]

Hi,

I would I go about exporting the data to an excel file? On the front panel I tried using the export to excel function but excel opens with only the labels of the signals with no actual data points. Do I have to build an array or something? I've attached the .vi to this post.

Thanks

[RavensFan]

From which control are you trying to export data?  Does data show up on it?

When I put some data in your charts, I was able to export the data to Excel without problems.

[Hendrick]

I'm trying to export the data from the waveform chart, I've attached a screenshot of the front panel.

[RavensFan]

Can you resave your VI with that data shown in the indicator saved as default?

I can't run your VI because I don't have your FPGA hardware.  So after stripping out all the code that I couldn't run, and wiring up a random number generator in a loop to connect to the waveform chart, I had no issues exporting that data.  If I can try again with your real data saved as default, it should be most like your VI.

[Hendrick]

I tried saving the .vi with the data, let me know if the data isn't saved because I don't really know how to do that properly.

[Hendrick]

I've tried a few times to make the data in the chart the default but it doesn't seem to save. Sorry...

[Hendrick]

I think this may have something to do with my waveform not having a dt, any suggestions?

[RavensFan]

---

@Hendrick wrote:

I think this may have something to do with my waveform not having a dt, any suggestions?

---

I doubt that.  When I worked with your VI, I just used the random number generator, so it was just a waveform chart of doubles just like your VI is.

I can't see if I would have the same problems as you unless you save the data as default.  And it really isn't hard to do.

1.  Run the VI.

2.  Right click chart.  Data Operations >>  Make current value default.

3.  Save.

4.  Post

[Hendrick]

I made the current values default and saved the file, however when I opened the file again and reinitialised the chart to default, it did not show the data. Could there be something wrong that's not allowing me to make the values default properly? Thanks

[RavensFan]

I have no idea why you are having problems.

One thing I find odd is the size of your VI.  It just doesn't seem to have so much in it that would make it 581 KB.  VI memory usage says 221 KB are in block diagram objects, but I don't see so many objects to push the memory that high.