Documentation and help for SQL 2 Excel :

• Installation Instructions
  
  
• Tutorial
  
  
• Demo
  
  
• Understanding Workbook / Worksheet access
  
  
• Substitution Variables - How-to
  
  
• Substitution Variables - Reference
  
  
• Formulas
  
  
• Import & Export Workbooks to XML
  
  
• SQL 2 Excel Forum
  
  

SQL 2 Excel Pro

Documentation for the additional features included in SQL 2 Excel Pro:

• Copy Worksheets & Workbooks
  
  
• Add additional cells with text and formulas anywhere in the spreadsheet
  
  
• Worksheet - SQL Query Help Tabs
  
  • Ajax based on-the-fly Syntax / Error check of your SQL Query, directly in the Worksheet form
  • List available tables and fields from the database to help you write your queries
  • Explain your SQL query, fine tune the performance of your query
    
    
• Formatting
  
  
• Setup Database Connections and extract data from external databases
  
  
  • Using a Custom Database Driver
  
  
• Create worksheets based on multiple SQL queries
  
  
• Create parameterized reports with Workbook Parameters
  
  

• Creating dynamic spreadsheets using Excel Web Queries

  
  
• Insert Bitmap Images into your spreadsheets
  
  
• Using the Scheduler
  
  
• Export in CSV and HTML formats (as well as XLS)
  
  
• Data Grid Plugin

Comments (0)

Subscribe to this comment's feed

Name

Email

Comment

smaller | bigger

Subscribe via email (registered users only)

I have read and agree to the Terms of Usage.

Write the displayed characters

Add Comment