PlanDate = ws.get_Range( " A6", ).Text.ToString() String eDate = ws.get_Range( " A5", ).Text.ToString() String sDate = ws.get_Range( " A4", ).Text.ToString() String check = ws.get_Range( " A1", ).Text.ToString() īranchID = ws.get_Range( " A2", ).Text.ToString() Out int iChecked, out string templatetype) Out string planDate, out DateTime startDate, out DateTime endDate, Private void ReadDataSource(Worksheet ws, out string branchID, Please verify the document and uploaded again" ReturnVal = " The version is not corrected, If(templatetype.ToUpper() != _templatetype.ToUpper()) ReturnVal = " Please verify the data before upload to the server!" Out branchID, out planDate, out startDate, out endDate,
Using the Code Step 1: Create the Excel Template Based on Requirement
The AdventureWorks database could be downloaded from the Microsoft download center.
Secondly, all the salesmen are experts in Excel and the training will be much easier. First of all, it’s cheaper because no additional software/hardware is needed.
Then an offline solution is needed and using Excel template is the best solution. But most of the salesmen travel a lot and they cannot access the site on-time.
The end user could download the template and fill it in and then upload it to the server, and the server will read the template and update the database. This is a sample to create an Excel template for a specified purpose.