O'Reilly logo

Automate it! - Recipes to upskill your business by Chetan Giridhar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Playing with Excel formulae

We take a very simple example to demonstrate the use of formulae in Excel sheets.

Getting ready

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.

How to do it...

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required