Write to Excel – Useful code

Python – Write a DataFrame or List to multiple tabs in Excel

Vitosh Jul 11, 2022 Tagged with dataframe, Excel, List, multiple sheets, multiple tabs, Write to Excel

The idea of the article is to provide a Python code that does the following: Takes a list or DataFrame; Splits it into quite a few smaller parts; Writes each one on a separate Excel worksheet; Pretty much like this: …

Python – Write a DataFrame or List to multiple tabs in Excel Read more →

Python, VBA \ Excel

Python – Simple writing in Excel with XlsWriter

Vitosh May 28, 2018 Tagged with Python, Write to Excel, xlsxwriter

The XlsxWriter library of Python is a nice gem for a VBA developer – you would be really interested to see the problems a Python developer should be facing, just to achieve a simple part Excel automatization. Still, these are …

Python – Simple writing in Excel with XlsWriter Read more →

Tag: Write to Excel

Python – Write a DataFrame or List to multiple tabs in Excel

Python – Simple writing in Excel with XlsWriter