Good Morning everyone,
I am trying from within python to add a picture on the footer/header of an excel spreadsheet.
can anyone help me to figure out what is the correct code to do it?
Up till now I managed to:
-Write text in a range of cells,
-Create text for the footer / header (with automatic page numbering too)
-Setup the size & orientation of the layout,
-Save and open automatically the file in printing preview mode,
-Import an image in the worksheet (but not in the footer/header).
I attached a picture of my code, with marked up the “problematic zone”:
I will NOT use module packages like openpyxl, xlsxwriter, xlrd, xlwt, xlutils,
BUT I would like to use only the Microsoft.Office.Interop.Excel (but I can’t figure out how to make it work).
Here are some links from which I drew inspiration:
the dynamo file here attached too:
TEST.dyn (4.5 KB)
the result would be very useful for the community to have full control over the excel formatting, together with the amazing bumblebee package!