How can I change excel column header using Labile.

[siva_usic]

Dear Experts,

                      How can i change excel column header using LabVIEW.

Thanks for any and all help!

M.S.Sivaraj.

[chilly_charly]

Changing a column header is Excel is just a matter of writing to row 1 in the right column.

There is a shipping example using AcxtiveX (C:\Program Files\National Instruments\LabVIEW 8.6\examples\comm\ExcelExamples.llb) that shows how to write to a specific cell.

[siva_usic]

Hello chilly,

                  Actually i am not asking how to write any data in excel sheet. My aim is put any character in the column header of the excel sheet throuht LabVIE. it is possible.

Thanks and regard

M.S.Sivaraj

[chilly_charly]

As I said in my previous post, column headers in Excel are merely row 1 cells. May be I missing something here, so please be more explicit with your question.

I guess you are using the Excel Report tools, and you want to modify an existing sheet. From my limited experience with the Excel Report tools, it is not possible to open an existing woorkbook (except as template...), so the answer to your question should be "Forget it"...

The work around is to use the example I pointed for you before, and either to write the whole new colum headers as a string array, starting in A1, or to write a single string to a given cell in row 1.

Hope this helps