I have a collapsible/nested data report that gets displayed on my web pages. Our customer wants download option enabled on this report. Usually all my other reports I allow user to download as a csv file. But I am not able to finalize the file type I should use for collapsible/nested data report. I read and explored one suggestion of Excel groups, But was wondering if there is something better than this.
I have a java web application which uses react on the front end.
Sample collapsible data:
<code>fileName, startTime, endTime, dataCount, source, matchedCount, unMatchedCount
abc.csv, 10:40, 12:00, 10000, , , ,
, , , , xyz, 4090, 10
, , , , xyz, 4050, 50
</code>
<code>fileName, startTime, endTime, dataCount, source, matchedCount, unMatchedCount
abc.csv, 10:40, 12:00, 10000, , , ,
, , , , xyz, 4090, 10
, , , , xyz, 4050, 50
</code>
fileName, startTime, endTime, dataCount, source, matchedCount, unMatchedCount
abc.csv, 10:40, 12:00, 10000, , , ,
, , , , xyz, 4090, 10
, , , , xyz, 4050, 50