pyexcel.Sheet.set_column_at

Sheet.set_column_at(column_index, data_array, starting=0)

Updates a column data range

It works like this if the call is: set_column_at(2, [‘N’,’N’, ‘N’], 1):

    +--> column_index = 2
    |
A B C
1 3 N <- starting = 1
2 4 N

This function will not set element outside the current table range

Parameters:
  • column_index (int) – which column to be modified
  • data_array (list) – one dimensional array
  • staring (int) – from which index, the update happens
Raises:

IndexError – if column_index exceeds column range or starting exceeds row range