public void SetCellTypeRow(int rowIndex, ExcelTableCellType type)
{
for (int column = 1; column <= NumberOfColumns; column++)
{
ExcelTableCell cell = GetCell(rowIndex, column);
if (cell != null)
{
cell.Type = type;
}
}
}
public void SetCellTypeColumn(int columnIndex, ExcelTableCellType type, List <string> values = null)
{
for (int row = 1; row <= NumberOfRows; row++)
{
ExcelTableCell cell = GetCell(row, columnIndex);
if (cell != null)
{
cell.Type = type;
if (values != null)
{
cell.ValueSelected = values;
}
}
}
}
public void SetCellTypeColumn(int columnIndex, ExcelTableCellType type, List<string> values = null)
{
for (int row = 1; row <= NumberOfRows; row++)
{
ExcelTableCell cell = GetCell(row, columnIndex);
if (cell != null)
{
cell.Type = type;
if (values != null)
{
cell.ValueSelected = values;
}
}
}
}
public void SetCellTypeRow(int rowIndex, ExcelTableCellType type)
{
for (int column = 1; column <= NumberOfColumns; column++)
{
ExcelTableCell cell = GetCell(rowIndex, column);
if (cell != null)
{
cell.Type = type;
}
}
}
