06-02-2012 06:05 AM
06-04-2012 09:14 PM
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.
06-05-2012 12:13 AM
Can i convert the excel report into a pdf file...??
06-05-2012 01:09 AM
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.
06-21-2012 09:25 AM
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
06-21-2012 02:27 PM
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.