The SQL Spreads Designer
The Advanced Setup
When do I have to use the Advanced Setup?
- Data driven Drop-Down lists
- Formula columns - columns in Excel containing formulas where the value of the formula is written to the database table.
Note: If you have created a setup using the SQL Spreads Designer, you can always switch over to the Advanced Setup and continuing configuring your setup there.
Can I switch from the Designer to the Advanced Setup?Yes, you can always start creating a setup in the Designer and then switch over to the Advanced Setup and continuing configuring your setup there.
Note: Once you have edited a setup in the Advanced mode you cannot go back and do changes using the SQL Spreads Designer.
Can I really do this from the Designer?You can do most of the setups using the Designer.
Can I use custom SQL queries or quires with JOINs from the Designer:
Yes, the SQL Spreads Designer supports updating data in SQL Server Views. If you need to use a custom SQL query in the SQL Spreads Designer, consider creating a SQL Server View which contains the custom SQL query and then use that View from within the SQL Spreads Designer.
In SQL Spreads, you can create tree-like filters to let your users select which data to load into Excel.
Are there any other differences between the Advanced Setup and the SQL Spreads Designer?
- The SQL Spreads Designer connects one SQL Server table per Excel worksheet. You can have multiple SQL Server tables in one Excel document, but you will have to put each table in a separate worksheet. In the Advanced Setup you can have several SQL Server tables in one Excel worksheet.
- When you refresh or save the data in a worksheet connected to SQL Server using the SQL Spreads Designer, only the data in that particular worksheet will be refreshed/saved to the database. Whenever you refresh or save to the database in an Excel document, all connections that are created using the Advanced Setup will refresh and save.