KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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.
Log In

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