CFX_Excel Example

Write Operation - Convert ColdFusion Query To MS Excel File

This is sample query
to be written in the Excel file:
query - Top 6 of 6 Rows
  ADVANCEDNAMESCORETIME
1 True Sample student 1 57.0136986301 {ts '2012-02-06 07:42:35'}
2 True Sample student 2 41.0476190476 {ts '2012-02-05 07:42:35'}
3 True Sample student 3 70.0158730159 {ts '2012-02-05 07:42:35'}
4 True Sample student 4 24.0769230769 {ts '2012-02-11 07:42:35'}
5 True Sample student 5 3.01470588235 {ts '2012-02-06 07:42:35'}
6 True Total Score =sum(C2:C6) [empty string]
Upload Excel template file:
(If template is specified, the query will be added to this file)
Sheet name:
Start write at column: Start:
Start write at row: Start:
Header row:
(Type '0' if you don't want to write column names in resulting Excel file)
Column list:
(optional. List of columns to process)
Formula Process
Show
Insert row True
False
Preserve style True
False
If yes and InsertRow=true, CFX_Excel will try to keep the layout and formatting of inserted rows using one found in template.
If the template has incompatible format, such as date compared to string, CFX_Excel will re-format using data from query.


Not sure how to use template? Try our sample template | Click here to see the CFX_Excel read example