'Create some Table in a single Sheet on Excel with Python

xlsxwriter code 1xlsxwriter code 2I would like to create three different tables (with different sizes and different merged/colored header) in a single sheet in Excel using Python.in the tables data is read in with a loop line by line. I first came up with the idea of using pandas but it seemed quite complicated. I personally use OpenpyXl to work in Excel Workbook but I'm still a beginner. Do you have some ideas for me or what can you recommend me to do or use?

python-3.xexcelpandasc++


Solution 1:[1]

You can try with xlsxwriter. It has much less overhead than pandas if you only want to dump tables with formats

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Zaero Divide

Related Questions