Reading from excel file.
-
Hi, In my application I m using excel file to enter the values in database. It is working fine but it is giving a strange error. If in a column let A If we have value "DMIX00008" and "65400004" Then it is reading values like "65400004" but values like "DMIX00008" are coming blank. I think it is reading that column datatype as integer or numeric. But i want that column to display values as they are entered. How to rectify this problem?
-
Hi, In my application I m using excel file to enter the values in database. It is working fine but it is giving a strange error. If in a column let A If we have value "DMIX00008" and "65400004" Then it is reading values like "65400004" but values like "DMIX00008" are coming blank. I think it is reading that column datatype as integer or numeric. But i want that column to display values as they are entered. How to rectify this problem?
Hi Hemant, I think that you are filling the datatable directly from the excel. and your first value in excel is numeric. that's why this problem is occured. Try this one. first you create columns of datatable, which you want to fill. make sure that column's datatype is string. and then try to fill it. Regards, Dilip Patel
-
Hi Hemant, I think that you are filling the datatable directly from the excel. and your first value in excel is numeric. that's why this problem is occured. Try this one. first you create columns of datatable, which you want to fill. make sure that column's datatype is string. and then try to fill it. Regards, Dilip Patel
Thaks dilip_rollwala, I change the first value to alphanumetic and it works. But I cant create columns of datatable first.