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
----------------------------------------------------------------------


 HI,

 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.

 Thanks

  

 Phil

  

 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

                 Debug.Write(cell.Value.ToString)

             Next

             Debug.WriteLine("")

         Next

  

  

  

 [/code]

----------------------------------------------------------------------

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