While Excel offers many formatting options to make your workbook visually appealing, manually formatting large datasets can be incredibly tedious. But Python can automate it with ease.

Open Excel, and you will see a new tab in the ribbon at the top that says PyXLL.

Microsoft Corp. is releasing a new version of Excel that will enable users to write and run Python code directly in the spreadsheet editor’s interface. Stefan Kinnestrand, a general manager for ...