Mapping Excel Sheet in asp.net

• • Reply

  4 years ago

  by royal ludhiana

  Royal Ludhiana

  Toronto, Canada

  Joined 7 years ago
  Hi, I am trying to import data from excel sheet in my web application(asp.net). I have employee details in my excel sheet and want to fetch the data from it and store it in a database table(sql server 2005). I am able to fetch the whole excel sheet in one go. But I want to map each column, like: If I have employee code in column A of excel sheet, then I should be able to specify this on front end. I want to specify the Fieldname(EmpCode, EmpName......and so on) with the corresponding column name(A, B, C......AA, AB....AZ) and then fetch the data. How this can be achieved? Regards, Royal
  Report abuse