Sometimes you may need to compare two datasheets in run time datatable.
The trick is to supply empty string in "filename" parameter of importsheet method.
Fallowing code copies global sheet's data into "NewSheet"
The trick is to supply empty string in "filename" parameter of importsheet method.
Fallowing code copies global sheet's data into "NewSheet"
Code:
DataTable.AddSheet "NewSheet"
DataTable.ImportSheet "", "Global", "NewSheet"
'Change values in global sheet , it doesnt affect newsheet's values!