Excel to PDF conversion using iTextsharp C#?

Jayanta Mukherjee

5y18.2kLearn iOS Programming

Is it possible to convert xlsx files to PDF using iTextsharp and C#?

If yes, can anyone show me how?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kip Hackman5y ago
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 Girish5y ago
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 Mukherjee5y ago
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?
Sachin Singh5y ago
@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();
    }
}
Jayanta Mukherjee5y ago
Hi, @Rajanikant

I'm getting the error on your code:
'xl2PDF.MainForm.VerifyRenderingInServerForm(System.Windows.Forms.Control)': no suitable method found to override (CS0115)
Rajanikant Hawaldar5y ago
1. using System.IO;
2. using System.Data;
3. using ClosedXML.Excel;
4. using iTextSharp.text;
5. using iTextSharp.text.html.simpleparser;
6. using iTextSharp.text.pdf;
8. protected void ImportExcel(object sender, EventArgs e)
9. {
10. string filePath = Server.MapPath("~/Files/") + Path.GetFileName(FileUpload1.PostedFile.FileName);
11. FileUpload1.SaveAs(filePath);
12. using (XLWorkbook workBook = new XLWorkbook(filePath))
13. {
14. IXLWorksheet workSheet = workBook.Worksheet(1);
15. DataTable dt = new DataTable();
16. bool firstRow = true;
17. foreach (IXLRow row in workSheet.Rows())
18. {
19. if (firstRow)
20. {
21. foreach (IXLCell cell in row.Cells())
22. {
23. dt.Columns.Add(cell.Value.ToString());
24. }
25. firstRow = false;
26. }
27. else
28. {
29. dt.Rows.Add();
30. int i = 0;
31. foreach (IXLCell cell in row.Cells())
32. {
33. dt.Rows[dt.Rows.Count - 1][i] = cell.Value.ToString();
34. i++;
35. }
36. }
37. }
38. CreatePdf(dt);
39. }
40. }
41. private void CreatePdf(DataTable dt)
42. {
43. Response.ContentType = "application/pdf";
44. Response.AddHeader("content-disposition", "attachment;filename=DataTable.pdf");
45. Response.Cache.SetCacheability(HttpCacheability.NoCache);
46. StringWriter sw = new StringWriter();
47. HtmlTextWriter hw = new HtmlTextWriter(sw);
48. GridView gvCustomers = new GridView();
49. gvCustomers.DataSource = dt;
50. gvCustomers.DataBind();
51. gvCustomers.RenderControl(hw);
52. StringReader sr = new StringReader(sw.ToString());
53. Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
54. HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
55. PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
56. pdfDoc.Open();
57. htmlparser.Parse(sr);
58. pdfDoc.Close();
59. Response.Write(pdfDoc);
60. Response.End();
61. }
62. public override void VerifyRenderingInServerForm(Control control)
63. {
64. /* Verifies that the control is rendered */
65. }

Sachin Singh5y ago

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 <= pdfReader.NumberOfPages; 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();
}