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

https://medium.com/aubergine-solutions/working-with-excel-sheets-in-python-using-openpyxl-4f9fd32de87f 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 thathttps://exceljet.net/formula/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

https://help.appsheet.com/en/articles/1100263-app-design-101

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

Format pivot table

https://support.office.com/en-us/article/design-the-layout-and-format-of-a-pivottable-a9600265-95bf-4900-868e-641133c05a80 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