Title pretty says it all.
I have a program which generates XLS (excel) format workbooks on a linux machine. I want to format the worksheets in an automated fashion. I am trying to 1) change style to landscape 2) add header with sheet name 3) fit each sheet to 1 page
I figured the easiest way to do this was to define a custom style that did 1,2, and 3 then write a macro to apply this style to a given file.
I made the custom style then saved it in the default template. When I create a new spreadsheet, the custom style is available in the F11 Styles menu. However, if I open an existing xls file, the only styles that show up are Default and Report.
I’ve searched the forums and can’t get anywhere.
any thoughts? Thanks!