Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

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

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: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.DataExport