SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[13.0.56 Pro] - Exporting to Excel

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[13.0.56 Pro] - Exporting to Excel
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post [13.0.56 Pro] - Exporting to Excel Reply with quote
I tried exporting some data to Excel but it failed saying:
Quote:

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
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 View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2165

Post Reply with quote
SysOp wrote:
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7948

Post Reply with quote
Indeed. Sorry for the confusion
Mon Dec 09, 2024 9:39 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.