Export to Excel (BIFF) Format - Margin, Header, Footer, Scale Page

[Mike]

I would like to do some formatting on exported Excel spreadsheets, preferably with utilizing the BIFF export. Is it possible to do the following things with exporting via BIFF? If not, how about HTML or ExcelML?

-Scaling width to fit on one page
-Adding Header data (that will show on each page when printed)
-Adding footer data (that will show on each page when printed)
-Adjusting margins
-Looping through each row and coloring every other row a different color

[Mike]

Also, is it possible to word wrap text in cells?
Or show hidden columns?

If not, which other Excel format supports it?

[Kostadin]

Hello Mike,

I would recommend to examine the documentation where you can find which of the preferred options are supported. 
Excel BIFF
ExcelML basics
HTML-Based Export

Generally by using HTML Based export format you can add header and footer which will be visible only when printing the page, while the rest do not support this feature.
Excel Format (HTML-Based)

Regards,
Kostadin
Telerik

 

 

[Mike]

Thank you, the ExcelML format seems to have fulfilled my requirements.