Code Samples - Neevia docuPrinter SDK

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

1) Add a reference in your Visual Studio project to docuPrinter library.
To do this:
        a. On the Project menu, click Add Reference;
        b. On the COM tab, locate docuPrinter Library and then click Select;
        c. Click OK in the Add References dialog box to accept your selections.

2) Add a reference in your Visual Studio project to Microsoft Excel.
To do this:
        a. On the Project menu, click Add Reference;
        b. On the COM tab, locate Microsoft Excel and then click Select;
        c. Click OK in the Add References dialog box to accept your selections.
 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
50
51
52
53
54
55
56
57
58
59
60
   private void button1_Click(object sender, EventArgs e)
   {

       string fileToConvert = @"c:\users\public\test.xls";
       docuPrinter.SDK DPSDK = new docuPrinter.SDK();

       DPSDK.DocumentOutputFormat = "PDF";
       DPSDK.DocumentOutputName = "demoXLS";
       DPSDK.DocumentOutputFolder = @"c:\users\public\";

       DPSDK.PDFAutoRotatePage = "All";

       DPSDK.HideSaveAsWindow = true;
       DPSDK.DefaultAction = 1;
       DPSDK.ApplySettings();

       // If you have Excel 2000 or XP remove the next 2 lines
       Microsoft.Office.Interop.Excel.Application MSExcel =
       new Microsoft.Office.Interop.Excel.Application();
       Microsoft.Office.Interop.Excel._Workbook XLBook;

       // If you have Excel 2000 or XP uncomment the lines below
       // Excel.Application MSExcel = new Excel.Application();
       // Excel._Workbook XLBook;

       MSExcel.DisplayAlerts = false;

       try
       {
         // This line will work only with MS Excel XP / 2003
         XLBook = MSExcel.Workbooks.Open(fileToConvert, 0, true, 5, "", "",
         true, 2, "", false, false, false, false, 1, false);

         // for MS Excel 2000 use the line below
         // XLBook = MSExcel.Workbooks.Open(fileToConvert, 0, true, 5, "", "",
         //  true, 2, "", false, false, false, false);

       } catch {
         MSExcel.Quit();
         return;
       }

       XLBook.Activate();
       XLBook.PrintOut(1, 9999, 1, false, "docuPrinter", true, 0, "");

       XLBook.Saved = true;
       XLBook.Close(false, "", false);
       MSExcel.Quit();
       MSExcel = null;

       int RVal = DPSDK.Create(300); // Create output document            
       DPSDK = null;

       if (RVal != 0) {
          MessageBox.Show("Error while creating document!!!");
       } else {
          MessageBox.Show("Done converting!!!");
       }

   }