Our great sponsors
-
xlwings
xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows and macOS as well as with Google Sheets and Excel on the web.
-
RegExr
RegExr is a HTML/JS based tool for creating, testing, and learning about Regular Expressions.
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
You want xlwings (my preferred) or openpyxl
Changing formatting in text: Thats a two step process. 1. Understand the old format 2. Write into the new format. One tool to understand the old format are Regex. Here is a online tool to create regex expression: https://regexr.com/ . When you have it use the python regex library to use this on your excel text. For writing into new formats your could just use "f-string".