September 25, 2007
Export to Excel file
Uncategorized
5 Comments
Comersus Version: 709
Database type: Access
Frequency: Permanent issue
I'm using ASP.NET version of Comersus and unable to export the data to EXCEL format using Utilities > Export to Excel > Products, Sales and Customers.
Please advise me the solution.
5 Comments
Hi,
In order to export to Excel, it requires the component
OWC.Spreadsheet
to be present in your server.
Please contact your hosting support to ask about this component.
You can also contact your sales representative at http://www.comersus.com/contact.html to request an estimate for a development of export to CSV or another format.
CSV files can also be opened with Excel.
[Reply]
There are two different ways.
First one, pay for some special component which does not require office.
Second, install office 2000 or greater onto the server with the OWC component, I used 11.
Then you will move onto the next error which we are awaiting a reply on 🙂
[Reply]
I have this component installed and once I changed the code from
set oExcel = Server.CreateObject("OWC.Spreadsheet")
to
set oExcel = Server.CreateObject("OWC11.Spreadsheet")
I got the following.
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'ActiveSheet.Export'
/store/backofficeplus/comersus_backoffice_exportSalesExec.asp, line 83
[Reply]
As I am still testing the Shop on my local server, please advise me how to check the presence of OWC.Spreadsheet component.
[Reply]
Hi,
Please refer to this answer
http://www.comersus.org/displayMessage.asp?mid=64884
[Reply]