Manipulating Excel

[Paulo]

using Excel;

Excel.Application ExcelApp = new Excel.ApplicationClass();
string workbookPath = Server.MapPath("excel\\produto1.xls");
Excel.Workbook excelWorkbook = ExcelApp.Workbooks.Open(workbookPath,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
string currentSheet = "Plan1";
Excel.Sheets excelSheets = excelWorkbook.Worksheets;
Excel.Worksheet excelWorksheet =
(Excel.Worksheet)excelSheets.get_Item(currentSheet );
Im using the code above, but how can I loop through all the columns and rows
of the sheet? Can you help me?

Using VS 2005 asp.net 2.0 C#

Thanks!

[Mark Rae [MVP]]

"Paulo" <pr*****@uol.com.brwrote in message
news:ut**************@TK2MSFTNGP02.phx.gbl...

Excel.Application ExcelApp = new Excel.ApplicationClass();

Im using the code above, but how can I loop through all the columns and
rows of the sheet?

You can't.

Excel, like the rest of Office, is not designed to run via server-side
Office automation - Microsoft won't support any solution which even attempts
this, because it doesn't work:
http://support.microsoft.com/default...US;q257757#kb2

To meet your requirements, you need this:
http://www.aspose.com/Products/Aspos...s/Default.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[sloan]

You can use a System.Data.OleDb.OleDbConnection and get an IDataReader
against the Excel spreadsheet.
http://support.microsoft.com/kb/316934
It would be best to avoid the excel object model, and as pointed out
already, is a really bad idea server side.


"Paulo" <pr*****@uol.com.brwrote in message
news:ut**************@TK2MSFTNGP02.phx.gbl...

using Excel;

Excel.Application ExcelApp = new Excel.ApplicationClass();
string workbookPath = Server.MapPath("excel\\produto1.xls");
Excel.Workbook excelWorkbook = ExcelApp.Workbooks.Open(workbookPath,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
string currentSheet = "Plan1";
Excel.Sheets excelSheets = excelWorkbook.Worksheets;
Excel.Worksheet excelWorksheet =
(Excel.Worksheet)excelSheets.get_Item(currentSheet );
Im using the code above, but how can I loop through all the columns and
rows of the sheet? Can you help me?

Using VS 2005 asp.net 2.0 C#

Thanks!