Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2170
|
|
[13.0.56 Pro] - Exporting to Excel |
|
I tried exporting some data to Excel but it failed saying:
 |
 |
Export to Excel workbook failed.
Error: Invalid class string, ProgID: "excel.application"
|
This probably means that SA/SE only passes the data to the Excel application to do the rest of the exporting, right? I don't have Excel installed. I have LibreOffice but I guess that won't suffice. Do you know any workarounds for this? I know I could export to csv that can be opened in LibreOffice Calc and then save to Excel format but that would be a multi-step manual process instead of a single-step.
|
|
Mon Dec 09, 2024 6:48 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
This feature requires Excel to be installed. It uses internally Excel automation to export data and various data formatting options
|
|
Mon Dec 09, 2024 12:19 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
If your code hase statements separated by consequitive line breaks, or use code formatting first to add them where missing, then perhaps you can use a regex based search and replace in the next step to add semicolons.
|
|
Mon Dec 09, 2024 12:24 pm |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2170
|
|
|
|
 |
 |
If your code hase statements separated by consequitive line breaks, or use code formatting first to add them where missing, then perhaps you can use a regex based search and replace in the next step to add semicolons. |
This reply was misaddressed. I guess it was meant to this topic:
https://www.softtreetech.com/support/phpBB2/viewtopic.php?t=26039
|
|
Mon Dec 09, 2024 3:56 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7963
|
|
|
|
Indeed. Sorry for the confusion
|
|
Mon Dec 09, 2024 9:39 pm |
|
 |
|