I am using excel export control, and I'm wondering how to do a few things.
1) when the user exports the contents of the grid to excel, how do I change the page layout to landscape?
2) How do I automatically expand the "plus signs" in the excel document that is exported?
I've read the posts, and for automatically expanding the parent rows, no one seems to have found a solution. so is this even possible?
For the landscape issue - that is not a propery of Excel exporter... only the document exporter, but I was hoping someone knew of a different way to get this to work for excel.
Thanks again!
I'm not sure about the exporter, but there is no way to automatically expand a parent row directly through the Excel object model. However, you can set Hidden to False on all child rows to manually expand a parent row.
You can set a worksheet to Landscape by accessing the worksheet directly and settings it's PrintOptions.Orientation property to Landscape.