Load 4D View document
Load 4D View document ( 4DViewDocument ) : Object
| Parameter | Type | Description | |
|---|---|---|---|
| 4DViewDocument | Blob | → | 4D View document |
| Function result | Object | ← | Object representation of the 4D View document |
Description
The Load 4D View document command allows you to convert a 4D View document into a 4D object.
Neither a valid 4D View license, nor an instance of the legacy 4D View plug-in in your environment are required for this command.
Pass in the 4DViewDocument parameter a BLOB variable or field containing the 4D View document to convert. The command returns a 4D object that describes all information originally stored within the 4D View document, including:
- document structure (number of rows and columns), type and information (version, title...)
- cell attributes (cell type, value, formula, name, style, security...)
- column attributes (width, style, type, security, visibility, break...)
- row attributes (height, style, type, security, visibility, break...)
- styles, borders, and panes
Using this command, you can recover any data stored in your 4D View documents and handle them in an open format.
Note: If you need to convert documents from 4D View to 4D View Pro, it is recommended to use the dedicated command which performs a direct and transparent conversion.
Example
You want to load and convert a 4D View document stored on disk:
var $blob : Blob
var $object : Object
DOCUMENT TO BLOB("document.4PV";$blob)
$object:=Load 4D View document($blob)
ALERT("Document title is "+$object.title)
For example, if you convert the following document:
You will get the following result (stringified object):
{
"version":9,
"title":"4D View test",
"subject":"",
"author":"",
"company":"",
"note":"",
"creationDate":"2017-06-13",
"creationTime":63230,
"modificationDate":"2017-06-13",
"modificationTime":63295,
"columnCount":2048,
"rowCount":65535,
"columnHeaderHeight":380,
"rowHeaderWidth":1180,
"columnWidth":2160,
"rowHeight":320,
"noExternalCall":false,
"columns":[],
"rows":[],
"cells":[
{
"kind":"value",
"value":"hello world",
"valueType":"string",
"column":1,
"row":1
},
{
"kind":"value",
"value":42,
"valueType":"real",
"column":1,
"row":3
},
{
"kind":"value",
"value":true,
"valueType":"bool",
"column":1,
"row":4
}
],
"cellNames":[],
"customFormats":[],
"rowEdges":[
{
"style":13,
"color":15597568,
"left":2,
"top":6,
"right":3,
"bottom":6
},
{
"style":13,
"color":15597568,
"left":2,
"top":11,
"right":3,
"bottom":11
}
],
"columnEdges":[
{
"style":13,
"color":15597568,
"left":2,
"top":6,
"right":2,
"bottom":10
},
{
"style":13,
"color":15597568,
"left":4,
"top":6,
"right":4,
"bottom":10
}
],
"defaultStyle":{
"locked":false,
"hidden":false,
"gridHidden":false,
"spellCheck":false,
"pictHeights":false,
"inputFilter":0,
"backColorEven":16777215,
"backColorOdd":16777215,
"fontID":2,
"fontSize":11,
"fontBold":false,
"fontItalic":false,
"fontUnderline":false,
"fontOutline":false,
"fontShadow":false,
"fontCondensed":false,
"fontExtended":false,
"normalColorEven":0,
"normalColorOdd":0,
"zeroColorEven":255,
"zeroColorOdd":255,
"minusColorEven":16711680,
"minusColorOdd":16711680,
"hAlign":0,
"vAlign":0,
"rotation":0,
"wordWrap":false,
"forceTextFormat":false,
"numericFormat":0,
"stringFormat":0,
"booleanFormat":0,
"dateTimeFormat":0,
"pictureFormat":0
},
"exportRanges":[],
"fontNames":[
{
"id":2,
"name":"Lucida Grande"
}
],
"inputFilters":[],
"pictures":[
{
"column":3,
"row":3,
"width":920,
"height":1000,
"drawingMode":5,
"behind":false,
"fixedSize":false,
"locked":false,
"hOffset":0,
"vOffset":0,
"picture":"[object Picture]"
}
]
}
Note: For more information about the format of the returned object, please contact the 4D technical services.
Properties
| Command number | 1528 |
| Thread safe | ✓ |