83 lines
2.7 KiB
Plaintext
83 lines
2.7 KiB
Plaintext
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
|