Dear All,
I have created a sheet in data table(Run time). But I am not able rename the columns of Sheet.
Is there method to rename column, run time?... Please help me out...
Thanks and Regards
Girish Pai.
Hi Girish,
How did you added the script? You can name a sheet at the time of adding it runtime
DataTable.AddSheet <<sheetname>>
Hi Girish_Pai,
Yes, we can use AddParameter method to add/rename the column name.
Datatable.GetSheet("NewSheetName").AddParameter "DesiredColName",""
Let me know if you need any more info.
very sorry Girish,
I misleaded and dont how I assumed that you have asked for renaming the sheet.
defintely you can rename a column using AddParameter method
Thank you... I am able to work on it... Thank you very much.
how can add this column in place of column header i.e replacing column header "A"
(08-20-2009 12:14 PM)Saket Wrote: [ -> ]very sorry Girish,
I misleaded and dont how I assumed that you have asked for renaming the sheet.
defintely you can rename a column using AddParameter method
DataTable.Getsheet("<sheetname>").Addparameter "<columnname>","value"