Support

XLSAdapter is provided with limited support. Reported bugs will be fixed. Questions can be sent to support@xlsadapter.com and time permitting they will get answered. Advanced support and customizations may be purchased.

Installation

Install Custom Tags:

Copy all of the custom tags (the *.cfm files) to the standard ColdFusion custom tag directory(C:\CFusionMX7\CustomTags\). ColdFusion will pick these changes up automatically. Alternatively you may also put these in another directory and then add that directory to "Custom Tag Paths" section of ColdFusion Administrator.

Install the JAR File:

Copy XLSAdapter-demo-1.22.jar or XLSAdapter-1.22.jar into your location for jar files used with ColdFusion. For example, we create a directory (C:\ColdFusionJars) to hold all of the jar files that are not part of the standard ColdFusion install. IMPORTANT: If you are installing this on a version prior to ColdFusion MX 7, (i.e. ColdFusion 6.1) you must also download the Apache release of POI from http://www.apache.org/dyn/closer.cgi/jakarta/poi/ . Once you download the latest release put all of the JAR files into the same location you put the XLSAdapter JAR file.

Install Samples and Documentation:

Copy the XLSAdapter.com folder to webserver root (C:\Inetpub\wwwroot).

Configure ColdFusion:

  • Open ColdFusion Administrator
  • Add the JAR File to the Class Path:
    • Click on Java and JVM.
    • Add the full path to the JAR file in ColdFusion Class Path. If you stored it in C:\ColdFusionJars, add C:\ColdFusionJars. If you did NOT stored it in C:\ColdFusionJars then put in the path to where you stored it. Separate multiple directories with commas.
  • Register the CFX_XLSReader tag:
    • Click on Extensions.
    • Click on CFX_Tags.
    • Click the button Register Java CFX.
    • Enter cfx_XLSReader for the Tag Name and com.xlsadapter.XLSReader for the Class Name.
  • Add the Data Source for the Database Example:
    • Click on Datasources.
    • In the Add Data Source section use xlsadaptersampledb as the Data Source and Microsoft Access as the Driver.
    • Click the Add button.
    • Use c:\Inetpub\wwwroot\XLSAdapter.com\samples\sampledb.mdb as the Database File.
    • Click the submit button.
    • Verify that the data source is ok by looking for the words OK in the Status column.
  • Restart the ColdFusion Server or restart the computer.

Testing:

Open http://localhost/XLSAdapter.com/samples/index.html

Documentation:

Open http://localhost/XLSAdapter.com/docs/index.html

FAQ

  1. Q: Will XLSAdatper work for ColdFusion MX 6.1?
    A: Yes, XLSAdapter supports both ColdFusion MX 6.1 and 7.0. However ColdFusion MX 6.1 requires Apache's POI on the server, see above instructions or the download page for more information.
  2. Q: How is the demo version restricted?
    A: The demo version is restricted to only output/input 10 rows of data to a workbook.
  3. Q: What Excel workbook version does XLSAdapter output?
    A: XLSAdapter supports writing and reading Microsft Excel 97 files.

Changes/Updates

  • Version 1.23
    • Fixed bug that caused a ColdFusion expression to not be evaluated correctly when passed to one of the custom tags.
  • Version 1.22
    • Fixed bug that caused too many cell styles to be created (duplicates). This caused excel to complain.
    • Updated the documentation.
  • Version 1.21
    • Fixed bug that caused an exception to be thrown when a cell's type was set to numeric/number but no value(i.e. a number) was given.
    • Fixed bug that caused an exception to be thrown when a cell's type was set to date but no value(i.e. a date) was given.