Creating or Renaming Column of DataTable at RunTime.

[Girish_Pai]

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.

[Saket]

Hi Girish,

How did you added the script? You can name a sheet at the time of adding it runtime
DataTable.AddSheet <<sheetname>>

[supputuri]

Hi Girish_Pai,

Yes, we can use AddParameter method to add/rename the column name.

Code:

Datatable.GetSheet("NewSheetName").AddParameter "DesiredColName",""

Let me know if you need any more info.

[Saket]

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

[Girish_Pai]

Thank you... I am able to work on it... Thank you very much.

[udaymusunuri]

how can add this column in place of column header i.e replacing column header "A"

[ravi.gajul]

Code:

DataTable.Getsheet("<sheetname>").Addparameter "<columnname>","value"