Is CF9 limited to the versions of Excel it will work with? I've got an application running in CF8 to import email/name lists using the POI Utility (thanks Ben Nadlel). When (and it's not often) the client normalizes their data and removes all formatting, AND uses a pre Excel 2007 file (.xls), the utility works great.
That usually doesn't happen - there's formatting, and gawd knows what they leave in the files. If it's a small list being imported, the utility will usually manage to chew through it and import the data. Larger files (1000+ records) though - usually time out and the import fails. Excel 2007 (.xlsx) and forward usually fails too. I'm not sure what my solution is yet. I need a more robust utility and that can what they're going to throw at it, because they're NOT going to worry about formatting, or converting the files to csv, or any of that stuff... I've thought about using a ODBC Socket and use the Excel as a datasource and read from that, but there's no way I'm going to convince them to ALWAYS have that first row as the column headers either. YES - I know this is partially a problem with the client! Nothing I can do about that part! They pay well and often.... I've not had a chance to work with cfspreadsheet yet. Works OK reading different version Excel files? What other experiences has everybody had? If folks seem to think it works better than what I'm doing in CF8, I'll convince them to upgrade their server... Thanks, Les ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
