How can we open a excel in .xlsx format using ultrawebgridexporter? | Infragistics Forums

State Suggested Answer
Replies 3 replies
Answers 1 answer
Subscribers 9 subscribers
Views 11431 views
Users 0 members are here

Excel Library

2070

How can we open a excel in .xlsx format using ultrawebgridexporter?

Sridhar posted over 14 years ago

Hi,

I am exporting a grid using "UltraWebGridExporter" it is now opening in a file extension .XLS. I need to open the excel file in .XLSX file format.

How can I do this?

-Thank you.

4960

Suggested Answer
Derek Harmon posted over 14 years ago

You can set the WorkbookFormat on a newly constructed Workbook immediately before calling the Export method:

Workbook wb = new Workbook();
wb.SetCurrentFormat( WorkbookFormat.Excel2007);
this.WebGridExcelExporter1.Export( this.WebGrid1, wb);

This is supported in 8.3 and later (please see this thread for precise details).

Cheers,
Cancel
Reply

Reject Answer

Cancel
2070

Sridhar posted over 14 years ago in reply to Derek Harmon

Hi,

I tried with this code. This works when no "downloadname" is set. And it takes the default downlaod name(Untitled).

If I set any "Downloadname" means it doesn't work.

Need your suggestion.

Thanks.
Cancel
Reply

Cancel
560

Offline Gary Land posted over 9 years ago in reply to Sridhar

Hello,

I know this is an old thread but I am experiencing the same and would like to know whether it is possible to export a gird to xlsx as well as specifying the download name. I am currently using UltraWebGridExcelExporter 11.1.

Thanks
Cancel
Reply

Cancel