Export data from excel to pdf

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

Export data from excel to pdf

Postby lilyed72 » Mon Jan 24, 2011 6:05 am

Hi,

I noticed your free dataexport, and i want to use it to export my excel data to a new PDF file, could you please kindly tell me how to do it with your free dataexport?

Thanks
lilyed72
 
Posts: 5
Joined: Mon Dec 27, 2010 1:24 am

Re: Export data from excel to pdf

Postby iceblue support » Mon Jan 24, 2011 9:27 am

Thank you for your inquiry.
Yes, you could use Spire.DataExport to export data from Excel to PDF.
1. Use OleDbConnection open the xls file as a DataSource
Code: Select all
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString
= @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your.xls;Extended Properties=""Excel 8.0""";

2. Create an OleDbCommand object
3. Use PDFExport to export data from OleDbCommand to a pdf file.
e-iceblue support
User avatar
iceblue support
 
Posts: 244
Joined: Tue Dec 21, 2010 2:56 am


Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests