Import function are used to integrate with data sources like excel, text, json, xml, databases etc
Export Functions are used to create files in various formats and push data into the application database
Web Actions are used to execute tasks on sheetkraft web. The same are irrelevant for execution of addin
These functions are used to download data from web using HTTP Request, hashing the data and encoding and decoding the data using Base64.
These functions helps us in building the logic to generate the reports and dashboards from the unprocessed input data. The functions like Lookup, Pivot etc are present in this group.
Database Explorer is used to create a database in SQL Server as well as you can execute an SQL query over here.(Only supported for MS SQL and PostGRE.)