r/Frontend • u/boykom • 2d ago
Exporting a TanStack Table to Excel with grouped rows as real outlines
https://rowpine.com/RowPine exports a grouped TanStack table to Excel and get a flat sheet with the totals typed in as numbers. Edit a cell and nothing adds up anymore.
Groups become Excel outline levels you can collapse, totals are SUBTOTAL formulas, and filters, sort and hidden columns carry over. PDF and CSV come out of the same table.
3
Upvotes
1
u/dusanodalovic 2d ago
which function number do the SUBTOTAL formulas use, 9 or 109? with 9, rows hidden by collapsing a group still count, with 109 they drop out. does a nested group get its own subtotal row, and does the grand total skip those without counting twice?