Intersoft Community - WebGrid Enterprise - Webgrid 8 Support for Excel 2010 Export and Split Data Issue?

Webgrid 8 Support for Excel 2010 Export and Split Data Issue?

Hans — Mon, 18 Aug 2014 04:09:09 GMT

Hello,

Thank you for the reply.

If you don’t mind, could you inform me more information regarding your WebGrid?
What your current WebGrid configuration?
Could you provide me the screenshot regarding the issue?
So that I can find the right solution for this issue.

Thank you for your help.

Regards,
Hans K.

Webgrid 8 Support for Excel 2010 Export and Split Data Issue?

cvgierloff — Fri, 15 Aug 2014 12:29:05 GMT

Unfortunately that did not resolve the problem. The code is being returned by a stored procedure that strips out characters such as carriage return and line feed, etc... Please let me know if there are any other options. Thanks!

Webgrid 8 Support for Excel 2010 Export and Split Data Issue?

Hans — Wed, 06 Aug 2014 00:51:14 GMT

Hello,

I am sorry for the inconvenience.

Currently, WebGrid only support export feature to Excel with .xls format only.

Regarding “split to a separate row upon export” issue, perhaps you could set the “UseCellMergingForExcelReport” property to “true”, in “OnExport” server side event.

Here’s the example snippet code how to set the “UseCellMergingForExcelReport” property:

protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){
    e.ReportInfo.UseCellMergingForExcelReport = true;
}

Regards,
Hans K.

Webgrid 8 Support for Excel 2010 Export and Split Data Issue?

cvgierloff — Tue, 05 Aug 2014 11:24:03 GMT

Is Webgrid Enterprise 8 capable of exporting to Excel 2010 by default? If it is necessary to write code would you have any samples?

We recently upgraded some of our webgrids to this version and cells with a large number of characters split to a separate row upon export. The character limit for Excel is still ~32K in 2010 and we are under that limit. I noticed that the grid exports to .xls file format and wasn't sure if Excel version could be an issue.

I saw a post that recommended making the column wider in the webgrid so that it doesn't split upon export but that would really spoil the user experience...

Regards,

Christi