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

1) Add a reference in your Visual Studio project to docuPrinter library.
To do this:
  • On the Project menu, click Add Reference;
  • On the COM tab, locate docuPrinter Library and then click Select;
  • 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:
  • On the Project menu, click Add Reference.
  • On the COM tab, locate Microsoft Excel and then click Select.
  • Click OK in the Add References dialog box to accept your selections.
private void button1_Click(object sender, EventArgs e)
{

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

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

    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!!!");
    }

}



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