Re: Datagridview and Excel...

I was actually thinking that you handle the error on your side. Obviously,
you can't expect the user to edit the spreadsheet everytime they generate
one.

But at least for the moment you know that is precisely the problem.

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


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

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.

--
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.
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.