09-04-2008, 07:38 PM
Code:
'add a New Colum
DataTable.GetSheet("dtGlobalSheet").AddParameter "NewColumn","Row1Value"
'copy the cells from the old column into the new column
cnt=DataTable.GetRowCount
For i=1 to cnt
DataTable.SetCurrentRow(i)
OldVal=DataTable.Value("OldColumn","dtGlobalSheet")
DataTable.Value("NewColumn","dtGlobalSheet")=OldVal
Next
'delete the old column
DataTable.GetSheet("dtGlobalSheet").DeleteParameter("OldColumn")
Regards