Topics with keyword "TExcelWrapper"
1. Using Field-Map predefined variables
... pt
TLineWrapper
line, lin
TPolygonWrapper
polygon, pol
TObjectListWrapper
objlist, olst, olist
TExcelWrapper
xls, myexcel, excel
TScriptOrganizer
sco, scriptorganizer
TVolumeModelsWrapper
volmodels, volumemodels...
2. ExcelWrapper
... with multiple Excel objects. TExcelWrapper class is a wrapper for...
3. CreateFile
... an instance of the TExcelWrapper class
Return value:
none
See also...
4. OpenFile
... an instance of the TExcelWrapper class
Return value:
none
See also...
5. FileName
... an instance of the TExcelWrapper class
Return value:
Name of...
6. CloseAndSave
... an instance of the TExcelWrapper class
OpenExcel
Variable declared as boolean...
7. Save
... an instance of the TExcelWrapper class
Return value:
none
See also...
8. OpenInExcel
... an instance of the TExcelWrapper class
Return value:
none
See also...
9. ShowExcelPreview
... an instance of the TExcelWrapper class
Options
Variable declared as string...
10. SetValue
... an instance of the TExcelWrapper class
row
Variable declared as integer...
11. SetValueAndMerge
... an instance of the TExcelWrapper class
row1, row2
Variable declared as...
12. SetFormula
... an instance of the TExcelWrapper class
row
Variable declared as integer...
13. GetCellValue
... an instance of the TExcelWrapper class
Row
Variable declared as integer...
14. AddImage
... an instance of the TExcelWrapper class
Filename
Variable declared as string that...
15. AddImageExt
... an instance of the TExcelWrapper class
Filename
Variable declared as string that...
16. SetHTML
... an instance of the TExcelWrapper class
Row, Col
Variables declared as integer...
17. SetHTMLAndMerge
... an instance of the TExcelWrapper class
Row1, Col1, Row2, Col2
Variables declared...
18. FillColor
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
19. MergeCells
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
20. SetTextOrientation
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
21. Align
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
22. DrawBorders
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
23. FormatCells
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
24. AddUserFormat
... an instance of the TExcelWrapper class
FormatName
Variable declared as string...
25. AutofitCol
... an instance of the TExcelWrapper class
col1
Variable declared as integer...
26. AutofitRow
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
27. SetOptimalColWidth
... an instance of the TExcelWrapper class
col1
Variable declared as integer...
28. SetColWidth
... an instance of the TExcelWrapper class
col1
Variable declared as integer that...
29. SetDefaultColWidth
... an instance of the TExcelWrapper class
Width
Variable declared as integer that...
30. SetRowHeight
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
31. SetDefaultRowHeight
... an instance of the TExcelWrapper class
Height
Variable declared as integer that...
32. SetColWidth_mm
... an instance of the TExcelWrapper class
col1
Variable declared as integer that...
33. SetRowHeight_mm
... an instance of the TExcelWrapper class
row1
Variable declared as integer...
34. GetTextWidth
... an instance of the TExcelWrapper class
Text
Variable declared as string that...
35. GetTextHeight
... an instance of the TExcelWrapper class
Format
Variable declared as string that...
36. GetCellWidth
... an instance of the TExcelWrapper class
Row
Variable declared as integer...
37. Landscape
... an instance of the TExcelWrapper class
Return value:
none
See also:
Landscape...
38. SetPaperSize
... an instance of the TExcelWrapper class
PaperSize
Variable declared as string that...
39. SetPrintArea
... an instance of the TExcelWrapper class
Row1
Variable declared as integer...
40. SetPrintMargins
... an instance of the TExcelWrapper class
Left_mm, Top_mm, Right_mm, Bottom_mm
Variables...
41. SetHeader
... an instance of the TExcelWrapper class
Header
Variable declared as string that...
42. SetFooter
... an instance of the TExcelWrapper class
Footer
Variable declared as string that...
43. SetHeaderAndFooter
... an instance of the TExcelWrapper class
HeaderLeft, HeaderCenter, HeaderRight
Variables declared as...
44. SetFirstHeaderAndFooter
... an instance of the TExcelWrapper class
HeaderLeft, HeaderCenter, HeaderRight
Variables declared as...
45. SetTitleRows
... an instance of the TExcelWrapper class
R1
Variables declared as integer that...
46. SetTitleRowsAndCols
... an instance of the TExcelWrapper class
R1
Variables declared as integer that...
47. InsertHPageBreak
... an instance of the TExcelWrapper class
row
Variable declared as integer that...
48. InsertVPageBreak
... an instance of the TExcelWrapper class
col
Variable declared as integer that...
49. CreateHeaderOfTableContent
... an instance of the TExcelWrapper class
Return value:
none
See also:
Landscape...
50. CreateTableOfContent
... an instance of the TExcelWrapper class
lst
Variable declared asan instance of...
51. AddBackToTableOfContent
... an instance of the TExcelWrapper class
Row
Variable declared as integer that...
52. RowCount
... an instance of the TExcelWrapper class
Return value:
Number of rows...
53. ColCount
... an instance of the TExcelWrapper class
Return value:
Number of columns...
54. AutoPageBreaks
... an instance of the TExcelWrapper class
Return value:
none
See also:
Landscape...
55. PrintNumberOfHorizontalPages
... an instance of the TExcelWrapper class.
Return value:
none
See also...
56. PrintNumberOfVerticalPages
... an instance of the TExcelWrapper class
Return value:
none
See also:
Landscape...
57. PrintToFit
... an instance of the TExcelWrapper class
Return value:
none
See also:
Landscape...
58. AddSheet
... an instance of the TExcelWrapper class
OverwriteSheet
Variable declared as boolean (True...
59. MakeSheetActive
... an instance of the TExcelWrapper class
Return value:
none
See also:
AddSheet...
60. ClearSheet
... an instance of the TExcelWrapper class
Return value:
none
See also...
61. ExcelWrapperExample
... to illustrate using the TExcelWrapper class.
This example generates an...