search

jdemetra / jdplus-main

JDemetra+ v3
European Union Public License 1.2
14 stars 8 forks source link

GUI Excel output with version v3.2.2 #303

Closed veroniqueelter closed 4 months ago

veroniqueelter commented 4 months ago

Dear all,

I still have problems to create an Excel output with the GUI of the newest version of JDemetra+ (v3.2.2). I always get the following error message:

Can't generate output (Excel) java.io.IOException: Cannot find spreadsheet writer for file 'C:\Test_JDemetra_plus\Test_JDemetra_3.2.2\CLV_1_AfterFirstBreak\CUP_1_BeforeFirstBreak'

Our IT team thinks that the issue comes from JDemetra+. What could be the reason behind this and what can I do to solve the problem? Thank you very much in advance for your help, Best greetings, Véronique

TanguyBarthelemy commented 4 months ago

We discussed yesterday about your issue with @charphi . The error is saying that your filename doesn't end with a file extension (for example .xls, .xlsx or .ods).

Please try to change your file extension (by hand or with Excel for example) to update your filename.

veroniqueelter commented 4 months ago

I just tried it out and it works perfectly well now. The problem was that the file extension never needed to be mentioned in the older versions. I will take note of it. With this issue fixed, the new version is ready for production for us. Thank you very much.

TanguyBarthelemy commented 4 months ago

Good to know!

veroniqueelter commented 4 months ago

Just another question: is it planned to switch the Date format in the Excel output back to "General" or will it be kept in the new "Date" Format? just to know if I need to adapt my subsequent macros or not, as it used to be in the "General" format. Thank you very much in advance. Véronique

charphi commented 4 months ago

For the Excel output, you have to specify the file extension so that the program knows which file format you want to use. This is indeed a behavior change from the v2. I'm thinking about two solution for that problem:

charphi commented 4 months ago

Just another question: is it planned to switch the Date format in the Excel output back to "General" or will it be kept in the new "Date" Format? just to know if I need to adapt my subsequent macros or not, as it used to be in the "General" format. Thank you very much in advance. Véronique

The new "Date" format is just the Excel date cell type without formatting. I don't know how your macros work but as a cell type, it should be fine. As a string value, that will be indeed anoying. I'm not planning to change the behavior for the time being.

charphi commented 4 months ago

I've chosen the implicit solution: automatically add default file extension