problem writing to excel file using report generation toolkit

[LV_Enthu]

Ok... Another question.. sorry, i am trying out bunch of things here so, I am mixing it all up. If you use the express MS Office Report Generation VI, and if I had to edit the 1st column of the data that is being produced hwo do i 

do it?

Usually, if I connect a DAQmx data to the chart and the Data input of the express MS Office Report Generation VI, the first column would be 1,2,3,4,5.... how can I write any no.s that I want to into the first column(say 0.25, 0.5, 0.75, 1.0) and so on...?

I know that I have to play around with the front panel of the express MS Office Report Generation VI and then dig even further into it... bt WHAT has to be changed is I would like to know. 

if anyone could ans me that, it would be the end of my project!!! 

Please help..

[Brian_P]

Check out the Generate Report from Template(Excel).vi example in the example finder.

[LV_Enthu]

@BBallBYU, i already checked it out, but if you look at the 1st column, what does it give you? 0,1,2,3,... how do I change this value to say my sampling rate of the DAQmx, so finally, when my report is generated it looks like the attached file. the attached file is just a template... i have inserted the graph through excel,.but i would want labview to generate similar kind of report 

Thanks 

[Brian_P]

You can input data into a table and graph by using table_data_input and graph_data_input.  The input that goes in needs to be a 2D array with the data taht you want to show up in your table and graph. So you would want time in index 0 and torque in index 1.  This will give you a table and graph like you want.  

http://www.ni.com/pdf/labview/us/report_generation_toolkit.pdf

[LV_Enthu]

yes.. but the data file would still have the 1st column as 1,2,3... because the variant in the express MS office report.vi auto attaches 1,2,3,.... to the  table_data_input  and the graph_data_input... i am trying to find out a 

way if i can somehow change the way the variant inside the express MS office report.vi captres the data...

if you have anything better to do, can you please share?

[Brian_P]

You can use lower level .VIs to accomplish this task.  In that Generate Report from Template(Excel).vi in the True case it goes through how to generate a report that doesn't default to 0,1,2,...  If you run the VI in the true case you will get a graph and a table that both don't have 0,1,2,3,4..