iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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
protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){ e.ReportInfo.UseCellMergingForExcelReport = true; }
Regards,Hans K.
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!
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.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname