Tech Tip: Port 4D View Pro to Excel
PRODUCT: 4D | VERSION: 17 R | PLATFORM: Mac & Win
Published On: April 18, 2019
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
4D v17R3 allows 4D View Pro documents to be saved as an xlsx file. This allows 4D View Pro documents to be saved and opened in compatible spreadsheet applications like Excel.
Below is sample code that automatically opens the current View Pro Area in the default compatible Spreadsheet application:
C_TEXT($1;$vpArea_t) C_TEXT($cmd) If(Count parameters>0) $vpArea_t:=$1 VP EXPORT DOCUMENT ($vpArea_t;"tempVP.xlsx") $cmd:=Get 4D folder(Database folder)+"tempVP.xlsx" OPEN URL($cmd) End if |