problem with excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AVL - 27 Feb 2008 14:11 GMT

hi,

i'm facing a strange problem..

In my requirement , I'm suppose to load the data from datagrid into excel
file.
make the required changes in the file and load the file back into the
datagrid.

i'm able to export to excel but after i make changes in the excel and load
it into
grid, my changes are not visible..i'm getting null values..
i've datetime columns,decimal columns in my file...The values are visible in
the file
but when i load into grid..i'm seeing blanks spaces..

has anyone encountered such problem.? How can load from excel to datagrid

Reply to this Message

Alvin Bruney [ASP.NET MVP] - 28 Feb 2008 02:33 GMT

First order of business is to dump the XML from the Excel to see how the
data is stored. Then you can test that data type in a simple program to see
if the grid will render it.

Signature

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

> hi,
>
[quoted text clipped - 14 lines]
>
> has anyone encountered such problem.? How can load from excel to datagrid

Reply to this Message

Norman Diamond - 28 Feb 2008 02:54 GMT

If Excel is installed on the target machine then use the Office object model
(automating Excel from your program).

If you depend on the OleDb or Odbc drivers that are built in to Windows,
there is no reliable way to overcome this problem. One Knowledge Base
article says to add IMEX=1 to the connection string, but this only changes
the problem, it doesn't provide a reliable solution.

> hi,
>
[quoted text clipped - 14 lines]
>
> has anyone encountered such problem.? How can load from excel to datagrid

Reply to this Message

problem with excel

Free Magazines