Tech Tip: Add/Remove Sheets in 4D ViewPro Programmatically
PRODUCT: 4D | VERSION: 18 | PLATFORM: Mac & Win
Published On: August 24, 2020
Adding and removing sheets in a 4D View Pro document can be done programmatically. 4D View Pro objects have a property, sheetCount, which hold information of the number of sheets the document has. This property value can be changed to add or remove sheets in a View Pro document.
An example of this is shown below. In the example, the sheetCount property of the View Pro document is set to 2. For a View Pro document that had 1 sheet previously, this will add an additional sheet. For a View Pro document that had 3 sheets previously, this will remove the last sheet.
An example of this is shown below. In the example, the sheetCount property of the View Pro document is set to 2. For a View Pro document that had 1 sheet previously, this will add an additional sheet. For a View Pro document that had 3 sheets previously, this will remove the last sheet.
| $vp_name:="vp" $sheets:=2 $vp_o:=VP Export to object($vp_name) $vp_o.spreadJS.sheetCount:=$sheets VP IMPORT FROM OBJECT($vp_name;$vp_o) |