Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating spreadsheet file with images from report
Message
From
05/11/2016 19:59:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Creating spreadsheet file with images from report
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01642788
Message ID:
01642788
Views:
135
Report contains images.
Report has image field with contain tablebase field which contain image file name in temporary directory.

I tried to use Alejando Sosa ExcelListener to create spreadsheet file from it.
Create file does not contain images.

Excellistener creates files Excel 2003 format which is unsupported according to https://msdn.microsoft.com/en-us/library/aa140066(office.10).aspx

According to http://stackoverflow.com/questions/2200056/excel-xml-spreadsheet-is-it-possible-to-embed-images this format does not allow images. FoxyPreviewer uses also this format.
I also tried to open html file using file:/// links and data urls but images does not appear in LibraOffice.

How to create spreadsheet (ods or other format) file from foxpro report ?
Open source solution should used since probably some creation customizaton is required.

ods format seems to be best option. It requires to create zip files containing lot of files. Changing Excellistener to create it seems to be lot of work.
Excel/LibreOffice may not installed in client computer so automation cannot used.

Posted also in http://stackoverflow.com/questions/40444591/how-to-create-spreadsheet-with-images-from-visual-foxpro-report
Andrus
Next
Reply
Map
View

Click here to load this message in the networking platform