export data to excel with my own selections

[GoncaloPT]

Hi everyone,

i'm trying to export data to excel and it's running well, however the excel sheet shows to many information. I needed it to show 1 time column only, and it shows one for each channel...how can i solve this on the attached VI? I also would like to know how can I lock the x-axis settings, because it's ok when stopped but it changes when i run the program...

Thanks a lot you guys!

[JérémyC]

Hello,

I don't have DAQ device available so I can't run your VI for the moment. I recommend you to use property nodes and invoke nodes for achieving your goal. I will work on your VI.

Regards,

[JérémyC]

Hello,

Regarding x-axis settings, did you uncheck the autoscale of the X-axis with a right click on the graph?

Regards,

[Audrey_P]

Hi Jimmy,

First of all thank you for using the NI discussion forum.

The “export data to excel” method node creates standard reports and you can’t personalize your report format by using it.

However, you can create personalized report by using the Report Generation Toolkit. You can find here a tutorial to explore the possibilities of this toolkit.

Nevertheless, you are using express Vis and dynamic data are not easy to manipulate.

A simple way to obtain what you want is perhaps to merge cells programmatically (use for example the attached VI).

I hope this will help, don’t hesitate to ask more questions.

Best regards,