Overview
Key Features & Functionality
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?
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.
Hi Team,
I am using this smart service to export sql result to excel. But its not exporting more than 6700 rows of data. Getting below error
The following error was raised by the Export to Excel function: Specified named range 'Fun' does not exist in the current workbook.
Any help would be appreciated.
When using the SQL to Excel Smart Service and exporting data, all the date time fields are converted to date fields.
We need to use DATE_FORMAT function in sql to keep date time as is. This is not the case with earlier Export SQL to Excel Smart Service in Excel Tools.