piper.xl.WorkBook.get_range¶

WorkBook.get_range(sheet_name, column_range=None, startrow=0, startcol=0, cond_override=False)[source]¶

Given worksheet & column reference, calculate excel sheet range.

Example get_column_range(df, ‘D’) returns $D$2:$D$12345

Quick checks

assert(get_range(sheet_name) == '$A$2:$R$3024')
assert(get_range(sheet_name, 'D') == '$D$2:$D$3024')
assert(get_range(sheet_name, 'D:M') == '$D$2:$M$3024')

piper.xl.WorkBook.get_metadata piper.xl.WorkBook.get_styles