Convert Excel to other formats

[Bengt]

Can an Excel file be exported to another format?

I need an Excel file to end up in a PDF document. Since the PDF component can import HTML and images, is it possible to convert the Excel file to any of these formats, and then import it to the PDF document?

[Sri Subhashini M]

Hi,

I regret to let you know that currently we do not provide support for this feature "Exporting Excel into PDF format in XlsIO". We have notified our development team on this regard and will get back to you once we hear back from them.

Regards,
Suba.

[Chad Dunham]

I was wondering if anything was ever added in with this? Basically I have some excel sheets that I would like to programmatic convert to those to PDF for display purposes.

Thanks

Chad

[Bhuvaneswari P]

Hi Chad,

We don't have direct option for this feature. However, as a workaround we can achieve this by converting the Worksheet as image and insert this image into the PDF document. Worksheet to image feature is partially completed in our latest version V7.1.0.21. Also we have implemented option to convert Worksheet to EMF image, currently it’s under testing. This feature will be available in our next weekly development build.

Code snippet:

// Convert the worksheet to image
Image img = sheet.ConvertToImage(1, 1, 33, 7);

//To insert Image into PDF file
PdfPage page = section.Pages.Add();
PdfGraphics g = page.Graphics;
PdfImage image = new PdfBitmap(img);                
g.DrawImage(image, 80, 40);

Here is the simple sample for Worksheet ->Image -> PDF:

http://websamples.syncfusion.com/samples/DocIO.Windows/I53364/main.htm

Here is the documentation link for more details:

http://help.syncfusion.com/ug_71/xlsio/ConvertToImage.html

Please try this and let us know if this helps you.

Best Regards,
Bhuvana

[Administrator]

Hi,

http://help.syncfusion.com/ug_71/xlsio/ConvertToImage.html

It Shows Runtime Error.