Search code examples
excelxmlexportrows

Ignore certain rows from an XML export in Excel?

I have an Excel spreadsheet that I'd like to only export certain rows to XML (I'm using "Export" via the "Developer" tab). I tried to simply hide the rows, but they're still included in the outputted XML.

Solution

  • Use a new sheet for the rows to be ignored.