 |
Developer Name: |
Ryan Emerle |
 |
Company Name: |
Emerle.net |
 |
Email Developer: |
Email Developer |
 |
Date Created: |
Wednesday 18/05/2005 |
 |
Latest Version: |
1.1.4 |
 |
Price: |
$50 |
 |
License: |
One Copy per Server. |
 |
Encrypted: |
Yes |
 |
Average Rating: |
 |
 |
Times Rated: |
10 |
Tag Comments
|
There are no comments for this tag yet!
|
Related ColdFusion Applications
Developers who purchased CFX_Excel2Query also purchased:
- CF_FileManager V3.2 (Cross Browser)
- CF_ProFlashUpload
- CFX_HTTP5
- CFX_EXEC
- CF_WebBoard V2.1 (Cross Browser/Un-Encrypted)
- CF_TreeControl
- CFX_POP3 Standard
- CF_Zip Code Radius
- ProLetterFusion V1.7.2 (Unencrypted)
- CF_UPSMX
|
What Is CFX_Excel2Query? |
|
Transform a Microsoft Excel file into a ColdFusion query without installing Excel on your server! This tag is written in 100% java, so there is no need for the dreaded COM. This tag works best with simple Excel files, but many have had luck with extremely complex files. |
<cfx_excel2query
file="[path_to_xls_file]"
firstRowIsHeader="[true|false]"
sheet_name="[worksheet_name]"
sheet_num="[worksheet_number]"
startRow="[starting_row]"
maxRows="[max_rows]"
longNames="[true|false]"
r_qResults="[query_variable_name]"> |
| Attribute |
Req'd |
Description |
| file |
Yes |
full path the Microsoft Excel file |
| r_qResults |
Yes |
the variable in which to store the resulting query |
| firstRowIsHeader |
No |
specifies whether or not the first row of the Microsoft Excel file should be used for the column names in the query |
| sheet_name |
No |
specifies a specific worksheet name (case sensitive) to use from the Microsoft Excel file |
| sheet_num |
No |
specifies a worksheet by a number (zero-based; first sheet is zero, second sheet is 1, etc) - If sheet_num and sheet_name are both specified, sheet_num is used. |
| columnlist |
No |
the list of column names in their original order is returned to the variable you choose here (especially useful when firstRowIsHeader) |
| startRow |
No |
The row number, starting at 1, you would like to start from |
| maxRows |
No |
The total number of rows from startRow that you want to return |
| longNames |
No |
Use zero padding on column names (i.e. column001,column002,..,columnN) | |
|
|
[Add Your Comment To This Tag]