SIVA

SIVA

  • NA
  • 742
  • 707.4k

How to integrate excel with asp .net

Jan 4 2012 8:22 AM
Hi All,
I have following Requirement please can anybody help me.

i have excel file with predefined template as follows with Emp.xls

 EID (B5): EName(D5):
 Designation(B6):

Now i created webform with the following textboxes

txtEID, txtName & txtDesignation with Submit button

now my requirement is If i click submit button

the values which is taken from the user through textboxes will be copied into the
following positions in the emp.xls file such as
txtEID value-----> C5cell in Excel file
txtName value --->E5cell in Excel file
txtDesignation value--> B6cell in Excel file

and the excel file has to save in some location with the filename of with Emp_EID(ID may vary to employee by employee)

how can i achieve this...





Answers (4)