whats new ¦  programming tips ¦  indy articles ¦  intraweb articles ¦  informations ¦  links ¦  interviews
 misc ¦  tutorials ¦  Add&Win Game

Tips (1541)

Database (90)
Files (137)
Forms (107)
Graphic (114)
IDE (21)
Indy (5)
Internet / LAN (130)
IntraWeb (0)
Math (76)
Misc (126)
Multimedia (45)
Objects/
ActiveX (51)

OpenTools API (3)
Printing (35)
Strings (83)
System (266)
VCL (242)

Top15

Tips sort by
component


Search Tip

Add new Tip

Add&Win Game

Advertising

48 Visitors Online


 
...print an Excel file?
Autor: Thomas Stutz
[ Print tip ]  

Tip Rating (20):  
     


{
  This is a simple example how to print an Excel file using OLE.
}

{
  Dies ist ein einfaches Beispiel, um eine Excel Datei über OLE im Hintergrund
  auszudrucken.
}

uses
  
ComObj;

procedure TForm1.Button1Click(Sender: TObject);
var
  
ExcelApp: OLEVariant;
begin
  
// Create an Excel instance
  // Excel Instanz erzeugen
  
ExcelApp := CreateOleObject('Excel.Application');
  try
    
ExcelApp.Workbooks.Open('C:\test\xyz.xls');
    // you can also modify some settings from PageSetup
    // Man kann auch noch einige Einstellungen von "Seite Einrichten" anpassen
    
ExcelApp.ActiveSheet.PageSetup.Orientation := xlLandscape;
    // Print it out
    // Ausdrucken
    
ExcelApp.Worksheets.PrintOut;
  finally
    
// Close Excel
    // Excel wieder schliessen
    
if not VarIsEmpty(ExcelApp) then
    begin
      
ExcelApp.Quit;
      ExcelApp := Unassigned;
    end;
  end;
end;

 

Rate this tip:

poor
very good


Copyright © by SwissDelphiCenter.ch
All trademarks are the sole property of their respective owners