Question

Excel exporter : Empty fields display style

0

Hi everyone, My problem is simple : The empty fields of existing objects are displayed by a “null” in the csv file exported by ExcelExporter. Would it be possible to change this value by an empty value “ “ ? Thank you all for the help !

asked 2020-03-27

Dan Dray

3 answers

Kacper Kozimor · Answer 1 · 2020-03-27

What came to my mind is to change the export entity to a non-persistable entity to which you copy values of your object attributes. This way you could change values of “empty” attributes and set them to “ ” without changes in the actual object. Is this an acceptable solution for your problem?

Dan Dray · Answer 2 · 2020-03-27

I have just another question concerning the CSV format : I see that all the fields are surrounded by quotation marks (“ “).

Would it be possible to remove them as well before exporting ? Is there something to configure in order to do it ?

Thanks.

Michiel Arts · Answer 3 · 2020-03-27

I believe you would have to modify ExportCSV.java of the appstore component for this.