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 1145992 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.

560

Offline Gary Land posted over 10 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
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
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