How do you set the Header of a sheet in XLSReadWriteII5? I can create the sheet and set the date in the Columns and Rows. But I don't see a way to how to Set the Header. There is a TXLSHeaderFooter.Create that is looking for a TXc12HeaderFooter. But how does that get assigned to the Worksheet?
I do see a TXLSWriteXLSX.WriteSheetHeaderFooter, but that seems to copy from a source to a destination. And I am not sure what is expected there. Again not seeing a connection to the workbook or sheets.
HeaderFooter
Re: HeaderFooter
Hello
Use: XLS[0].PrintSettings.HeaderFooter...
For more info and formatting codes, please take a look at the source code.
Use: XLS[0].PrintSettings.HeaderFooter...
For more info and formatting codes, please take a look at the source code.
Lars Arvidsson, Axolot Data
-
GNiessen10
- Posts: 3
- Joined: Wed Feb 16, 2022 2:07 am
Re: HeaderFooter
I have things working like they were in XLSReadWrite, except for the fact that when creating an XLS file the Header appears to be limited to 254 characters. Yet before it was not limited. I traced it through the source and I don't see that the string in being clipped in XLSReadWriteII, so it must be that the older version was doing Headers differently. Any idea how to over come the limit?