Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Windows Forms / WinForm General / February 2008

Tip: Looking for answers? Try searching our database.

problem with excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AVL - 27 Feb 2008 14:13 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
Arne Garvander - 28 Feb 2008 17:48 GMT
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.

Signature

Arne Garvander
Certified Geek
Professional Data Dude

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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.