Click here to Skip to main content
16,017,899 members

Comments by Trighom (Top 2 by date)

Trighom 4-Sep-15 5:20am View    
Here is quick solution for converting excel file into a pdf in .net.
All it requires is to add a reference to this excel library for .net and use it like this:
ExcelFile.Load("Book1.xlsx", LoadOptions.XlsxDefault)
.Save("Book1.pdf",
new PdfSaveOptions() { SelectionType = SelectionType.EntireFile });
Trighom 3-Sep-15 4:26am View    
You can avoid the oledb connection issues by using the approach explained in this article:
How to Import or Export DataTable to Excel files from your .NET applications[^]
The code is very straightforward, it uses the methods provided by this C# library for Excel files.