How to convert Entire Excel Workbook into PDf in C#

Nilesh Patil

Hi All,

My below code is working fine for convert excel document to PDF but its not Convert Entire Excel Doc Some Large excel Content Are cut

Please help me this is my code

public short excel2Pdf(string originalXlsPath, string pdfPath)

{

Console.WriteLine("Class: " + GetType() + " Method: " + MethodBase.GetCurrentMethod().Name + " Started ");

short convertExcel2PdfResult = -1;

// Create COM Objects

Microsoft.Office.Interop.Excel.Application excelApplication = null;

Microsoft.Office.Interop.Excel.Workbook excelWorkbook = null;

object unknownType = Type.Missing;

// Create new instance of Excel

try

{

//open excel application

excelApplication = new Microsoft.Office.Interop.Excel.Application

{

ScreenUpdating = false,

DisplayAlerts = false

};

//open excel sheet

if (excelApplication != null)

excelWorkbook = excelApplication.Workbooks.Open(originalXlsPath, unknownType, unknownType,

unknownType, unknownType, unknownType,

unknownType, unknownType, unknownType);

if (excelWorkbook != null)

{

// Call Excel's native export function (valid in Office 2007 and Office 2010, AFAIK)

excelWorkbook.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF,

pdfPath,

unknownType, unknownType, unknownType, unknownType, unknownType,

unknownType, unknownType);

convertExcel2PdfResult = 0;

}

else

{

Console.WriteLine("Error occured for conversion of office excel to PDF ");

convertExcel2PdfResult = 504;

}

catch (Exception exExcel2Pdf)

{

Console.WriteLine("Error occured for conversion of office excel to PDF, Exception: ", exExcel2Pdf);

convertExcel2PdfResult = 504;

}

finally

{

// Close the workbook, quit the Excel, and clean up regardless of the results...

if (excelWorkbook != null)

excelWorkbook.Close(unknownType, unknownType, unknownType);

if (excelApplication != null) excelApplication.Quit();

Util.releaseObject(excelWorkbook);

Util.releaseObject(excelApplication);

}

Console.WriteLine("Class: " + GetType() + " Method: " + MethodBase.GetCurrentMethod().Name + " Ended ");

return convertExcel2PdfResult;

}

5 Replies

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

Mageshwaran R6y ago
Hi,
Can you check with the below link:
https://www.iditect.com/tutorial/xlsx-to-pdf/
Atir Tahir7y ago
You must give a try to GroupDocs.Conversion for .NET. Aside converting a complete spreadsheet to PDF, there is a feature to do partial spreadsheet conversion.
For example, if you have a spreadsheet with 10,000 of rows and you only want to conver 5000 to 7000 rows. Most of the time there are empty rows and columns in a spreadsheet and the conversion APIs/tools take time to do conversion of such a huge file.
But GroupDocs.Conversion for .NET allows you to skip empty rows and columns.
string sourcePath = "source file path";
string targetPath = "target / output file path";

string fileName = "source file.xlsx";

var conversionConfig = new ConversionConfig { StoragePath = sourcePath, OutputPath = targetPath};
var conversionHandler = new ConversionHandler(conversionConfig);

SpreadsheetLoadOptions loadOptions = new SpreadsheetLoadOptions();
//if you want to do partial/selected conversion
loadOptions.ConvertRange = "D1:F7";
//if you want to skip empty rows and columns
loadOptions.SkipEmptyRowsAndColumns = true;

PdfSaveOptions saveOptions = new PdfSaveOptions();
var convertedDocumentPath = conversionHandler.Convert(fileName, loadOptions, saveOptions);
convertedDocumentPath.Save(Path.GetFileNameWithoutExtension(fileName));
Get API resources here https://products.groupdocs.com/comparison/net.
Mohamed Abedallah7y ago
Try to use LEADTOOLS, since it supports converting from and to different file formats. The code is simple and similar to this:
using (DocumentConverter documentConverter = new DocumentConverter())
{
var inFile = @"C:\temp\input.XLS";
var outFile = @"C:\temp\output.PDF";
var format = DocumentFormat.Pdf;
var jobData = DocumentConverterJobs.CreateJobData(inFile, outFile, format);
jobData.JobName = "conversion job";
var job = documentConverter.Jobs.CreateJob(jobData);
documentConverter.Jobs.RunJob(job);
}
It also supports converting a wide set of common file formats. For more information see this link:
https://www.leadtools.com/sdk/document/document-converter
Uehara Ayaka8y ago
check this link

https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Conversion/NET-Excel-New-method-of-Convert-Excel-to-PDF.html
Sagar Pandurang Kap8y ago
Hi,
Refer below links :-

https://stackoverflow.com/questions/35430582/how-to-convert-excel-workbook-to-pdf-without-using-excel-interop-library
https://www.gemboxsoftware.com/spreadsheet/articles/c-sharp-vb-net-convert-excel-to-pdf
https://sautinsoft.com/convert-excel-xls-to-pdf/xlsx-to-pdf-dotnet-csharp.php
https://forums.asp.net/t/2119767.aspx?Exporting+multiple+sheets+to+PDF

Hope it helps......