Sharing Ideas And Solutions <a href="index.cfm?fuseaction=idea.newsletter_subscribe">Our Newsletter</a> Downloadable Solutions PHP Classes For Small &amp; Medium Enterprise Free For Non-Profit Organization Customer Feedback Contact Us Featured Web Template View More Templates MasRizal In Numbers * 25 years in business. * 6856 corporations in 67 countries have chosen our products and service. * 73.20% are using more than one solutions from us. - MasRizal &amp; Partners -Enhancing Business With Trust CFX_Excel (Evaluation version) Custom Tag: CFX_Excel (Evaluation version) Version: 3.2(c) 2009, MasRizal &amp; Partners Indra Gunawan, indra.gunawan@masrizal.com Rizal Firmansyah, rizal.firmansyah@masrizal.comCFX_Excel is a quick solution to read and write Microsoft Excel files without using MS Excel or any other COM object.Using Jakarta POI, CFX_Excel can be used in any platform that supports ColdFusion MX and aboveThe read operation will transform Excel file into ColdFusion query. While the write operation will transform ColdFusion query to Excel file. Limitation on evaluation version:1. READ -&gt; will only read the first 10 rows of data.2. WRITE -&gt; will only write the first 10 rows of data. New in v3.2: - Ability to specify data type for each column New in V3:- Full unicode characters support. Many thanks goes to our customers from Japan, China and France for requesting this feature.- Ability to set number of decimals converted to CF query. Using the new &quot;DecimalDigit&quot; attribute, you can now specifically tells how many decimal digit should CFX_Excel read from the Excel file.- Merged cells support. By popular demands, merged cells can now be processed as if the all merged cells contain the same value in the CF query. New in V2:- PreserveStyle attribute for writing Excel file. Keep the template cell style's for newly inserted rows- Sample for template usage is now provided- Better support for large records. Microsoft Excel has style limitation as advised by Microsoft: http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;213904In V2, CFX_Excel will minimize the number of style to conform Microsoft Excel limit.Many thanks goes to Lidia Galluzzo from Cingular Wireless, and Irvin Gomez from Pixel69 for notifying us about this issue. CFX_Excel v2 is now safe for writing thousand of records.- Better support for reading styled Excel files. Many thanks goes to Audie Roldan from Tranax for testing CFX_Excel styled document capabilty. Features Requirements Usage Application Example <h1> Fast operation Ability to read Microsoft Excel files and transform the content to ColdFusion query Ability to write ColdFusion query to Microsoft Excel files Support for template.</h1>[h1] Use template as a based for writing Excel file.[/h1][h1] Template may contains Excel objects, such as image, chart.[/h1][h1] Great for creating report with your company logo on it.[/h1][h1] No need to programmatically set individual header, footer, font style, borders, print areas and others!Just set them in the Excel file, feed them as a template to this tag, and it's done! Try our new template sample to see what we mean.[/h1][h1] Support for Excel formulas.[/h1][h1] Formula can be read and write as string, or process the result as the latest value calculated by Microsoft Excel.[/h1][h1] Support for multiple sheets, of course Support for unicode character set Works using Jakarta Java POI.[/h1][h1] No Microsoft Excel or any other COM object needed in the server.[/h1][h1] [/h1]Supported ColdFusion Server: ColdFusion MX 6, 6.1 ColdFusion MX 7 ColdFusion 8 on all operating systems Supported browsers:Since this tag is working on server side, all browsers are compatible. Note:Jakarta POI is included in cfx_excel tag. No need to install any additional files. Installing CFX_Excel requires Java CFX registration from ColdFusion Administrator. To convert Microsoft Excel file into ColdFusion query (read operation): &lt;cfx_excel action=&quot;read&quot; File=&quot;Full path and name of XLS input file, required&quot; Sheet=&quot;Sheet name or index number, optional default=Sheet1&quot; Result=&quot;output query name, required&quot; Formula=&quot;[process/show], optional default='process'&quot; HeaderStyle=&quot;[A/ZA/1/01], optional default='A'&quot; HeaderRow=&quot;Row to be treated as Column Header, optional&quot; DecimalDigit=&quot;Number of decimal digits outputted to CF query. Default is 255 which will extract every single digit&quot; ProcessMerged=&quot;true|false. True means every merged cells in Excel file will have one same value each in the resulting query. Default is false (v2 behaviour)&quot; StartRow=&quot;start of row to return, default =1&quot; EndRow=&quot;end of row to return, default = 0&quot; StartCol=&quot;start of Col number, default=A&quot; EndCol=&quot;end of col number, default=0&quot;&gt; Explanation:1. Formula=&quot;show&quot; means the resulting query will contain the original formula (as string).Formula=&quot;process&quot; means the resulting query will contain the result of each formula found in the XLS file.2. Header style is the Query Fields numbering scheme:A = A,B,C,D,...,AA,AB,AC,..ZA= A,B,C,D,...,ZAA,ZAB,ZAC,...1= COL_1,COL_2,...01= COL_001,COL_002,... 3. HeaderRow if specified (or not equal to 0) will override the HeaderStyle4. EndCol=0 means CFX_Excel will convert all non-empty (or has been edited) columns.5. EndRow=0 means CFX_Excel will convert all non-empty (or has been edited) row. To convert ColdFusion query into Microsoft Excel file (write operation): &lt;cfx_excel action=&quot;write&quot; File=&quot;full path and name of XLS output file, required&quot; Template=&quot;Full path and name of XLS template file, optional&quot; Query=&quot;CF input query, required&quot; Sheet=&quot;Sheet name or index number, optional default=Sheet1&quot; Formula=&quot;[process/show], optional default='process'&quot; HeaderRow=&quot;Row to be treated as Column Header, optional&quot; StartRow=&quot;start of row to return, default =1&quot; StartCol=&quot;start of Col number, default=A&quot; ColumnList=&quot;list of columns to write, must match the query field name to write,optional&quot; InsertRow=&quot;[yes/no], optional. Default=yes&quot; PreserveStyle=&quot;[yes/no], optional. Default=yes ColumnTypeList=&quot;Comma delimited list of data type for each column, optional&quot;&gt; Explanation:1. Formula=&quot;show&quot; means the resulting query will contain the original formula (as string).Formula=&quot;process&quot; means the resulting query will contain the result of each formula found in the XLS file.2. HeaderRow, if specified (or not equal to 0) will write the column names in given row4. Template, if specified CFX_Excel will use the given file as a base for writing query data.By using template, you can add your company logo, formulas, chart or any other Excel object prior to adding the data from query.The resulting XLS file will be the original template + query data.5. InsertRow, true means CFX_Excel will insert row starting at 'StartRow' position. Thus shifting below all other rows.Mostly usable when you use Template, so the data will not overwrite anything in the template file.6. New in V2 is PreserveStyle. True means CFX_Excel will try to keep the original style of each cell as found in template.If cell style and query data doesn't match, CFX_Excel will try to format the cell with datatype of query, thus overwriting the template.7. New in V3.2 is ColumnTypeList.This is a comma delimited list to set the data type for each column.Allowed values are: Integer: 32-bit integer BigInt: 64-bit integer Double: 64-bit decimal number Decimal: Variable length decimal, as specified by java.math.BigDecimal VarChar: String Binary: Byte array Bit: Boolean (1=True, 0=False) Time: Time Data: Date (can include time information) Limitation on evaluation version:1. READ -&gt; will only read the first 10 rows of data.2. WRITE -&gt; will only write the first 10 rows of data. This tag comes in handy when you need to export or import data from Microsoft Excel file to your ColdFusion application.Why Excel? Simple: Excel is one of the most widely used spreadsheet application. Below is list of applications where this tag will be useful: CF website that needs to write data into Excel file, such as reporting website. CF website that needs to read data from Excel file. e-Commerce, backend application. Save report to Excel file, or import product data from Excel file. And many others! Please download the custom tag by clicking button below and install it in your server.The downloaded file contains documentation and examples for you to test. (Tabbed page powered by CF_Tab) Licensing Information CFX_Excel (Evaluation version) is available for immediate download. After registration, you will receive a confirmation email with your download link. Please ensure your email address is entered correctly during the evaluation process. Customers Who Downloaded CFX_Excel (Evaluation version) Usually Purchased These Products Too 1. CSV2Query 2. CF_Query2FixWidth 3. CF_FixWidth2Query 4. Related Select 5. CF_USPS_Rate 6. CF_Tab 7. CF_ZIP 8. Slidebar Menu 9. CF_FlashMultiUpload 10. Query2CSV MX Why Customers Choose Us Find out why our valued customers choose MasRizal &amp; Partners solutions. Click here to see their reasons Featured Customers More than 6850 companies rely on MasRizal &amp; Partners solutions. Click here to see our featured customers Free For Non-Profit Organization MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost. Click here for program detail Testimonials Take the word of our clients Top Selling Products See our top selling products Let Us Help You Can't find solution you need? Click here to get solution from MasRizal.
write,tag,poi,excel,database,query,custom,import,coldfusion,fusion,file,cf,cold,read,java,comSharing Ideas And Solutions

Our Newsletter
Downloadable Solutions
Free For Non-Profit Organization
Customer Feedback
Contact Us
Image Compressor 2008.
Batch recompress, resize, rotate and watermark your image.
Save up to 10x more in any storage.
Speed up upload, download, and e-mail transmission time.
Featured Web Template
MasRizal In Numbers

* 25 years in business.
* 6856 corporations in 67 countries have chosen our products and service.
* 73.20% are using more than one solutions from us.

- MasRizal & Partners -
Enhancing Business With Trust
CFX_Excel (Evaluation version) Cheapest Only At MasRizal.Com

Custom Tag: CFX_Excel (Evaluation version)
Version: 3.2
(c) 2009, MasRizal & Partners
Indra Gunawan, indra.gunawan@masrizal.com
Rizal Firmansyah, rizal.firmansyah@masrizal.com

CFX_Excel is a quick solution to read and write Microsoft Excel files without using MS Excel or any other COM object.
Using Jakarta POI, CFX_Excel can be used in any platform that supports ColdFusion MX and above
The read operation will transform Excel file into ColdFusion query. While the write operation will transform ColdFusion query to Excel file.

Limitation on evaluation version:
1. READ -> will only read the first 10 rows of data.
2. WRITE -> will only write the first 10 rows of data.

New in v3.2: 
- Ability to specify data type for each column

New in V3:
- Full unicode characters support. Many thanks goes to our customers from Japan, China and France for requesting this feature.
- Ability to set number of decimals converted to CF query. Using the new "DecimalDigit" attribute, you can now specifically tells how many decimal digit should CFX_Excel read from the Excel file.
- Merged cells support. By popular demands, merged cells can now be processed as if the all merged cells contain the same value in the CF query.

New in V2:
- PreserveStyle attribute for writing Excel file. Keep the template cell style's for newly inserted rows
- Sample for template usage is now provided
- Better support for large records. Microsoft Excel has style limitation as advised by Microsoft: http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;213904
In V2, CFX_Excel will minimize the number of style to conform Microsoft Excel limit.
Many thanks goes to Lidia Galluzzo from Cingular Wireless, and Irvin Gomez from Pixel69 for notifying us about this issue. CFX_Excel v2 is now safe for writing thousand of records.
- Better support for reading styled Excel files. Many thanks goes to Audie Roldan from Tranax for testing CFX_Excel styled document capabilty. 

(Tabbed page powered by CF_Tab)   


Licensing Information

CFX_Excel (Evaluation version) is available for immediate download.
After registration, you will receive a confirmation email with your download link.
Please ensure your email address is entered correctly during the evaluation process.



Customers Who Downloaded CFX_Excel (Evaluation version) Usually Purchased These Products Too
1. CSV2Query 2. CF_Query2FixWidth 3. CF_FixWidth2Query
4. Related Select 5. CF_USPS_Rate 6. CF_Tab
7. CF_ZIP 8. Slidebar Menu 9. CF_FlashMultiUpload
10. Query2CSV MX

Why Customers Choose Us
Find out why our valued customers choose MasRizal & Partners solutions.
Click here to see their reasons

Featured Customers
More than 6850 companies rely on MasRizal & Partners solutions.
Click here to see our featured customers

Free For Non-Profit Organization
MasRizal Charity program allows eligible nonprofit organizations to get MasRizal's products at no cost.
Click here for program detail
Testimonials
Take the word of our clients

Top Selling Products
See our top selling products

Let Us Help You
Can't find solution you need?
Click here to get solution from MasRizal.
© Copyright 1999-2024 MasRizal & Partners
All Rights Reserved.
OISV - Organization of Independent Software Vendors - Contributing Member    Solutions for designers provided by TemplateMonster.com    Payment processing by 2Checkout    2Checkout.com supports Master Card Secure Code    2Checkout.com is verified by Visa
HALF PRICE SLASH TODAY!
Get 50% Discount
on Premium Component Collection

+ FREE Lifetime Upgrade.
Best Investment.


Offer valid until March 31, 2024

Use Coupon: HALFPRICE3
(Copy this coupon and use it during checkout)

Buy Premium Component Collection With 50% Discount

[ X Close This Window ]