SQL to Excel

• Fixed Review Comments
• Added try-with-resources for connections.
• Closed some connections in final blocks.
• Fixed the reported vulnerabilities in the plugin as per the vulnerability report:

1. Update the following Libraries to the latest versions
2. commons-beanutils
3. commons-io
4. commons-lang
5. commons-math
6. poi
7. poi-ooxml
8. xml-beans
9. 
   
10. Added New lib that is compatible with the new version.
11. commons-collections
12. commons-compress
13. poi-ooxml-lite
14. Remove the deprecated setter function that sets cell style

I am facing similar issue. please advise how you resolved it. 

Hi, I am not able to deploy this plug in in new environment as part of deployment as it is not listing when searched. Is it because of  "This listing is archived."

Is there a reason that the exported DATE_FORMAT is set to dd-MMM-yyyy and the cellStyleDate (line 166) is set to "m/d/yyyy"? When my spreadsheets are generated date columns are left aligned (meaning excel thinks its text) and I suspect the reason for that is the mismatch in these formats. Was this a purposeful choice? Have you seen this issue with the excel spreadsheet and dates?

• Updated libraries for log4j vulnerability

Hi,

We are also facing the same issue.May I know, how did u fix this?

Thanks in Advance.

Regards,

Subha

Does this plugin allow xlookup function? Its throwing error when we try to export data to  the templates with xlookup formula. any ideas/suggestion would be appreciated?

Hi Noticed that date values are exported in DD-MON-YYYY format as text. Is it possible to export in date format itself?

Wanted to generate two tabs in the same excel with header templates, can we achieve that?

The above is not an issue. Generated excel doesn't invalidate formulas, so, it throws an error when "=" is present in the cell's first position, as the excel treats that specific cell as a formula.