excel headers

[faisalayaz]

I am continously acquiring data from transducers nad tthermocouples using the while loop and writing data to exel sheet. My problem is that i have not been able to automatically write headers of my choice to the excel sheet thereby categorizing the data from each transducer and thermocouple. How can we give header from the while loop or there is any other way ?

[BJD1613]

The easiest way to do this is to build a two dimensional array of strings. In the first row you can place your column headers. They you can use the array to spreadsheet string function. This will allow you to specify a delimiter, default is tab. They simply use the write characters to file function. You can specify a .xls extension for the file name. This will build your columns with headers on the top and everything will be in different cells. Hope this helps.

[scho]

BJD1613,

Would it be possible if you could show me how to do this in an image file? (windows screenshot).

I am using a fielpoint device but this wouldn't matter right?

Kind regards,

[Gak]

Hi faisalayaz,

You can use the code attached below to write column headers before start of you data logging. Say in your "Initialize" state.

Let me know if this solves your problem.

Best Of luck!!!!

[thinnker]

Hi Gaurav

Your code gives error after invoke node executed.

Regards,

Hari

[Gak]

Hi hari,

It runs without error on my PC. Please check path/ name of the excel sheet at your side

[thinnker]

Hey Gaurav

It is working fine.

now i like to add a measure values.

graph from that measured values.

can we create grneral test report like below

test name:                                                                                   date:

test number:                                                                                time:

test operator:

sno      val1                val2                   val3

thank you

[Gak]

For that you will have to use template and NI_report generation toolkit.

[Gak]

Hi hari,

Look at the attached image.

An example of how to write data in template.

[LV_Pro]

While you have gotten an immediate response to your question I will mention that it is a good idea for future questions to start a new thread rather than ask the original poster or respondents to a six year old thread.