CFX_Excel Example
Read Operation - Convert MS Excel File To ColdFusion Query
Upload Excel file to read:
Sheet name or index#:
Column to process:
Start:
End:
(type '0' in the end attribute to process all non-empty/edited columns)
Row to process:
Start:
End:
(type '0' in the end attribute to process all non-empty/edited rows)
Header row:
(Row containing column names, if any)
Number of decimal digits:
Formula:
Process
Show
Process merged cells:
True
False
Click here to see the CFX_Excel write example