Enter Data into hidden columns

[Manas]

Hi,

I am currently hiding few columns in the activeWorkSheet ,my question was is there a way to enter data to hidden columns still keeping the column hidden state true??

[Dinko | Tech Support Engineer]

Hi Manas,

Even if a column is hidden you can still get its cells and edit their value. For example, if you have hidden the second column "B" you can get the cells in that column and set a different value using the SetValue() method of the CellSelection object.

var workSheet =  this.radSpreadsheet.Workbook.Worksheets[0];
ColumnSelection column = workSheet.Columns[1,1];
column.SetHidden(true);
CellSelection selection = workSheet.Cells[1, 1];
selection.SetValue("Your custom Text");

More information about setting different properties of the cells is available in the Get, Set and Clear Cell Properties help article.

Regards,
Dinko
Telerik by Progress