05-17-2011, 04:50 PM
try this:
1. store excel file in the qc
2. set qc path where you have stored excel file in folder option
3. path = pathfinder.locate(<your file name>)
4. datatable.importsheet path, sourcesheet, destinationsheet
1. store excel file in the qc
2. set qc path where you have stored excel file in folder option
3. path = pathfinder.locate(<your file name>)
4. datatable.importsheet path, sourcesheet, destinationsheet