Vilhelm-Ion Praisach: Export

Se afișează postările cu eticheta Export. Afișați toate postările

marți, 20 mai 2025

Export to xlsx (class) 6.0 - support for inline strings

A new property was added, linline (boolean) and a new method, copytoinline.

By default linline = .F.

When linline = .T., instead of copytoxlsx, the new method, copytoinline is called. This way strings are generated as inline strings, not as a separate xml table.

A few errors were corrected to the old method, copytoxlsx, caused by memo fields with some special html characters (like ampersand or apostrophe).

I've found the inline strings useful when a table has dozens of type character fields.

This new version can be downloaded from here

marți, 16 aprilie 2019

Dbf2Xlsx6 4.2

marți, 10 ianuarie 2017

Export DBF to MSExcel Xlsx

sâmbătă, 7 ianuarie 2017

Export DBF to MSPowerPoin Pptx

joi, 5 ianuarie 2017

Export DBF to MSWord Docx

luni, 21 noiembrie 2016

Export to xlsx

Versions for VFP 6.0
Both for class (BRAND NEW) and procedure (improved version)

1) Class exportxlsx
a) Small correction in method TheFirstTime
b) New properties
    LangId
        Public
        Character (can be EN, RO,etc.)
        Default En
    aErrMess[7]
        Public
        Error messages
c) New method
    langSet
        Public
        Set the contents of aErrMess property

2) class propxlsx
a) New properties
    LangId
        Public
        Character (can be EN, RO,etc.)
        Default En
b) New method
    langSet
        Public
        Set the caption of various objects

Description
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 exportxlsx 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 exportxlsx 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

c) 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)

    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)
    lMemoAsComment    optional When passed as .T., memo fields are converted into memo while the cell contains the word "memo"

d) Miscelaneous
    a) SheetName
        character (default sheet1)
        public
        desired sheetname
    b) sheetFirstCol
        character (default A)
        public
        start column
    c) sheetFirstRow
        numeric (default 1)
        public
        start row
    d) lastcol
        character (XFD)
        public
        last valid column (maximum column / sheet)
    e) lastrow
        numeric (1048576)
        public
        last valid row (maximum number of rows / sheet)
    f) autocolw
        logical (default .F.)
        public
        .T. columns width are evaluated based on font size and the data type (the autosize feature)
    g) nCodePage
        numeric (default 0)
        public
        support for codpages for strings
        acceptable values: 437,620,737,850,852,857,861,865,866,874,895,932,936,949,950,1250,1251,1252,1253,1254,1255,1256 (see VFP help)
    h) lOpen
        logical (default .F.)
        public
        when .T. the document is open
    i) LangId
        Character (can be EN, RO,etc.)
        Public
        Default En
    j) aErrMess[7]
        Character array
        Public
        Error messages

support for more than 702 columns
stop the export after the row 1048576 and the column XFD
rows height depend on the font size
when memo columns are present, the row height depends on the number of CR (increase the row height according to the number of memo rows)
Comments boxes height and width are variable

Download link
dbf2xlsx 3.4 (VFP9 procedure)
dbf2xlsx6 2.1 (VFP6 procedure)

exportxlsx 3.0 (VFP9 class)
exportxlsx6 1.0 (VFP6 class)

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

Export to Pptx

Versions for VFP 6.0
Both for class (BRAND NEW) and procedure (improved version)

1) Class exportpptx
a) Small correction in method TheFirstTime
b) New properties
    LangId
        Public
        Character (can be EN, RO,etc.)
        Default En
    aErrMess[7]
        Public
        Error messages
c) New method
    langSet
        Public
        Set the contents of aErrMess property

2) class proppptx
a) New properties
    LangId
        Public
        Character (can be EN, RO,etc.)
        Default En
b) New method
    langSet
        Public
        Set the caption of various objects

Description
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
Miscelaneous
    lOpen
        logical (default .F.)
        public
        when .T. the document is open
    LangId
        Character (can be EN, RO,etc.)
        Public
        Default En
    aErrMess[7]
        Character array
        Public
        Error messages

Number of rows / slide is automatically calculated, based upon font height

Download links
dbf2pptx 3.0 (VFP9 procedure)
dbf2pptx6 2.0 (VFP6 procedure)

exportpptx 3.0 (VFP9 class)
exportpptx6 1.0 (VFP6 class)

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

Export to docx

miercuri, 2 noiembrie 2016

Export from VFP6 to MSOffice (docx, pptx, xlsx)

luni, 19 septembrie 2016

CopyToXlsx6 1.0

Vilhelm-Ion Praisach

Faceți căutări pe acest blog

marți, 20 mai 2025

Export to xlsx (class) 6.0 - support for inline strings

marți, 16 aprilie 2019

Dbf2Xlsx6 4.2

marți, 10 ianuarie 2017

Export DBF to MSExcel Xlsx

sâmbătă, 7 ianuarie 2017

Export DBF to MSPowerPoin Pptx

joi, 5 ianuarie 2017

Export DBF to MSWord Docx

luni, 21 noiembrie 2016

Export to xlsx

Export to Pptx

Export to docx

miercuri, 2 noiembrie 2016

Export from VFP6 to MSOffice (docx, pptx, xlsx)

luni, 19 septembrie 2016

CopyToXlsx6 1.0

Translate

Faceți căutări pe acest blog

marți, 20 mai 2025

marți, 16 aprilie 2019

marți, 10 ianuarie 2017

sâmbătă, 7 ianuarie 2017

joi, 5 ianuarie 2017

luni, 21 noiembrie 2016

miercuri, 2 noiembrie 2016

luni, 19 septembrie 2016

Translate

Abonați-vă la