Faceți căutări pe acest blog

vineri, 16 septembrie 2016

Export DBF to OpenOffice / LibreOffice Calc

Both a class and a function designed to export data contained in a table or a cursor (or the content of a grid) to an ods document (a OpenOffice / LibreOffice Calc spreadsheet).
 Neither the class, nor the function requires some additional software to be installed.
That means they don't use automation or ODBC / OleDB.
No need for OpenOffice, LibreOffcie or MsOffice.
Just run the code to create the desired document.

The function copyToOds 2.0
The signature of the function is the same to the signature of CopyToOdt
Bug solved
- integer, numeric, float and double data type now are exported
Improvements
- a few minor improvements

The class ExportToOds 1.0
The properties are the same to ExportToOdt class
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 exportods 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 exportods 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)

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) lOpen
        logical (default .F.)
        public
        when .T. the document is open

Download links
Function CopyToOds 2.0
Class ExportToOds 1.0

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