SQL 2 Excel Pro - Export in CSV and HTML formats PDF Print E-mail

You can export your reports in CSV as well as HTML formats with SQL 2 Excel Pro. The download format is configurable for each individual  Workbook which gives you total flexibility.


download_formar_sel

  • There are a lot of tools that accept CSV files as inputs so this feature enables you to serve more than Excel users with data from your Joomla reports. Excel row limit is 65536 rows. A CSV file does not have such restrictions.

  • HTML format can be used for various things, such as embedding into other pages in an iFrame, copy and paste into a Word document or use it together with an Excel Web Query.

  • Note! Only the main SQL query defined for the Workshet is included in the CSV or HTML output. Extracells, Header & Footer are not included.

  • By default, the first Worksheet in your report is output. You can however output a specific Worksheet if you want by adding &sheet=[sheet_id] to the URL. More info.


You can define how the linefeeds are handled for each output format under SQL 2 Excel Pro > Settings > Writers.

crlf_settings

 

Comments (1)add comment

aassdd said:

aassdd
...
The NBA players union and the boss finally alliance did not reach an agreement, the commissioner David stern but the announcement of the new season two weeks before the arrangement was forced to cancel.
cheap nfl jersey
 
October 25, 2011
Votes: +0

Write comment
You must be logged in to post a comment. Please register if you do not have an account yet.

busy
 
 
  Design by augs-burg.de & go-vista.de  
 
     
 
   
 

The Joomla!(R) name is used under a limited license from Open Source Matters in the United States and other countries. http://Joomla-R-Us.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.