On 11/8/06, Robert Harrison <[EMAIL PROTECTED]> wrote: > Now I'm canning the EXCEL COM object and using CFHTTP to parse a comma > delimited format. This works fine when the data is perfect. But when this > data is missing a column from a row and doen't have the right number of > columns it says wrong number of rows and craps out.
Sorry, been busy staging a picture for Bobby, with me holding a wooden table over my head, pretending to smash down on the camera. =-P I've got some code that uses the JExcelAPI to import/export excel files. I already tackled all the issues with not the same number of cols, etc., along with a little date conversion and some other little tweaks. JExcelAPI roxerz! I'll post a link, if I think about it, as I've got it in google code somewhere... I may have posted a link already, not too sure. You'd need createobject permission, if you're on a shared server. Ping me off list if you're still looking for a excel solution- I'm busy and haven't been watching cf-talk too close. -D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
