Table1[#all] Reference the whole table including headers and totals Table1[] Reference the data part of the table excluding the headers and totals. This is the same as Table1[#Data] Table1[Column1] ...

I'd love to be able to write excel formulas in the write_excel method. This is super relevant when working with excel plugins. I'm not sure what the syntax should be - it's non-trivial given one can ...