My asp.net application needs to read an excel file
(created at runtime) and display it as html table
on the webpage. The background/ foreground colors
in excel needs to be retained in the table.

I tried reading a few rows. But it just displays
System.__ComObject instead of displaying the values.

 excelobj.Workbooks.Open("c:/abc.xls")
 excelwksheet = excelobj.Workbooks(1).Worksheets("Sheet1")

 For iRowCtr = 1 To 5
    For iColCtr = 1 To 5
        Response.Write(excelwksheet.Cells(iRowCtr, iColCtr))
    Next
 Next

How do i get rid of this problem? Anyone who can help me out?
PLease help!


:) Cheers..
Spacy...

Hi,

You are getting "System.__ComObject" because you are trying to print an Excel Cell object rather than it's value. Basically Cell is also a com component, so when you are sending Cell object as a parameter to Response.Write() then it is showing it's type.
If you want to print the value of a perticular cell then just modify your code like :

For iRowCtr = 1 To 5
    For iColCtr = 1 To 5
        Response.Write(excelwksheet.Cells(iRowCtr, iColCtr).Value)
    Next
 Next

NOTE : you may not get "Value" in the list but try to work use it, it really works.




Hope It Helps !!
Bhaskar Ghosh

Thanks buddy! That helped a lot!!!

:)Cheers..
Spacy...