HeaderFooter

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
GNiessen10
Posts: 3
Joined: Wed Feb 16, 2022 2:07 am

HeaderFooter

Post by GNiessen10 »

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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: HeaderFooter

Post by larsa »

Hello

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

Post by GNiessen10 »

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?
Post Reply