How to set page orientaion for PDF and Word file when exporting? Is it possible to convert directly from ExcelML to PDF or Word?

[LamKhoa]

I tried following to export to pdf in Landscape page orientation:

 

RadGridResult.ExportSettings.Pdf.PageHeight = Unit.Parse("215mm")

 

RadGridResult.ExportSettings.Pdf.PageWidth = Unit.Parse("260mm");

But it didn't work, and I have no idea on how to export to Word in Landscape orientation.
But I can do it with Excel just fine. Is there anyway to "convert" Excel to PDF or Word format on the fly?

THanks

LamK.

 

 

 

 

[Daniel]

Hello LamK,

You can set the page orientation as demonstrated in the attached sample project.
As to the second question - I'm afraid it is not possible to convert the files from one format to another - this is out of the scope of RadGrid.

Best regards,
Daniel
the Telerik team

[LamKhoa]

Thanks,

Now I'm able to make it to be in Landscape orientation when exporting to word.

However, it's still not enough to show up all the columns in my grid. By default, the Word exporting is set to 1 inches margin. Is there anyway that I can programmatically change that (like to .5 inch margin)?

Thanks

LamK.

[Daniel]

Hello Lamkhoa,

Yes, it is possible. Here is an example:

e.Styles.Append("<!-- @page WordSection1 { size: 297mm 210mm; margin:1.0in 2.0in 1.0in 2.0in; }" +
                "div.WordSection1 {page:WordSection1;} -->");

Best regards,
Daniel
the Telerik team