Hi,
I using the UltraGridExcelExporter to export gird to excel ,but when print the worksheet exported ,the default pagesize is always Letter.While I export with Microsoft.Office.Interop.Excel.Application ,default pagesize is A4.
So,Is there any way to set worksheet exported 's default pagesize ,such as TargetPaperSize or something like?
Thanks very much!
It works fine.
If you handle the BeginExport event of the UltraGridExcelExporter, you can get the CurrentWorksheet from the event arguments. On that, set the PrintOptions.PaperSize property.