Neevia Technology Sites:   www.neevia.com  |  docuPub.com  |  www.neeviaPDF.com
:: Home :: Products :: Technical Support :: About Us :: Contact Us
Technical support > Neevia docCreator code samples
Example 3: Convert a MS Excel document into PDF from C#  Print Example 

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

2) Add a reference in your 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.
   string fileToConvert = @"d:\test.xls";
   Neevia.docCreator DC = new Neevia.docCreator();

   DC.setParameter("DocumentOutputFormat", "PDF");
   DC.setParameter("DocumentOutputName", "testXLS_CSHARP");
   DC.setParameter("DocumentOutputFolder", @"d:\");
   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!!!");
   }



Copyright © 1999-2016 Neevia Technology. All Rights Reserved. Home | Products | Technical Support | About Us | Contact Us