FastReport或QuickReport如何导出报表为XLS格式(注意不是CSV)?请说明详细方法或者有代码最好!公司急用!!
解决方案 »
- 祝哈欠老大生日快乐 嘿嘿
- 长春地区找陪聊(别歪想,只是想找人聊天)
- 请问有甚么好的表格控件可以象PowerBuilder的datawin那样的可以随意拖动并且具有打印功能的好表格??
- 有关局域网的监控问题!请大侠们不吝赐教!高分酬谢!!!
- 在delphi7中运行corba程序找不到orb_br.dll怎么办??
- 如何防止单元间的循环引用?
- 请问,一棵树,如何知道它的某一个结点是这科树的第几行, 或者,结点是在单行,还是在双行? 多谢了!
- 急....请问SQLconnection怎么连接SQL数据库解决立即给分
- !!!!!!!有关socket服务器端故障重启后重新刷新客户端用户名单的问题?????
- 如何将实例各成员值全清空
- 急!!如何在oncreate里向自己发一个消息???
- EXCEL中如何合并单元格?(ole)
ExcelApplication1.Visible[0]:=True;
ExcelApplication1.Workbooks.Add(NULL,0);
ExcelWorkbook1.ConnectTo(ExcelApplication1.Workbooks[1]);
ExcelWorksheet1.ConnectTo(ExcelWorkbook1.Sheets[1] as _WorkSheet);
i:=1;
ExcelWorksheet1.Cells.Font.Size:='12';
ExcelWorksheet1.Cells.Font.Name:=FontName;
ExcelWorksheet1.Cells.ITEM[1,1].Font.FontStyle:='Bold';
ExcelWorksheet1.Cells.ITEM[1,1].Font.Size:='16';
ExcelWorksheet1.Cells.Item[1,1]:='Unicode Report';
ExcelWorksheet1.Cells.Item[2,1]:='('+sDate+')';
ExcelWorksheet1.Columns.VerticalAlignment:=xlcenter;
ExcelWorksheet1.Cells.HorizontalAlignment:=XlLeft;
ExcelWorksheet1.Columns.Range_['A1','A2'].ColumnWidth:=14;
ExcelWorksheet1.Columns.Range_['B1','B2'].ColumnWidth:=70;
ExcelWorksheet1.Columns.Range_['C1','C2'].ColumnWidth:=30;
ExcelWorksheet1.cells.Item[1,2].HorizontalAlignment:=xlright;
ExcelWorksheet1.cells.Item[1,3].HorizontalAlignment:=xlleft;
with frmdm do
...
....对数据进行操作
...
ExcelWorksheet1.Columns.Range_['A4','B'+inttostr(i)].Borders.LineStyle:=1;;
ExcelWorksheet1.PageSetup.PaperSize:=xlPaperLetter;
ExcelApplication1.Disconnect;
ExcelApplication1.Quit;
i: Integer;
s: string;
begin
if RMPreview1.Doc = nil then
Exit; s := RMLoadStr(SRepFile) + ' (*.rmp)|*.rmp';
for i := 0 to RMFiltersCount - 1 do
s := s + '|' + RMFilters(i).FilterDesc + '|' +
RMFilters(i).FilterExt; SaveDialog.Filter := s;
SaveDialog.FilterIndex := 3;
try
if SaveDialog.Execute then
begin
RMPreview1.SaveToFile(SaveDialog.FileName, SaveDialog.FilterIndex);
showmessage('文件导出成功!');
end;
except
showmessage('文件导出失败!');
end;