The issue of missing headers

59 views
Skip to first unread message

郑坚荣

unread,
Jul 18, 2023, 10:42:51 PM7/18/23
to openpyxl-users
May I ask if you can use the openpyxl library to open an Excel file with the header and footer set (with the header image and footer text set), and then call and save it without any other processing. When you reopen this Excel file, the header image will be lost, and the footer text content will be fine. Of course, the result of inserting data is the same. Could you please help the developer solve this problem? Thank you!

Charlie Clark

unread,
Jul 19, 2023, 4:54:41 AM7/19/23
to openpyxl-users
You could probably do this by patching the source to ignore headers and footers and manage them manually: set links and add the images from the original workbook.

Charlie Clark

--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Sengelsweg 34
Düsseldorf
D- 40489
Tel: +49-203-3925-0390
Mobile: +49-178-782-6226
Reply all
Reply to author
Forward
0 new messages