- temporary tables are closed
- current alias is restored
- improved cleanup
- added apostrophe and quote to html special characters
General descriptionNo need for MSPowerPoint, LibreOffice or OpenOffice
In addition to copytopptx, has some formatting capabilities.
You can set properties for font, slide transition, a theme for the table, and you can add a linked picture below or above the table.
Export the data displayed in a grid, or the data contained by a table / cursor
Properties:
a) To export the data displayed in a grid (only the visible columns)
Drop an instance of the exportpptx class to your form and set :
- grid=grid reference
- label (optional)=the default file name; a reference to an object with the "caption" property; by default DATETIME()
b) To export the data contained in a table / cursor
Drop an instance of the exportpptx class to your form and set :
- grid=table / cursor name
- label (optional)=the default file name; a reference an object with the "caption" property; by default DATETIME()
- cFields (optional)= list of fields to be displayed, separated by commas; by default all the fields are exported
- cHeaders (optional)= list of field headers to be displayed, separated by commas; by default the field names
Formatting properties (right click)
headbackcolor=back color for column headers (if >=0)
headfontbold= .T./.F.
headfontitalic= .T./.F.
headfontname=if not empty and installed
headfontsize=if>0
headforecolor=font color for column headers (if >=0)
headtheme=.T. use theme in header
rowbackcolor=back color for rows (if >=0)
rowfontbold= .T./.F.
rowfontitalic= .T./.F.
rowfontname=if not empty and installed
rowfontsize=if>0
rowforecolor=font color for rows (if >=0)
rowtheme=.T. use theme in rows
nTransSec=slide transition automatically after (seconds)
lTransClick=.T. slide transition on mouse click
nTransSpeed=slide transition speed (1 fast, 2 medium, 3 slow)
PictFB=Picture position (1 Front, 2 Back)
PictMU=Picture MU (1 cm, 2 inch, 3 pt)
PictW=Picture width
PictH=Picture height
PictL=Picture left position
PictT=Picture top position
PictB=Picture brightnes (%)
PictC=Picture contrast (%)
PictPath=Picture path
nstyle=table theme
public
Integer (1-11)
the name of the style
naccent=table theme
public
Integer (1-7) 0 means no accent, 1 to 6 means accent1 to accent6
the name of the substyle
tabfirstrow=table first row is different
tabfirstcol=table first column is different
tablastrow=table last row is different
tablastcol=table last column is different
tabbandrow=table has alternate rows
tabbandcol=table has alternate columns
Number of rows / slide is automatically calculated, based upon font height
Download link
ExportToPptx 2.0
See also
https://www.foxite.com/archives/dbf2pptx-0000415404.htm
http://www.tek-tips.com/viewthread.cfm?qid=1759333
Related posts
http://praisachion.blogspot.com/2016/06/inspectpptx-10.html
http://praisachion.blogspot.com/2016/06/inspectdocx-10.html
MSOffice -> DBF
http://praisachion.blogspot.com/2017/08/importfromxlsx-40.html
http://praisachion.blogspot.com/2017/06/append-from-xlsx-30.html
http://praisachion.blogspot.com/2016/08/importfromxlsx-34.html
http://praisachion.blogspot.com/2016/08/importfromxlsx-33.html
http://praisachion.blogspot.com/2016/06/importfromxlsx-32-appendfromxlsx-21.html
http://praisachion.blogspot.com/2016/06/appendfrompptx-10.html
http://praisachion.blogspot.com/2016/06/appendfromdocx-21.html
http://praisachion.blogspot.com/2016/06/importfromdocx-31.html
http://praisachion.blogspot.com/2016/06/importfrompptx-11.html
http://praisachion.blogspot.com/2016/06/importfromxlsx-31.html
http://praisachion.blogspot.com/2016/06/importfrompptx-10.html
http://praisachion.blogspot.com/2016/06/importfromdocx-30.html
http://praisachion.blogspot.com/2016/05/importfromxlsx-22.html
http://praisachion.blogspot.com/2016/02/import-dbf-from-msoffice-2007-xlsx-docx.html
http://praisachion.blogspot.com/2016/01/importfromdocx-20.html
http://praisachion.blogspot.com/2016/01/appendfromdocx-20.html
http://praisachion.blogspot.com/2016/01/importfromxlsx-13.html
http://praisachion.blogspot.com/2016/01/appendfromxlsx-20.html
http://praisachion.blogspot.com/2015/12/appendfromxlsx-15.html
http://praisachion.blogspot.com/2015/11/importfromxlsx-13.html
http://praisachion.blogspot.com/2015/09/importfromxlsx-12.html
http://praisachion.blogspot.com/2015/09/appendfromxlsx-14.html
http://praisachion.blogspot.com/2015/09/appendfromnxlsx-13.html
http://praisachion.blogspot.com/2015/08/importfromxlsx-11.html
http://praisachion.blogspot.com/2015/07/import-from-xlsx.html
http://praisachion.blogspot.com/2015/07/insert-from-focx.html
http://praisachion.blogspot.com/2015/06/append-from-docx.html
DBF -> MSOffice
Dbf2Xlsx6 4.2 (VFP6)
http://praisachion.blogspot.com/2017/04/export-dbf-to-excel-2007.html
http://praisachion.blogspot.com/2017/01/export-dbf-to-msexcel-xlsx.html
http://praisachion.blogspot.com/2017/01/export-dbf-to-mspowerpoin-pptx.html
http://praisachion.blogspot.com/2017/01/export-dbf-to-msword-docx.html
http://praisachion.blogspot.com/2016/11/export-to-xlsx.html
http://praisachion.blogspot.com/2016/11/export-to-pptx.html
http://praisachion.blogspot.com/2016/11/export-to-docx.html
http://praisachion.blogspot.com/2016/11/export-from-vfp6-to-msoffice-docx-pptx.html
http://praisachion.blogspot.com/2016/09/copytoxlsx6-10.html
http://praisachion.blogspot.com/2016/01/export-dbf-to-msoffice-2007-xlsx-docx_24.html
http://praisachion.blogspot.com/2016/01/export-dbf-to-msoffice-2007-xlsx-docx.html
http://praisachion.blogspot.com/2016/01/exporttopptx-20.html
http://praisachion.blogspot.com/2016/01/exporttodocx-20.html
http://praisachion.blogspot.com/2016/01/copytopptx-20.html
http://praisachion.blogspot.com/2016/01/exporttoxlsx-20.html
http://praisachion.blogspot.com/2016/01/copytoxlsx-30.html
http://praisachion.blogspot.com/2015/12/exporttoxlsx-19-class.html
http://praisachion.blogspot.com/2015/12/copytoxlsx-210-procedure.html
http://praisachion.blogspot.com/2015/12/exporttoxlsx-18-class.html
http://praisachion.blogspot.com/2015/12/copytoxlsx-29.html
http://praisachion.blogspot.com/2015/02/export-pptx-13.html
http://praisachion.blogspot.com/2015/01/copytodocx-12.html
http://praisachion.blogspot.com/2015/01/exportdocx-1.html
OOffice -> DBF
http://praisachion.blogspot.com/2016/11/import-from-openoffice-libreoffice-for.html
http://praisachion.blogspot.com/2016/09/importfromoowrtext-10.html
http://praisachion.blogspot.com/2016/09/importfromooffice-1o.html
http://praisachion.blogspot.com/2016/08/importfromoocalc.html
DBF -> OOffice
http://praisachion.blogspot.com/2016/09/export-dbf-to-openoffice-libreoffice_52.html
http://praisachion.blogspot.com/2016/09/export-dbf-to-openoffice-libreoffice_16.html
http://praisachion.blogspot.com/2016/09/copy-to-ods-10-openoffice-calc.html
http://praisachion.blogspot.com/2016/09/export-dbf-to-openoffice-libreoffice.html
http://praisachion.blogspot.com/2016/09/copy-to-odt-10.html
Niciun comentariu:
Trimiteți un comentariu