This content has been marked as final. Show 3 replies
Please suggest how do I check an .xls file if all these conditions are
filled per row (assuming that there would be 40 rows per upload per user
per day). Do I check the .xls file or do I check for these validations
somewhere else, if yes where and how ??
Either on these forums of the House of Fusion forums, I recently read a
thread about using excel as a datasource. That may offer you some options.
The file could be uploaded to a given location. That location is
configured as a datasource. Use standard SQL operations against it.
Will try what has been suggested. Is there anything more conventional though?
Why couldn't you upload the Excel and then use cfhttp to take it and turn it
into a query which you can loop into a database? I do that with CSV files
all the time. Wouldn't that work for Excel?