Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-25 Thread Tom Chiverton
On Tuesday 24 Jun 2008, Les Mizzell wrote: > If I can figure out how to upgrade/install/whatever files on the server > (CF7 running on IIS), maybe I'm in business. You can use the JavaLoader CFC to load newer versions of a JAR into CF, without mucking about with replacing CF's files. -- Tom Chi

Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-24 Thread Les Mizzell
Tyler Fitch wrote: > There's a version of the POI library buried in the CF installation and you > could replace it with the newer version from the Apache group. But I > wouldn't recommend that as it could unexpectedly break some of CF in built > functionality. Yea - I sorta already figured that

Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-23 Thread Tyler Fitch
There's a version of the POI library buried in the CF installation and you could replace it with the newer version from the Apache group. But I wouldn't recommend that as it could unexpectedly break some of CF in built functionality. Personally I've used Mark Mandel's JavaLoader to reference the

Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-23 Thread Les Mizzell
>> After upgrading to the newer 3.0.2 version I had less issues. Heh - gotta love this: "The Jakarta POI (Poor Obfuscation Implementation) API is a fantastic way for Java programmers to access Microsoft document formats. The most mature API from Jakarta POI is the HSSF (Horrible Spreadsheet F

Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-23 Thread Les Mizzell
Tyler Fitch wrote: > Hi Les, > > Are you working with Excel 2007 files? Yea, darnit! Weird - one file will import fine, the next will toss an error. I can create all the spreedsheet files I want in Open Office, save them as Excel files and every single one of them works. Go figure. Client h

Re: Anybody using POIUtility.cfc to import from Excel?

2008-06-23 Thread Tyler Fitch
Hi Les, Are you working with Excel 2007 files? I've had issues with reading the latest version of Excel files using the version of the POI library included in CF. After upgrading to the newer 3.0.2 version I had less issues. HTH, t On Mon, Jun 23, 2008 at 1:46 PM, Les Mizzell <[EMAIL PROTECTE

Anybody using POIUtility.cfc to import from Excel?

2008-06-23 Thread Les Mizzell
I've got it working pretty darned good - except for one problem. If there's a NULL cell in the Excel sheet, it's throwing an error "Element CELL is undefined in LOCAL." LOCAL.CellType = LOCAL.Cell.GetCellType(); If I go into my Excel sheet and just enter a space in the cells, no error. So, I'