Various export results to CSV or Excel
I have a simple report that I want to export to a CSV file. There is only a detail row that is grouped by one field, no group header and no group footer for totals. The problem is when I export to CSV format is the total row for the group listed before each entry?
If I export to Excel and then save it as a CSV file, the shared row is where it belongs. However, one field is spread over three columns, then those columns are "merged and centered", which adds two commas in the middle of the row. And one column is added at the beginning of the record, and two at the end of the record - three more additional commas.
It would be easy enough to write a macro to "clean up" the distribution sheet and export as a csv file for my end users. However, corporate "insecurity" will prevent end users from having macros.
Any help, suggestions, pointers on where else to look is very valuable.
amuses
bean
source to share
The CSV generated by any standard reporting tool follows a flat data structure and therefore will repeat the entire dataset. XLS generated by replication tools usually needs to be opened in XLS and its default XLS behavior to add extra commas for each merged cell. The best way is to create a report with a layout with equal columns of data length even for the header i.e. When formatting the report, do not center the heading with a longer length, bold and italic type, etc., put it as the first column and match the length with the data in the detail record. Thus, you will be able to create a report that does not look presentable in XLS, but will provide you with the necessary data in CSV
source to share