Import an Excel File

Question

Hi frnds,

 

I have some doubt in Excel file Import on C#. While I am trying to upload an excel file to store data in the database. But In my excel file one column contains a varchar data type in backend.

 

I am trying to upload a series of numeric characters in the column. But, In between string values are there. When am trying to upload the file the string value contained data was null values in the data table.

 

When am trying to add the string contained row data at the first line in the file. It will be uploaded.

 

Please help me out of this. 

Answer 1

you need to explicitly state that the data is string, irrespective of what it contains, otherwise Excel interop will try to interprete it by itself.

 

are you using C# in backend? then specify .ToString() after reading cell value, for anyother help you need to post your code.