Excel to PDF conversion using iTextsharp C#?

Question

Is it possible to convert xlsx files to PDF using iTextsharp and C#? If yes, can anyone show me how?

Sachin Singh · Answer

@jaynta there are many free libraries with which you can convert excel to pdf as step 1. install Install-Package SautinSoft.ExcelToPdf -Version 5.4.1.20 step 2. code public static void ConvertExcelAsMemoryStream() { // Convert Excel to PDF in memory ExcelToPdf x = new ExcelToPdf(); // Set PDF as output format. x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf; string excelFile = @ "d:\MyWorkBook.xls" ; string pdfFile = Path.ChangeExtension(excelFile, ".pdf" ); byte[] pdfBytes = null; try { // Let us say, we have a memory stream with Excel data. using (MemoryStream ms = new MemoryStream(File.ReadAllBytes(excelFile))) { pdfBytes = x.ConvertBytes(ms.ToArray()); } // Save pdfBytes to a file for demonstration purposes. File.WriteAllBytes(pdfFile, pdfBytes); System.Diagnostics.Process.Start(pdfFile); } catch (Exception ex) { Console.WriteLine(ex.Message); Console.ReadLine(); } }

Rajanikant Hawaldar · Answer

using System.IO; using System.Data; using ClosedXML.Excel; using iTextSharp.text; using iTextSharp.text.html.simpleparser; using iTextSharp.text.pdf; protected void ImportExcel( object sender, EventArgs e) { string filePath = Server.MapPath( "~/Files/" ) + Path.GetFileName(FileUpload1.PostedFile.FileName); FileUpload1.SaveAs(filePath); using (XLWorkbook workBook = new XLWorkbook(filePath)) { IXLWorksheet workSheet = workBook.Worksheet(1); DataTable dt = new DataTable(); bool firstRow = true ; foreach (IXLRow row in workSheet.Rows()) { if (firstRow) { foreach (IXLCell cell in row.Cells()) { dt.Columns.Add(cell.Value.ToString()); } firstRow = false ; } else { dt.Rows.Add(); int i = 0; foreach (IXLCell cell in row.Cells()) { dt.Rows[dt.Rows.Count - 1][i] = cell.Value.ToString(); i++; } } } CreatePdf(dt); } } private void CreatePdf(DataTable dt) { Response.ContentType = "application/pdf" ; Response.AddHeader( "content-disposition" , "attachment;filename=DataTable.pdf" ); Response.Cache.SetCacheability(HttpCacheability.NoCache); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GridView gvCustomers = new GridView(); gvCustomers.DataSource = dt; gvCustomers.DataBind(); gvCustomers.RenderControl(hw); StringReader sr = new StringReader(sw.ToString()); Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f); HTMLWorker htmlparser = new HTMLWorker(pdfDoc); PdfWriter.GetInstance(pdfDoc, Response.OutputStream); pdfDoc.Open(); htmlparser.Parse(sr); pdfDoc.Close(); Response.Write(pdfDoc); Response.End(); } public override void VerifyRenderingInServerForm(Control control) { /* Verifies that the control is rendered */ }

Sachin Singh · Answer

No, itextsharp can not convert excel to pdf , however pdf to excel is possible. private void ExportPDFToExcel(string fileName) { StringBuilder text = new StringBuilder(); PdfReader pdfReader = new PdfReader(fileName); for ( int page = 1; page { ITextExtractionStrategy strategy = new LocationTextExtractionStrategy(); string currentText = PdfTextExtractor.GetTextFromPage(pdfReader, page, strategy); currentText = Encoding.UTF8.GetString(Encoding.Convert(Encoding.Default, Encoding.UTF8, Encoding.UTF8.GetBytes(currentText))); text.Append(currentText); pdfReader.Close(); } Response.Clear(); Response.Buffer = true ; Response.AddHeader( "content-disposition" , "attachment;filename=ReceiptExport.xls" ); Response.Charset = "" ; Response.ContentType = "application/vnd.ms-excel" ; Response.Write(text); Response.Flush(); Response.End(); }

Kip Hackman · Answer

You can use LEADTOOLS Document SDK technology in your application. https://www.leadtools.com/sdk/products/document You can leverage the DocumentConverter class, which does not require the Microsoft Office interop assemblies, to convert any LEADTOOLS supported file format to any other LEADTOOLS supported file format (i.e. XLS/XLSX to PDF). Here is some sample code: using (DocumentConverter _converter = new DocumentConverter()) { string inputXLSX = @ "FILE PATH TO INPUT XLS/XLSX" ; string outputPDF = @ "FILE PATH TO OUTPUT PDF" ; DocumentFormat format = DocumentFormat.Pdf; var jobData = DocumentConverterJobs.CreateJobData(inputXLSX, outputPDF, format); var job = _converter.Jobs.CreateJob(jobData); _converter.Jobs.RunJob(job); if (job.Status == DocumentConverterJobStatus.Success) { Console.WriteLine( "Success" ); } else { Console.WriteLine( "{0} Errors" , job.Status); foreach (var error in job.Errors) { Console.WriteLine( " {0} at {1}: {2}" , error.Operation, error.InputDocumentPageNumber, error.Error.Message); } } }

Sapna Girish · Answer

You could also try Spire.XLS. using Spire.Xls; namespace Excel_Worksheet_to_PDF { class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile( "Sample.xlsx" ); Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToPdf( "toPDF.pdf" ); } } }

Jayanta Mukherjee · Answer

Hi, @Sachin. But it has the trial notice "Created by unlicensed version of Excel to PDF .Net" and the random addition of the word "TRIAL". I don't want that or is there a workaround to not show that apart from purchasing it. I'm looking for a completely free with no watermark or any trial/free version printed on the PDF. Are there any other options?

Jayanta Mukherjee · Answer

Hi, @Rajanikant I'm getting the error on your code: 'xl2PDF.MainForm.VerifyRenderingInServerForm(System.Windows.Forms.Control)': no suitable method found to override (CS0115)