Reading Excel file into datagrid asp.net

[Omar]

Hello Allo,
I am creating a page that allows a user to upload an excel file, and
display the contents in a datagrid. The problem I am having now is
that, some of the columns have both numeric and alphanumeric data.
How
can I upload the file into a datagrid as it is? Is it possible? I do
not want ASP.NET to automatically determine the data type. Is it
possible to just upload the numbers as strings as well? What are my
other options? Thanks in advance for your help.

The problem is similar to

http://www.mcse.ms/message519804.html

I have also posted this in excel programming section.


Regards

 

[Mark Rae]

Is it possible?
Yes.

I do not want ASP.NET to automatically determine the data type.

Ah - well, that pretty much rules ADO.NET out...

What are my other options?

http://www.aspose.com/Products/Aspose.Cells/Default.aspx