SpreadsheetWriter format data as Table

sergey-tihon / Clippit

Fresh PowerTools for OpenXml

https://sergey-tihon.github.io/Clippit/

MIT License

50 stars 19 forks source link

SpreadsheetWriter format data as Table #27

Closed sergey-tihon closed 3 years ago

sergey-tihon commented 3 years ago

Data exported using SpreadsheetWriter should look behave identical to Format as Table Excel feature. This will improve user experience and allow to use generated files as a Source in Power BI.

sergey-tihon commented 3 years ago

Seems like it is already possible... Just need to provide ColumnHeadings and TableName https://github.com/sergey-tihon/Clippit/blob/master/OpenXmlPowerTools.Tests/SpreadsheetWriterTests.cs#L35-L36