We take a very simple example to demonstrate the use of formulae in Excel sheets.
For this recipe, we will use the same
xlsxwriter module and add formulae to the cells. There are numerous operations that are supported by Excel sheets, such as getting standard deviation of data, logarithm, getting trends among others, so it's worth spending time to understand the majority of available operations.
You need to perform the following step:
We work with a simple example, wherein we add a list of numbers with the
SUM() formula and store the sum to the cell A1:
import xlsxwriter workbook = xlsxwriter.Workbook('formula.xlsx') worksheet = workbook.add_worksheet() worksheet.write_formula('A1', '=SUM(1, ...