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
61

   string fileToConvert = @"c:\users\public\test.xls";
   Neevia.docCreator DC = new Neevia.docCreator();

   DC.setParameter("DocumentOutputFormat", "PDF");
   DC.setParameter("DocumentOutputName", "testXLS_CSHARP");
   DC.setParameter("DocumentOutputFolder", @"c:\users\public\");
   DC.setParameter("PDFAutoRotatePage", "All");

   // 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;
   }

   string tempFile = DC.getParameter("TempDir") + DC.GUID() + ".ps";

   XLBook.Activate();
   XLBook.PrintOut(1, 9999, 1, false, "Neevia docCreator", true, 0, tempFile);

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

   DC.setParameter("DocumentResolution", "300");
   DC.setInputDocument(tempFile, "");

   int RVal = DC.create(); // Create output document
   DC.fileDelete(tempFile);
   DC = null;

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