Home python Python module to work in Excel

Python module to work in Excel




I want to automate the report in Excel. I would like to understand which module can cope with the necessary tasks:
1. Compare cells in in different columns (eg b1 and e1), if the value in them is the same, copy the value from the adjacent cell to another (eg D1 in C1). Total ~ 100 lines.
2. Copy the specified range of cells to another sheet in a specific place.
3. (optional) The ability to tint cells.

Tell me what you can use?

Answer 1, Authority 100%

To work with XLS format files, you can use Xlrd and XLWT . For XLSX, it will be more suitable for OpenPyxl .

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions