Skip to main content
Participant
April 7, 2008
Question

Dynamic page with xls file

  • April 7, 2008
  • 2 replies
  • 331 views
Hi

I want to create a page with coldfusion / Dreamweaver and use a xls file like a dynamic page.

Maybe somebody can help me.

This topic has been closed for replies.

2 replies

Inspiring
April 12, 2008
Check out Ben Nadel's POI Utility. It makes reading and writing Excel files quite easy and, as tclaremont mentions in his post, you can then use the Excel file as a datasource.

Ben Nadel's Utility is here:
http://www.bennadel.com/blog/624-ColdFusion-POIUtility-cfc-Updates-And-Bug-Fixes.htm

Another POI Utility for Excel files (called CFHSSF) is at RIA Forge:
http://cfhssf.riaforge.org/

I've never used CFHSSF but do use Ben's POIUtility.cfc and it's quite easy to implement.

Hope those help!

Best,
Craig
tclaremont
Inspiring
April 11, 2008
You can use an excel file as a data source just the same way you can use an Access or SQL Server database as a data source.