Builds an A4 landscape model table in Adobe InDesign from Microsoft Excel, with colour-coded groups, so a data change does not mean drawing the table again.
Print & Page Layout
Water and wastewater
Tool
Productised
Local/private
2026
The problem
Equipment datasheets carry many model rows, options such as orientation, and a strip of partner logos that must stay lined up. Rebuilding that table by hand after a spreadsheet change brings in mismatches between the sheet and the print.
What it does
A script reads the model data and creates the landscape page, the colour swatches and the grouped table. The studio then places the table in the designed sheet, swaps the cover photograph and refreshes the logo bar. The sheet is exported as a print PDF.
Outcomes
The printed table matches the spreadsheet.
Group tints stay the same when rows are added.
The cover, logo bar and body copy update around the same table.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Series 240 pump sets
Group tints and the specification sentence follow the two selects. The cover and the logo bar stay put.
HoltweirSeries 240 · logo bar
Cover
Model
Flow
Head
Power
Orientation
Compact
C-12
6.2 l/s
14 m
2.2 kW
Vertical
C-18
8.5 l/s
16 m
3.0 kW
Vertical
Mid duty
M-24
14.0 l/s
22 m
5.5 kW
Vertical
M-36
18.5 l/s
24 m
7.5 kW
Vertical
High flow
H-48
28.0 l/s
28 m
11 kW
Vertical
H-60
36.0 l/s
26 m
15 kW
Vertical
Internal vertical sets stand on a plinth in the dry well, with the motor above the floor plate.
Spreadsheet loaded
Spreadsheet and table match. 6 rows, 3 groups. Cover and logo bar unchanged.
Model spreadsheet
series-240-models.csv Source
Family
Model
Flow l/s
Head m
kW
Compact
C-12
6.2
14
2.2
Compact
C-18
8.5
16
3.0
Mid duty
M-24
14.0
22
5.5
Mid duty
M-36
18.5
24
7.5
High flow
H-48
28.0
28
11
High flow
H-60
36.0
26
15
Option axes stay as columns. A new row picks up its family tint. The cover file is not in this sheet.
Print PDF
Page
A4
Sheet
Wide
Margins
12 mm
Ready when placed
The file stays disabled until the table, cover and logo bar are in the designed sheet. This sample stops at placement.
How it works
Read the model rows and groups from Microsoft Excel.
Create an A4 landscape document with set margins and millimetre units.
Group the rows by family and tint each group.
Turn options such as orientation and configuration into columns and not extra tables.
Place the table in the datasheet with the cover image, logo strip and approved sentence, then export a PDF.
Pipeline
flowchart LR
A[Spreadsheet] --> B[Group rows]
B --> C[Tinted table]
D[Cover photo] --> E[Datasheet]
C --> E
F[Logo bar] --> E
E --> G[Print PDF]