Code Samples - Neevia docuPrinter SDK

Example 4: Convert a MS Excel document into PDF - Delphi Copy 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
   procedure TForm1.Button1Click(Sender: TObject);
   var
     RVal : Integer;
     DPSDK,
     MSExcel,
     XLDoc           : Variant;
     docToConvert    : String;
   begin

      docToConvert:='c:\users\public\test.xls';

      try
        DPSDK:=CreateOleObject('docuPrinter.SDK');
        DPSDK.DocumentOutputFormat:= 'PDF';
        DPSDK.DocumentOutputName:= 'demoXLS';
        DPSDK.DocumentOutputFolder:= 'c:\users\public\';

        DPSDK.HideSaveAsWindow:= true;
        DPSDK.DefaultAction:=1;
        DPSDK.ApplySettings;

        try
          MSExcel:= CreateOleObject('Excel.Application');
          MSExcel.DisplayAlerts:= False;
          XLDoc:= MSExcel.Workbooks.Open(docToConvert, 0, True);

          XLDoc.Activate;
          XLDoc.PrintOut(emptyparam,emptyparam,
          emptyparam, False, 'docuPrinter');
          XLDoc.Saved:= True;
          XLDoc.Close;
          MSExcel.Quit;

          RVal:= DPSDK.Create; // Create output document
          If (RVal <> 0) Then 
            ShowMessage('Error while creating document!!! Code: '+IntToStr(RVal))
          else
            ShowMessage('Document Created !!!');

        except
          on E: Exception do
            ShowMessage(E.Message);
        end;
      finally
        DPSDK:= Unassigned;
        MSExcel:= Unassigned;
      end;  

   end;