Monday 28-07-2014
About Us | Contact Us | FAQ | Support | Links
Coldfusion Custom Tags, CFXs, CFCs, Full Applications and more!
< Built by ColdFusion Developers, for ColdFusion Developers >
 
Home | Tag Categories | Latest Tags | Top Rated Tags | Top Selling Tags | My Account | Search | Sell Your Tags | Tags A-Z
CFX_Excel2Query

CFX_Excel2Query - Transform a Microsoft Excel file into a ColdFusion query without installing Excel on your server!
Developer Name: Ryan Emerle
Company Name: Emerle.net
Email Developer Email Developer:
Latest Version: 1.1.4
Price: $50
License: One Copy per Server.
Encrypted: Yes
Average Rating:
Times Rated: 11
Rate This Tag:


Tag Comments

There are no comments for this tag yet!
 Related ColdFusion Applications
Developers who purchased CFX_Excel2Query also purchased:
  1. CF_FileManager V3.2 (Cross Browser)
  2. CFX_HTTP5
  3. CFX_EXEC
  4. Excel Read/Write v3.2
  5. CFX_POP3 Standard
  6. CF_Zip Code Radius
  7. CF_TreeControl
  8. ProLetterFusion V1.7.2 (Unencrypted)
  9. CF_UPSMX
  10. CSV2Query


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.



Download the latest version direct from the author
 Usage
<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]">


 Attributes
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)


 


< Business Strength Coldfusion Custom Tags >
Sitemap | Privacy | Branding | Web Services | Support | Contact Us