Re: CF9 and Excel - advice sought

2012-01-09 Thread Cameron Childress
On Wed, Jan 4, 2012 at 7:42 PM, Les Mizzell wrote: > 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

Re: CF9 and Excel - advice sought

2012-01-08 Thread Leigh
> Larger files (1000+ records) though - usually time out and the import > fails. Excel 2007 (.xlsx) and forward usually fails too. A thousand records is not a huge amount, unless there are a large number of columns involved.  How many columns? What portion of the process consumes the bulk of t

CF9 and Excel - advice sought

2012-01-04 Thread Les Mizzell
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),