Hi everyone!..
i'm facing an issue with the exporter, because, when export the WebDataGrid to excel, the format of the column "Total" is a decimal type, but in the exported file, this column is now in a string type.
anyone know what happen here? :(
btw, the WebExcelExporter that i use is, Infragistics35.WebUI.UltraWebGrid.ExcelExport.v11.1
Regards!
Alfredo Melo
Hello Alfredo,
You are using the UltrawebGrid.ExcelExporter but refering to WebDataGrid which is unsupported by this exporter. The UltrawebGrid.Excel exporter support UltraWebGridOnly. If you need to export WebDataGrid you should use WebExcelExporter defined in Infragistics35.Web.UI.
Could you please send me a sample aspx page with the grid on it which you are trying to export so I can investigate it futher?
Thanks
Ivan
HI!..
i'm sorry,but i was confused about the reference that i used, the reference is WebExcelExporter, and the exported datagrid, was in string format for all columns, even if i set their properties of DataType to Decimal, the result ever was a format string, also i set the DataFormatString property of the BoundDataField with the next format :
"{0:C}" and "$ {0:###,###,##0.00}"
but the exporter catch this values like a string format
Thanks in advance.