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