working with cells or cell ws[' 'this returns cell objectyou can obtain the value of the cell using the value propertyfor example print(cell valuethere is also the worksheet cell(method this provides access to cells using row and column notationd ws cell(row= column= value= row of values can also be added at the current position within the excel file using appendws append([ ]this will add row to the excel file containing and ranges of cells can be accessed using slicingcell_range ws[' ':' 'ranges of rows or columns can also be obtainedcol ws[' 'col_range ws[' : 'row ws[ row_range ws[ : the value of cell can also be an excel formula such as ws[' ''=sum( ) workbook is actually only structure in memoryit must be saved to file for permanent storage these workbooks can be saved using the save(method this method takes filename and writes the workbook out in excel format workbook workbook(workbook save('balances xlsx' sample excel file creation application the following simple application creates workbook with two worksheets it also contains simple excel formula that sums the values held in to other cells