Problem in accessing 4 decimal values while uploading excel into asp.net c#

Posted by Prabu_Spark under ASP.NET on 10/21/2013 | Points: 10 | Views : 7956 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi sir,
Problem in accessing 4 decimal values while uploading excel into asp.net c#. I have created one website that upload one excel file containing one field 'customerid' as "5.53861.11.11.100126", but it shows null value while the other values like "1.14026836"
showing the correct values in 'customerid' field.

My question is why i cant able to read the 'customerid' field as "5.53861.11.11.100126". I can able to read the value "1.14026836". Kindly give me the solution for this problem.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 10/21/2013 [Member] [MVP] Platinum | Points: 25

0	What is the datatype of that column in excel sheet? check the data type . make sure that the column type as string Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prabu_Spark on: 10/22/2013 [Member] Starter | Points: 25

0	Hi Bandi, I tried both the text and number format in excel, but it does not work. I tried to replace the symbol "." with "-" it works well. So i need the solution , how to take more than "." values in excel to .net during the upload. Kindly give me the solution for this problem. With regards, J.Prabu. [Email:prbspark@gmail.com] Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Bandi,
I tried both the text and number format in excel, but it does not work. I tried to replace the symbol "." with "-" it works well. So i need the solution , how to take more than "." values in excel to .net during the upload.

Kindly give me the solution for this problem.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 10/22/2013 [Member] [MVP] Platinum | Points: 25

0	While uploading data from excel you have to give data type of that cell as text/string... Have you converted the cell type programmatically? Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 10/22/2013 [Member] [MVP] Platinum | Points: 25

0	Refer this link once: http://stackoverflow.com/questions/904519/how-to-show-long-numbers-in-excel/904524#904524 Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prabu_Spark on: 10/22/2013 [Member] Starter | Points: 25

0	Hi bandi, I am using text format in excel and string format in asp.net . With regards, J.Prabu. [Email:prbspark@gmail.com] Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts