Re: Datagridview and Excel... -- SYSTEMIDOTNET

Mike,
I suspect that was happening. I inserted a single quote before the value in the cell that only has numbers, reloaded the spreadsheet and it worked fine. The spreadsheet is generated by an end user and I wouldn't like to have her format that column before sending the spreadsheet every time, but that could be the work around for now.

Thank you,

Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949

-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Sent: Thursday, October 29, 2009 4:46 PM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Datagridview and Excel...

Excel automatically thinks that if there is a number, it is a numeric field.
I haven't worked with Excel like that before, is there a way to change it to
a different format in the program? That would be my uneducated idea.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark

On Thu, Oct 29, 2009 at 3:33 PM, Mira, Antonio <antonio.mira@xxxxxxxxxxx>wrote:

Hello,

Even though technically this is not .net and iSeries, indirectly it is. I
am loading an Excel spreadsheet into a datagridview. One of the columns has
alphanumeric data. Now, some of the values in the cells on this column
contain only numbers. When I load the data into the datagridview, the cells
that have only numbers show up blanks on the datagridview while the cells
that have characters and numbers show up ok. This data will be used by the
application later to cross-reference it to a table on the iSeries.

Can anyone tell me why this is happening and give me any suggestions on how
to resolve this?

As always, your help is greatly appreciated...

Thank you,

Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949

This E-mail and any of its attachments may contain Time Warner
Cable proprietary information, which is privileged, confidential,
or subject to copyright belonging to Time Warner Cable. This E-mail
is intended solely for the use of the individual or entity to which
it is addressed. If you are not the intended recipient of this
E-mail, you are hereby notified that any dissemination,
distribution, copying, or action taken in relation to the contents
of and attachments to this E-mail is strictly prohibited and may be
unlawful. If you have received this E-mail in error, please notify
the sender immediately and permanently delete the original and any
copy of this E-mail and any printout.
--
This is the .net use with the System i (SystemiDotNet) mailing list
To post a message email: SystemiDotNet@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/systemidotnet
or email: SystemiDotNet-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/systemidotnet.