cxGrid导出到Excel,对于Currency类型总是加上了货币符号,可以修改导出文件设置来去掉:
在cxXLSExport.pas文件中,修改:
procedure TcxXLSExportProvider.SetCellDataCurrency(const ACol, ARow: Integer; const AValue: Currency); begin if xlsCheckPos(ACol, ARow) then //FCells.SetCellDataCurrency(ACol, ARow, AValue); FCells.SetCellDataDouble(ACol, ARow, AValue); end;