Tech Tip: Port 4D View Pro to Excel

PRODUCT: 4D | VERSION: 17 R | PLATFORM: Mac & Win

Published On: April 18, 2019

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