Articles tagged: #xlsx

Word has mail merge: you take a template with fields and drop the data in. Excel appears to have nothing of the sort out of the box — so developers start assembling documents cell by cell in code. In fact, substituting values into a ready XLSX takes two lines: placeholders, the fill/replace difference, and the usual traps.

The accountant has already drawn the invoice form in Excel — with a logo, borders, number formats, and formulas. There is no need to reproduce that in code: FastExcelTemplator takes the ready XLSX as a template, substitutes data for the placeholders, and repeats table rows while keeping the formatting.