uses ComObj;procedure TForm1.Button1Click(Sender: TObject); var Excel:Variant; i:integer; begin Excel:=CreateOleObject('Excel.Application'); Excel.workbooks.open('D:\test.xls'); Excel.worksheets[1].activate; Excel.Visible:=true; for i:=1 to Excel.worksheets[1].UsedRange.Rows.count do begin Memo1.Lines.Add(Excel.cells[i,3].value);//读 Excel.cells[i,3].value:='ab';//写 end; Excel.ActiveWorkBook.Save; Excel.workbooks.close; //Excel.Disconnect; Excel.quit; end;其余的根据要求自己补充即可
如果不SHELL,应该是引用组件,打开D中的工具,引用那个组件,至于具体的名字,查一下,陈省的DELPHI深度探索中有详细说明
var
Excel:Variant; i:integer;
begin
Excel:=CreateOleObject('Excel.Application');
Excel.workbooks.open('D:\test.xls');
Excel.worksheets[1].activate;
Excel.Visible:=true;
for i:=1 to Excel.worksheets[1].UsedRange.Rows.count do
begin
Memo1.Lines.Add(Excel.cells[i,3].value);//读
Excel.cells[i,3].value:='ab';//写
end;
Excel.ActiveWorkBook.Save;
Excel.workbooks.close;
//Excel.Disconnect;
Excel.quit;
end;其余的根据要求自己补充即可