problem with excel

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

ArneGarvander
Thu Feb 28 11:48:02 CST 2008

Excel is a big problem in itself. IT will arbitrarily change the data that is
loaded.
Try a zipcode with leading zeros or a social security number with keading
zero. Excel will happily throw away all leading zeros.
Try to import a '1234e45' value. Excel will happily convert the data to
scientific notation.
Excel is a corrupt program.

--
Arne Garvander
Certified Geek
Professional Data Dude


"AVL" wrote:

> 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