LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Populating Excel Headers and Footers to All Sheets

Good Day!
I have generated a report in Excel with several sheets, with headers and footers on one sheet. I want labview to populate the headers and the footers to all sheets.  Basically the headers/footers contain our logo, date and time, page number.
I would appreciate any help to do this.
Thank you very much!

0 Kudos
Message 1 of 3
(1,831 Views)

What ever you did to put the header and footer into one sheet, you need to repeat that for the other sheets.

 

You haven't shown us how you are doing this, but it is probably a process to select the others or make them active and do the same header/footer process.  Rinse/Repeat.

0 Kudos
Message 2 of 3
(1,800 Views)

@

Thank you very much for your inputs.
The initial header/footers is actually added manually from a template.
I have tried this code to force the header programatically, but the problem is it changes the font settings from the original.
Do you have any idea of how to properly set the font/settings?
Thank you very much.
Snip.png

 

0 Kudos
Message 3 of 3
(1,796 Views)