I have a requirement where I need to handle multiple spreadsheet (Around 9 to 10 sheets) in an excel which I need to import and take the data and then use it to map in the destination profile.
Please do let me know if we can do it and what would be the best way to proceed in this scenario.
I need to map the data coming in the Excel to a flat file.
Say Excel has got each sheet with some code and name,
Sheet 1 - 100 (Personal)
Sheet 2 - 305 (Details)
and so on
I need to map it into a flat file which is comma separated file.
For an employee we would be mentioning it as,
"100","Person ID","First Name","LastName"
Please let me know what would be the effective way to proceed on this requirement.
Thank and Regards