Well, there is always automating excel on the server ((shudder)) through COM. Unfortunately, it looks like Dain Anderson's old site, cfcomet, is off the air(however, with a coming soon message), but if you want to try this method, let me know and I can send you some code and advice.
Also, I know of some java tools to read and create excel files, but haven't tried any of them... http://jakarta.apache.org/poi/ http://andykhan.com/jexcelapi/index.html they would be a lot cleaner, I'm sure. -jim On 2/24/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote: > Hey All, > > So it's rather simple to extract data from a spreadsheet with tabular data, > but what about complex Excel forms that contain perhaps name and date prompts > all formatted nicely with tabular data elsewhere in the worksheet? > > How would I go about getting the contents of one of those into CF to be > parsed? > > I'm asking because all I'm finiding is methods to parse simple CSV files or > to convert those files into CF queries or convert CF queries to XLS files ;-) -- Jim Wright Wright Business Solutions [EMAIL PROTECTED] 919-417-2257 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
