Hi, I want to search a DLL in order to converting an excel file (.xls) to .pdf file in .Net or ASP.Net.
I have searched in many site and infragistics.com site but I can’t find it.
Please, can you introduce it to me!
Thank you!
Hi,
We do not have a component that converts an Excel file directly into a PDF document, however, we do have an Excel library and we also have a PDF library. Several conversion techniques come to mind. The following descriptions are high-level to give an overview of how this could be done:
Direct manual conversion - Instantiate an Infragistics Workbook oject (the Excel file), and a Document object (the PDF file that will be generated) and then iterate through the Workbook object while creating PDF objects that are populated with your Excel data. I would imagine iterating through the rows and cells of the Excel file while you create and populate a PDF "table" and populate its rows and cells with the Excel data.
Using WinGrid, DataSet with the Excel file as the data source, and WinGridDocumentExporter - In this technique, you can load an Excel file into a DataSet (link below). You then bind the DataSet to WinGrid and then use the WinGridDocumentExporter to export the WinGrid data into a PDF document.
Links to resources:
WinGrid - http://help.infragistics.com/NetAdvantage/WinForms/2010.2/CLR2.0/?page=WinGrid.html
WinGridDocumentExporter- http://help.infragistics.com/NetAdvantage/WinForms/2010.2/CLR2.0/?page=WinGridDocumentExporter.html
Open Excel file with OLEDB - http://www.codeproject.com/KB/office/excel_using_oledb.aspx
That make the control worthless. I can open excel and embed it in a panel. I thought this would be easier as a control; but your limitation breaks the deal. Just say'in.