@brief Set the properties for one or more columns of cells with options.
@param worksheet Pointer to a lxw_worksheet instance to be updated.
@param first_col The zero indexed first column.
@param last_col The zero indexed last column.
@param width The width of the column(s).
@param format A pointer to a Format instance or NULL.
@param options Optional row parameters: hidden, level, collapsed.
The %worksheet_set_column_opt() function is the same as
worksheet_set_column() with an additional options parameter.
The options parameter is a #lxw_row_col_options struct. It has the
following members but currently only the hidden property is supported:
- hidden
- level
- collapsed
The "hidden" option is used to hide a column. This can be used, for
example, to hide intermediary steps in a complicated calculation:
@brief Set the properties for one or more columns of cells with options.
@param worksheet Pointer to a lxw_worksheet instance to be updated. @param first_col The zero indexed first column. @param last_col The zero indexed last column. @param width The width of the column(s). @param format A pointer to a Format instance or NULL. @param options Optional row parameters: hidden, level, collapsed.
The %worksheet_set_column_opt() function is the same as worksheet_set_column() with an additional options parameter.
The options parameter is a #lxw_row_col_options struct. It has the following members but currently only the hidden property is supported:
- hidden - level - collapsed
The "hidden" option is used to hide a column. This can be used, for example, to hide intermediary steps in a complicated calculation:
@code lxw_row_col_options options = {.hidden = 1, .level = 0, .collapsed = 0};
worksheet_set_column_opt(worksheet, COLS("A:A"), 8.43, NULL, &options); @endcode