@Allr

Alex Taylor

@AllrJoined June 2023

Office Document Processing in .NET, Java, and C++

About

Share office file processing skills in .NET, Java, and C++.

Available for

Nothing here yet.

Alex Taylor's blogs

Office Document Automation & Developmentallr.hashnode.dev179 posts

How to Set Worksheet Views in Excel Using Python

Two people can open the same report and see very different things. One lands on the right page with aligned columns and clearly coloured tabs; the other lands on page one, zoomed too far out to read,

20h ago · 7 min readallr.hashnode.dev

Create Array and R1C1 Formulas in Excel with Python

Most formulas address a single cell at a time: =A1+A2 refers to two coordinates and lives in a third. An array formula is different — it treats a whole block of cells as input and writes its result in

4d ago · 7 min readallr.hashnode.dev

How to Group and Outline Data in Excel with Python

A project plan usually carries two different levels of information at once: the phases, and the tasks inside each phase along with their owners and durations. Flattened into one list, the reader has t

5d ago · 6 min readallr.hashnode.dev

How to Format Long Text in Excel Cells Using Python

Every exported report has one or two columns that refuse to stay in their place: order notes, error logs, product descriptions. By default the text runs sideways, either spilling over the neighbouring

Oct 23 · 6 min readallr.hashnode.dev

How to Create and Format Lists in Word Documents Using Python

A runbook needs numbered steps. A requirements checklist reads better with bullets. A specification document usually wants a hierarchy such as "1. Overview / 1.1 Background / 1.1.1 Scope". In Word thi

Oct 23 · 6 min readallr.hashnode.dev

Alex Taylor

About

Available for

Alex Taylor's blogs

How to Set Worksheet Views in Excel Using Python

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python

Search Hashnode

Alex Taylor

About

Available for

Alex Taylor's blogs

How to Set Worksheet Views in Excel Using Python

Create Array and R1C1 Formulas in Excel with Python

How to Group and Outline Data in Excel with Python

How to Format Long Text in Excel Cells Using Python

How to Create and Format Lists in Word Documents Using Python