Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating spreadsheet file with images from report
Message
From
06/11/2016 07:14:40
 
 
To
06/11/2016 06:33:56
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01642788
Message ID:
01642800
Views:
45
Thank you.

Interesting links.

I looked into Alexandre ExcelListener method AfterReport listener method xlsx file creation and Opendocument Spreadsheet .ods file content.xml file.
It looks that they have similar information , only tag and attibute names are different.
My idea:

Setup:
Save some spreadsheet in Excel to templates\OpendocumentSpreadSheetTemplate.ods file

Runtime

1. Modify Alejandro ExcelListener afterReport method to create content.xml file and
save images to media subdirectory
2. Use the commands to create and open report in LibreOffice or Excel:
copy file ..\templates\OpendocumentSpreadSheetTemplate.ods myreport.ods
run zip myreport.ods  content.xml media\*.*
run  myreport.ods 
Is this reasonable ?

>>
>>I need only fods, ods or similar spreadsheet file with images creation.
>
>If you can build a cursor with all the information needed in the XLSX, you may export the cursor with one of the XLSX libraries openly available for VFP, including source code, and adapt it to incorporate images:
>
>Greg Green's: http://vfpx.codeplex.com/wikipage?title=XLSXWorkbook
>
>Vilhelm-Ion Praisach's: http://praisachion.blogspot.com/ (several libraries).
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform