Example #1
0
        private void PrintExcelBtnClick(object sender, RoutedEventArgs e)
        {
            if (this.textBox1.Text != String.Empty && (string)this.textBox1.Tag != string.Empty)
            {
                if (File.Exists((string)this.textBox1.Tag))
                {
                    ExcelEngine  engine      = new ExcelEngine();
                    IApplication application = engine.Excel;
                    IWorkbook    book        = application.Workbooks.Open((string)textBox1.Tag);

                    //Open the Excel Document to Convert
                    ExcelToPdfConverter converter = new ExcelToPdfConverter(book);

                    if (printWithPrinterBtn.IsChecked == true || printWithConverterAndPrinterBtn.IsChecked == true)
                    {
                        //Create new printdialog instance.
                        System.Windows.Forms.PrintDialog printDialog = new System.Windows.Forms.PrintDialog();
                        printDialog.AllowSomePages = true;
                        if (printDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
                        {
                            if (printWithConverterAndPrinterBtn.IsChecked == true)
                            {
                                //Print excel document with specified printer settings and converter settings.
                                converter.Print(printDialog.PrinterSettings, GetConverterSettings());
                                this.Close();
                            }
                            else
                            {
                                //Print excel document with specified printer settings.
                                converter.Print(printDialog.PrinterSettings);
                                this.Close();
                            }
                        }
                    }
                    else if (printWithConverterBtn.IsChecked == true)
                    {
                        //Print excel document with specified and converter settings.
                        converter.Print(GetConverterSettings());
                        this.Close();
                    }
                    else if (defaultPrintBtn.IsChecked == true)
                    {
                        //print excel document with default printer settings.
                        converter.Print();
                        this.Close();
                    }
                }

                else
                {
                    MessageBox.Show("File doesn’t exist");
                }
            }
            else
            {
                MessageBox.Show("Browse an Excel document to convert to Pdf", "Error", MessageBoxButton.OK, MessageBoxImage.Exclamation);
            }
        }
Example #2
0
        private void printExcelBtnClick(object sender, EventArgs e)
        {
            if (this.textBox1.Text != String.Empty)
            {
                ExcelEngine  engine      = new ExcelEngine();
                IApplication application = engine.Excel;
                IWorkbook    book        = application.Workbooks.Open((string)textBox1.Tag);
                // Initialize the chart to image converter.
                application.ChartToImageConverter = new ChartToImageConverter();
                //Set the Quality of chart Image
                application.ChartToImageConverter.ScalingMode = ScalingMode.Best;
                //Open the Excel Document to Convert
                ExcelToPdfConverter converter = new ExcelToPdfConverter(book);

                if (printWithPrinterBtn.Checked || printWithConverterAndPrinterBtn.Checked)
                {
                    //Create new printdialog instance.
                    PrintDialog printDialog = new PrintDialog();
                    printDialog.AllowSomePages = true;
                    if (printDialog.ShowDialog() == DialogResult.OK)
                    {
                        if (printWithConverterAndPrinterBtn.Checked)
                        {
                            //Print excel document with specified printer settings and converter settings.
                            converter.Print(printDialog.PrinterSettings, GetConverterSettings());
                            this.Close();
                        }
                        else
                        {
                            //Print excel document with specified printer settings.
                            converter.Print(printDialog.PrinterSettings);
                            this.Close();
                        }
                    }
                }
                else if (printWithConverterBtn.Checked)
                {
                    //Print excel document with specified and converter settings.
                    converter.Print(GetConverterSettings());
                    this.Close();
                }
                else if (defaultPrintBtn.Checked)
                {
                    //print excel document with default printer settings.
                    converter.Print();
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("Browse a word document and click the button to convert as a PDF.");
            }
        }
        //
        // GET: /ExcelToPDF/

        public ActionResult Print(string button, string Group1, string Group2)
        {
            if (button == null)
            {
                return(View());
            }
            else if (button == "Input Template")
            {
                //Step 1 : Instantiate the spreadsheet creation engine.
                ExcelEngine excelEngine = new ExcelEngine();
                //Step 2 : Instantiate the excel application object.
                IApplication application = excelEngine.Excel;
                IWorkbook    workbook    = application.Workbooks.Open(ResolveApplicationDataPath(@"ExcelTopdfwithChart.xlsx"), ExcelOpenType.Automatic);
                return(excelEngine.SaveAsActionResult(workbook, "InputTempalte.xlsx", HttpContext.ApplicationInstance.Response, ExcelDownloadType.PromptDialog, ExcelHttpContentType.Excel2013));
            }
            else
            {
                ExcelToPdfConverter converter = new ExcelToPdfConverter(ResolveApplicationDataPath("ExcelTopdfwithChart.xlsx"));
                converter.ChartToImageConverter = new ChartToImageConverter();
                //Set the image quality
                converter.ChartToImageConverter.ScalingMode = ScalingMode.Best;
                //Intialize the PdfDocument Class
                PdfDocument pdfDoc = new PdfDocument();

                //Intialize the ExcelToPdfConverterSettings class
                ExcelToPdfConverterSettings converterSettings = new ExcelToPdfConverterSettings();

                //Set the Layout Options for the output Pdf page.
                if (Group2 == "NoScaling")
                {
                    converterSettings.LayoutOptions = LayoutOptions.NoScaling;
                }
                else if (Group2 == "FitAllRowsOnOnePage")
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitAllRowsOnOnePage;
                }
                else if (Group2 == "FitAllColumnsOnOnePage")
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitAllColumnsOnOnePage;
                }
                else
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitSheetOnOnePage;
                }

                //Assign the output PdfDocument to the TemplateDocument property of ExcelToPdfConverterSettings
                converterSettings.TemplateDocument = pdfDoc;
                converterSettings.DisplayGridLines = GridLinesDisplayStyle.Invisible;

                //Create new printerSettings instance.
                PrinterSettings printerSettings = new PrinterSettings();
                printerSettings.FromPage = 1;
                printerSettings.ToPage   = 3;
                printerSettings.Collate  = true;
                printerSettings.Copies   = 2;
                printerSettings.Duplex   = Duplex.Simplex;

                if (Group1 == "DefaultPrint")
                {
                    converter.Print();
                }
                else if (Group1 == "PrintWithConverterSettings")
                {
                    converter.Print(converterSettings);
                }
                else if (Group1 == "PrintWithPrinterSettings")
                {
                    converter.Print(printerSettings);
                }
                else
                {
                    converter.Print(printerSettings, converterSettings);
                }

                return(View());
            }
        }
Example #4
0
        private void PrintExcelbtn_Click(object sender, EventArgs e)
        {
            if (this.textBox1.Text != String.Empty)
            {
                ExcelEngine  engine      = new ExcelEngine();
                IApplication application = engine.Excel;
                IWorkbook    book        = application.Workbooks.Open((string)textBox1.Tag);

                //Open the Excel Document to Convert
                ExcelToPdfConverter converter = new ExcelToPdfConverter(book);

                //Intialize the ExcelToPdfconverterSettings
                ExcelToPdfConverterSettings converterSettings = new ExcelToPdfConverterSettings();

                if (noScaleRadioBtn.Checked)
                {
                    converterSettings.LayoutOptions = LayoutOptions.NoScaling;
                }
                else if (allRowsRadioBtn.Checked)
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitAllRowsOnOnePage;
                }
                else if (allColumnRadioBtn.Checked)
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitAllColumnsOnOnePage;
                }
                else
                {
                    converterSettings.LayoutOptions = LayoutOptions.FitSheetOnOnePage;
                }

                if (printWithPrinterBtn.Checked || printWithConverterAndPrinterBtn.Checked)
                {
                    //Create new printdialog instance.
                    PrintDialog printDialog = new PrintDialog();
                    printDialog.AllowSomePages = true;
                    if (printDialog.ShowDialog() == DialogResult.OK)
                    {
                        if (printWithConverterAndPrinterBtn.Checked)
                        {
                            //Print excel document with specified printer settings and converter settings.
                            converter.Print(printDialog.PrinterSettings, GetConverterSettings());
                            this.Close();
                        }
                        else
                        {
                            //Print excel document with specified printer settings.
                            converter.Print(printDialog.PrinterSettings);
                            this.Close();
                        }
                    }
                }
                else if (printWithConverterBtn.Checked)
                {
                    //Print excel document with specified and converter settings.
                    converter.Print(GetConverterSettings());
                    this.Close();
                }
                else if (defaultPrintBtn.Checked)
                {
                    //print excel document with default printer settings.
                    converter.Print();
                    this.Close();
                }
            }
            else
            {
                MessageBox.Show("Browse a word document and click the button to convert as a PDF.");
            }
        }