Hello, I send data’s to excell with automation but I don’t find how to set up excell to print column titles on every pages. Thank you, John
In Excel, under “Page Setup”->Table, there are options for rows and columns that will be repeated on each page (don’t know how the option is called in English as I have the German version here). Of course, you can set these options from C/AL automation or VB just like anything else. So, all you need to do is fill the first row with column titles and declare the first row as to be printed on each page.
Easy => xlWorksheet.PageSetup.PrintTitleRows := ‘$10:$11’; xlWorksheet.PageSetup.CenterHeader := ‘Date : &D’; xlWorksheet.PageSetup.RightHeader := ‘Page : &P’; Just an example!
Thanks a lot In french I would say “Nickel”
Nickel? Isn’t that a metal? I speak a lot of french but i never heard the word before in french? I prefer gold [:D] I even asked a frenchmen what it means. [:D]
You can also say “Nickel chrome” [:D][:D][:D]
There was a freakin’ accident and a FROG was runover…