gridview - Export to excel with browser localization - ASP.Net -
i have gridview , exporting excel gridview below code.
response.clearcontent() response.addheader("content-disposition", "attachment; filename=excelshipments_" & datetime.now.ticks & ".xls") response.contenttype = "application/excel" dim swriter new stringwriter() dim htextwriter new htmltextwriter(swriter) dim hform new htmlform() ucshipmentlist.shipmentgrid.parent.controls.add(hform) hform.attributes("runat") = "server" hform.controls.add(ucshipmentlist.shipmentgrid) hform.rendercontrol(htextwriter) dim sbuilder new stringbuilder() sbuilder.append("<html xmlns:v=""urn:schemas-microsoft-com:vml"" xmlns:o=""urn:schemas-microsoft-com:office:office"" xmlns:x=""urn:schemas-microsoft-com:office:excel"" xmlns=""http://www.w3.org/tr/rec-html40""> <head><meta http-equiv=""content-type"" content=""text/html;charset=windows-1252""><!--[if gte mso 9]><xml><x:excelworkbook><x:excelworksheets><x:excelworksheet><x:name>exporttoexcel</x:name><x:worksheetoptions><x:panes></x:panes></x:worksheetoptions></x:excelworksheet></x:excelworksheets></x:excelworkbook></xml><![endif]--></head> <body>") sbuilder.append(swriter.tostring() & "</body></html>") response.write(sbuilder.tostring()) response.end() i have dutch language in page default set hence grid displays on page right while doing export excel, shows exported in english. how can preserve language while exporting excel?
i utilize open xml sdk , create "real" excel document.
asp.net gridview localization export-to-excel
No comments:
Post a Comment