About Services Tools Blog Contact us

Datasheet Tables from a Spreadsheet

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.

Holtweir Series 240 · logo bar
Cover
ModelFlowHeadPowerOrientation
Compact
C-126.2 l/s14 m2.2 kWVertical
C-188.5 l/s16 m3.0 kWVertical
Mid duty
M-2414.0 l/s22 m5.5 kWVertical
M-3618.5 l/s24 m7.5 kWVertical
High flow
H-4828.0 l/s28 m11 kWVertical
H-6036.0 l/s26 m15 kWVertical

Internal vertical sets stand on a plinth in the dry well, with the motor above the floor plate.

Model spreadsheet

series-240-models.csv Source
FamilyModelFlow l/sHead mkW
CompactC-126.2142.2
CompactC-188.5163.0
Mid dutyM-2414.0225.5
Mid dutyM-3618.5247.5
High flowH-4828.02811
High flowH-6036.02615

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

  1. Read the model rows and groups from Microsoft Excel.
  2. Create an A4 landscape document with set margins and millimetre units.
  3. Group the rows by family and tint each group.
  4. Turn options such as orientation and configuration into columns and not extra tables.
  5. 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]