保存的代码我是这么写的if SaveDlg.Execute then sName:=SaveDlg.FileName;
if sName<>'' then ExportGridToExcel(sName,cxGrid1,true,true,true);cxgrid显示3.72,但导出excel后却变成3.7188。请问有人知道为什么么??
if sName<>'' then ExportGridToExcel(sName,cxGrid1,true,true,true);cxgrid显示3.72,但导出excel后却变成3.7188。请问有人知道为什么么??
解决方案 »
- delphi 遇到问题,通过listbox达到在数据库中的删除操作
- 如何向网页对话框发送确认消息?
- Delphi能与C++ Builder同时安装吗?
- 在使用delphi6/kylix2 soap/webservice程序设计篇产生的问题!
- 怎样将一个Html的颜色值转换成Delphi的TColor颜色,并将该颜色应用于某Edit,答对马上给分!
- 一个错误提示!急急!!!在线等待!
- 请问在DELPHI 中怎么调用PB 所写的DLL 库(100分求解)
- 哪里有制作中国式报表的控件,支持Delphi6的,急!
- 100分回报,急!急!急!VC++语句用DELPHI如何表示
- 请问如何用FTP命令在两台服务器间传输文件?
- Delphi程序员大调查:平均每天写多少行代码?
- delphi中system.duc为什么不能加载
select BM as '部門',YS as '年份',
CAST(CONVERT(numeric(18,2),M1) as varchar(100))+'%' as M1,CAST(CONVERT(numeric(18,2),M2) as varchar(100))+'%' as M2,
CAST(CONVERT(numeric(18,2),M3) as varchar(100))+'%' as M3,CAST(CONVERT(numeric(18,2),M4) as varchar(100))+'%' as M4,
CAST(CONVERT(numeric(18,2),M5) as varchar(100))+'%' as M5,CAST(CONVERT(numeric(18,2),M6) as varchar(100))+'%' as M6,
CAST(CONVERT(numeric(18,2),M7) as varchar(100))+'%' as M7,CAST(CONVERT(numeric(18,2),M8) as varchar(100))+'%' as M8,
CAST(CONVERT(numeric(18,2),M9) as varchar(100))+'%' as M9,CAST(CONVERT(numeric(18,2),M10) as varchar(100))+'%' as M10,
CAST(CONVERT(numeric(18,2),M11) as varchar(100))+'%' as M11,CAST(CONVERT(numeric(18,2),M12) as varchar(100))+'%' as M12 from HR_MH_LEAV
where BM NOT in (select NOTBM from RES_QJ_RULE where NOTBM IS NOT NULL )
非常感谢kye_jufei的热心回复,不过CAST(CONVERT(numeric(18,2),M1) as varchar(100))+'%' as M1 这样的语句在我这边不能执行,提示 Illegal character in input file: '%' ($25)
format$("100123","Fixed") 返回值 100123.00多谢以上两位的热心帮助