LabWindows/CVI

[sks1990]

Hi..

How can i apply header and footer to excel sheet using program??

[menchar · Accepted solution]

You can't, there's no such concept as a worksheet header or footer in Excel.

You can name a worksheet, and you can put text into cells at the top of the worksheet and further down on some higher numbered row using the Excel automation available form CVI.

But there's no header and footer as there is with Word, at least to my knowledge.

Excel automation help is available in CVI, along with sample code, just search for Excel in the CVI help.

[sks1990]

Can i convert the excel report into a pdf file...?? 

[menchar]

Yes, I believe so, at least you can with Excel 2007.  If you can't invoke the "Save As" functionality via the CVI Excel automation interface directly, you can write an Excel macro to do it and then invoke the macro from CVI.  I may have some sort of PDF plug-in in my copy of Excel 2007, not sure if Excel 2007 has this capability out of the box.

[ASIC_LabRat]

Um... yes there is Headers/Footers in Excel... but only visable in the printer mode, is this what the original question is looking for? wanting to change the header / footer info on a printout?

ChipB

[menchar]

Could be that it is.  I hadn't realized that Excel allowed a header / footer on a printout, I just knew that there was no such thing incorporated into the worksheet itelf.