View Issue Details

IDProjectCategoryView StatusLast Update
0005337JEDI VCL00 JVCL Componentspublic2011-06-07 17:27
Reporterjjaen26Assigned Toobones 
Status resolvedResolutionfixed 
Product Version3.32 
Target VersionFixed in Version 
Summary0005337: JvDBGridExcelExport on export rises Exception class EOleSysError with message operation unaviable
DescriptionWhen i try to export the content on my DBGrid to Excel i use the next code

JvDBGridExcelExport1.FileName := 'C:\PruebaExport.xls';

and y get the following exception message

"... Exception class EOleSysError with message operation unaviable..."
Additional InformationI have the following components

Windows 7
MS Office 2007
Data base: MySQL 5.1.49
Delphi Version: Delphi7
Delphi conexion components: Zeos (ZQuery)
TDataSource: Standard
Grid: TDBgrid Standard
TagsNo tags attached.



2010-10-08 16:38

administrator   ~0017839

Please provide the zipped sources of a sample application showing this

2010-10-10 01:45 (433,584 bytes)


2010-10-10 01:48

reporter   ~0017851

In this sample I use a TTable Component

Data Base: DBDemos (Included with Delphi 7.0)
Table: Clients.dbf


2010-11-09 14:57

administrator   ~0018059

Thanks for this.
Yes, you get the message from inside the IDE if Excel is not running, but if you let it continue, it does the export just fine.
You do, however, have to have Excel installed properly.

Issue History

Date Modified Username Field Change
2010-09-24 01:12 jjaen26 New Issue
2010-10-08 16:38 obones Note Added: 0017839
2010-10-08 16:38 obones Status new => feedback
2010-10-10 01:45 jjaen26 File Added:
2010-10-10 01:48 jjaen26 Note Added: 0017851
2010-11-09 14:57 obones Note Added: 0018059
2011-06-07 17:27 obones Status feedback => resolved
2011-06-07 17:27 obones Resolution open => fixed
2011-06-07 17:27 obones Assigned To => obones