Hi,
I am not sure about deleting rows and columns in datatable. but u can delete the rows and cloumns in external file i.e,
1.Let say u want to import a file c:/file1 (it consists of 10 rows and 5 columns)
2.But u dont need all these data so u might be deleting some rows and some coumns which is the datat u dont require (Ex: c.rows(rownumber).delete, c.columns(coulmn number).delete), here c is an object whichu have to create)
3.Do not save this file , just save as file with file2 (After deleting the rows and cloumns then this might be the required one)
4.Now u can import the file2 in global sheet
5.Perfom the operation as u like.....
Please let me know if u need any code related stuff , try for some time to get the soultion and then let me know about this....
'sreekanth chilam' suggested code is for deleting columns i.e parameters only....
I am not sure about deleting rows and columns in datatable. but u can delete the rows and cloumns in external file i.e,
1.Let say u want to import a file c:/file1 (it consists of 10 rows and 5 columns)
2.But u dont need all these data so u might be deleting some rows and some coumns which is the datat u dont require (Ex: c.rows(rownumber).delete, c.columns(coulmn number).delete), here c is an object whichu have to create)
3.Do not save this file , just save as file with file2 (After deleting the rows and cloumns then this might be the required one)
4.Now u can import the file2 in global sheet
5.Perfom the operation as u like.....
Please let me know if u need any code related stuff , try for some time to get the soultion and then let me know about this....
'sreekanth chilam' suggested code is for deleting columns i.e parameters only....