I need to upload excel sheet as below.
From the excel sheet read Area, Territory, Product Group, Package Group, UOM and refer the respective tables for values based on the description and map it to table.
Initially the upload should work on simulation mode where it should validate any mismatch in any of the data in excel with the data in their respective tables and should an error report with row and field details where there is mismatch.and also program should not upload the file to table. Program should check the excel sheet data with existing data in that period and should give an error report if the data already exists in table for that period.
The program should not allow the data to be uploaded in the past periods and it should only take data in current and future periods.
How can be able to achieve this. it ll be help full if u can provide with some piece of code.
Moderator message: We do not consider it good style to ask questions before trying to find the solution yourself.Please refer in your text also to what you have done already to solve the problem and what resources you have searched or used. Please try to avoid the impression of spec dumping.
Message was edited by: Kesavadas Thekkillath