This is a migrated thread and some comments may be shown as answers.

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

3 Answers 136 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 22 Oct 2014, 07:59 PM
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

3 Answers, 1 is accepted

Sort by
0
Mike
Top achievements
Rank 1
answered on 24 Oct 2014, 01:39 PM
Also, is it possible to word wrap text in cells?
Or show hidden columns?

If not, which other Excel format supports it?
0
Accepted
Kostadin
Telerik team
answered on 27 Oct 2014, 11:42 AM
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
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
0
Mike
Top achievements
Rank 1
answered on 31 Oct 2014, 12:58 PM
Thank you, the ExcelML format seems to have fulfilled my requirements.
Tags
Grid
Asked by
Mike
Top achievements
Rank 1
Answers by
Mike
Top achievements
Rank 1
Kostadin
Telerik team
Share this question
or