procedure TForm1.FormDestroy(Sender: TObject);
begin
if not VarIsEmpty(XLApp) then
begin
XLApp.DisplayAlerts:=false;
XLApp.quit;
end;
end;
procedure TForm1.InsertData;
var
i:Integer;
sheet:variant;
begin
sheet:=xlApp.Workbooks[1].worksheets['Data'];
query1.first;
for i:=1 to query1.RecordCount do
begin
sheet.cells[i,1]:=query1.fieldbyname('档案号').asstring;
sheet.cells[i,2]:=query1.fieldbyname('姓名').asstring;
sheet.cells[i,3]:=query1.fieldbyname('身份证号').asstring;
query1.next;
end;
edit1.text:=inttostr(query1.Recordcount);
// sheet.cells[i,1]:='=Sum(A1:A10)';
end;
procedure TForm1.HandleRange;
var
Range:variant;
begin
Range:=XLApp.Workbooks[1].worksheets['Data'].range['C1:F25'];
procedure TForm1.ChangeColumns;
var
ColumnRange:variant;
begin
ColumnRange:=XLApp.Workbooks[1].worksheets['Data'].Columns;
ColumnRange.Columns[1].ColumnWidth:=5;
ColumnRange.Columns.item[1].font.bold:=true;
ColumnRange.Columns[1].Font.color:=clBlue;
end;