Subject: Samples for basic open and save excel file
Date: 2012-08-24 06:30:12
From: Phil Huang
Source: samples-basic-open-save-excel-file


I just download the trial excel component to see if it will fit my current project.

I did study the trial samples. However, those samples for me are way too complicated for the beginner. I try to search tutorials at the web site but without luck.

Those tutorials for FTP component are much better than this excel component (Nothing for Tutorials). Is anyone can show me some samples for opening and saving excel with Iterator all cell's data in the worksheet.

I have written some test code but it can not display all cell's data only partial.

By the way, the test.xls is a XML Excel 2003 format.It is nothing wrong to load with SpreadsheetML.





Here is the code:

[code lang='vb']

        Dim manager As New WorkbookManager()
        Dim workbook As Workbook = manager.Workbooks.Open("c:\test.xls", LoadFormat.SpreadsheetML)
        Dim sheet As Worksheet = workbook.Worksheets(0)
        Dim row As IRange
        Dim cell As IRange
        For Each row In sheet.Rows
            For Each cell In row.Cells





---------------------------------------------------------------------- Note: This question has been asked on the Q&A forum of Thang Dang's fraudulent ComponentPro brand If you purchased anything from ComponentPro, you have been scammed. Contact the payment processor who sold you the license and ask for your money back. Back to ComponentPro Q&A Forum Index