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