01-27-2011, 05:43 PM
Searched all over this forum and found lots of bits of code which required that you knew the rest of the code.
I want to be more specific about my question
I have an Excel file called: testdata.xlsx in the folder "C:\temp"
In this file I have a sheet called "release 1". In the sheet I have 3 columns which looks as follows:
Column A: UserID
Column B: FirstName
Column C: LastName
In my web application, I have 3 WebEdit fields also called UserID, FirstName and LastName
So how should the code look like if I want to retrieve the data from the 3 columns in Excel and populate the WebEdit's in my web application ?
I want to be more specific about my question
I have an Excel file called: testdata.xlsx in the folder "C:\temp"
In this file I have a sheet called "release 1". In the sheet I have 3 columns which looks as follows:
Column A: UserID
Column B: FirstName
Column C: LastName
In my web application, I have 3 WebEdit fields also called UserID, FirstName and LastName
So how should the code look like if I want to retrieve the data from the 3 columns in Excel and populate the WebEdit's in my web application ?