把DBGrid1数据集转换成execl文件 我要把把DBGrid1数据集转换成execl文件怎么办?在这个地方有pas单元F:\program files\Borland\Delphi7\Ocx\Servers请哪位大虾指教一下怎么用,谢谢。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 procedure DBGridToExcel(Grid: TDBGrid);var xlApp: Variant; XlWorkBook: Variant; xlworkSheet: Variant; LCID, I, J: integer; FileName: string;begin xlapp := CreateOleObject('Excel.application'); XlApp.Visible := False; xlWorkBook := xlApp.Workbooks.Add(-4167); xlWorkSheet := xlapp.WorkBooks[1].Worksheets['sheet1']; Grid.DataSource.DataSet.DisableControls; I := 1; for J := 0 to Grid.FieldCount - 1 do xlWorksheet.Cells[i, j + 1] := Grid.Columns[j].Title.Caption; I := 2; Grid.DataSource.DataSet.First; while not Grid.DataSource.DataSet.eof do begin for J := 0 to Grid.FieldCount - 1 do xlworksheet.Cells[i, j + 1] := Grid.Fields[j].Value; i := I + 1; Grid.DataSource.DataSet.Next; end; Grid.DataSource.DataSet.EnableControls; xlWorkSheet.Range[xlWorkSheet.cells[1, 1], xlWorkSheet.Cells[I, Grid.FieldCount]].columns.AutoFit; xlapp.visible := True;end; idhttp的readln()函数的问题 请问如何获得当前应用程序的标题名啊? ics ftpserver 如何设置 上传 存储路径 ? 请问怎样在EXCEL中的某个SHEET第一行插入一行新数据? 关于写txt文件问题 再加100分,两百分都是你的 求救:怎么样用Delphi 实现Unsharp mask 锐化效果。 简单又剌手的问题——状态提示! CBX的Demo服务器换地址了,所以请大家到这个地方体验 高手指教,关于quary.edit的问题? 还你1001分 doublebuffered:=true后label的内容服务显示
var
xlApp: Variant;
XlWorkBook: Variant;
xlworkSheet: Variant;
LCID, I, J: integer;
FileName: string;
begin
xlapp := CreateOleObject('Excel.application');
XlApp.Visible := False;
xlWorkBook := xlApp.Workbooks.Add(-4167);
xlWorkSheet := xlapp.WorkBooks[1].Worksheets['sheet1'];
Grid.DataSource.DataSet.DisableControls;
I := 1;
for J := 0 to Grid.FieldCount - 1 do
xlWorksheet.Cells[i, j + 1] := Grid.Columns[j].Title.Caption;
I := 2;
Grid.DataSource.DataSet.First;
while not Grid.DataSource.DataSet.eof do
begin
for J := 0 to Grid.FieldCount - 1 do
xlworksheet.Cells[i, j + 1] := Grid.Fields[j].Value;
i := I + 1;
Grid.DataSource.DataSet.Next;
end;
Grid.DataSource.DataSet.EnableControls;
xlWorkSheet.Range[xlWorkSheet.cells[1, 1], xlWorkSheet.Cells[I, Grid.FieldCount]].columns.AutoFit;
xlapp.visible := True;
end;