以下是delphi控制Excel的打印,問題是只能打印一個Sheet,要如何做到一起打印所有Sheetvar
FExcelApp: Variant FExcelApp := CreateOleObject('Excel.Application');
FExcelApp.Visible := False;
FExcelApp.WorkBooks.Open(FInFile);
FExcelApp.WorkSheets[1].Activate;
FExcelApp.ActiveSheet.PrintOut;
FExcelApp.WorkBooks.Close;
FExcelApp.Quit;
FExcelApp := Unassigned;
FExcelApp: Variant FExcelApp := CreateOleObject('Excel.Application');
FExcelApp.Visible := False;
FExcelApp.WorkBooks.Open(FInFile);
FExcelApp.WorkSheets[1].Activate;
FExcelApp.ActiveSheet.PrintOut;
FExcelApp.WorkBooks.Close;
FExcelApp.Quit;
FExcelApp := Unassigned;
FExcelApp.Visible := False;
FExcelApp.WorkBooks.Open(FInFile);
for i := 1 to FExcelApp.worksheets.count do
begin
FExcelApp.worksheets[i].activate;
FExcelApp.ActiveSheet.PrintOut;
end;
FExcelApp.WorkBooks.Close;
FExcelApp.Quit;
FExcelApp := Unassigned;
這個要怎麼實現呢?