Conversion of Excel file to pdf getting error

You're using Excel Interop to convert Excel to PDF, it requires a lot such as the right version of MS Excel must be installed and right system of your machine. Not clear about your exception, but you can try some other solution provided by 3rd party library. This definitely saves your time. Remember to reference the dll of C# Excel component befor you can run the code


// load Excel file
Workbook workbook = new Workbook();
workbook.LoadFromFile("D:\\test.xlsx");

// Set PDF template
PdfDocument pdfDocument = new PdfDocument();
pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape; pdfDocument.PageSettings.Width = 970;
pdfDocument.PageSettings.Height = 850;

//Convert Excel to PDF using the template above
PdfConverter pdfConverter = new PdfConverter(workbook);
PdfConverterSettings settings = new PdfConverterSettings();
settings.TemplateDocument = pdfDocument;
pdfDocument = pdfConverter.Convert(settings);

// Save and preview PDF
pdfDocument.SaveToFile("sample.pdf");

Hey!
Did you check if it's a permission issue?  It's possible that you are trying to save the file to a location and .NET doesn't have the permissions to write to that location. Meanwhile you can try this article

http://stackoverflow.com/questions/4408336/system-runtime-interopservices-comexception-0x800a03ec