I’m unable to test this at the moment, but does the TB show with the values in QuickFile before exporting it?
In regards to your query with the COA export, it will show all lines rather than just the ones with values. However, you should be able to open this in software like Excel and apply a filter to the values.