Posted in Tech stuff

Openpyxl tutorial

Openpyxl The openpyxl is a Python library to read and write Excel 2010 xlsx/xlsm/xltx/xltm files. Excel xlsx In this tutorial we work with xlsx files. The xlsx…

Continue Reading... Openpyxl tutorial
Posted in Tech stuff

openpyxl cycle through worksheet

To print titles of all sheets in a workbook: 0 Here’s one if you need active worksheets for your code

Continue Reading... openpyxl cycle through worksheet
Posted in Tech stuff

Working with Excel sheets in Python using openpyxl In this tutorial, we will see a demonstration on how to use Excel sheets in the python using openpyxl. Setup Execute the below command…

Continue Reading... Working with Excel sheets in Python using openpyxl
Posted in Tech stuff

if this and that or that

Excel if this and that or that Generic formula  =IF(AND(A1=”x”,OR(B1=”y”,B1=”z”)),”x”,””) Explanation  To test for various combinations of this AND that, or this OR that, you…

Continue Reading... if this and that or that
Posted in Tech stuff

Automate Excel using Python

Continue Reading... Automate Excel using Python
Posted in Tech stuff

Invoice in MS Excel

Continue Reading... Invoice in MS Excel
Posted in Tech stuff

Appsheet: Excel menjadi Aplikasi

Continue Reading... Appsheet: Excel menjadi Aplikasi
Posted in Tech stuff

Format pivot table Change the layout form of a PivotTable To make substantial layout changes to a PivotTable or its various fields, you can use one of…

Continue Reading... Format pivot table