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 (1)

Subscribe to this comment's feed

rehana said:

	... If in case the component don't work after purchasing and we will stuck somewhere then what will be use of purchasing we need the guarantee of it. Report Generation Module requirement. Generate various reports about, volunteer work, funds raised, and donations. Etc, this should be added in this component and i want to know whether this is possible in this component. thanks rehana
	report abuse vote down vote up

April 01, 2010
Votes: +0