dbarnes2
asked on
multiple cfx_excel tags to parse different sections of excel spreadsheet?
we are creating a CF applicaiton to load an excel expense report into an access db using the CFX_EXCEL tag we bought from /www.masrizal.com. In the Excel spreadsheet, the first xnumber of columns and rows are reserved for details about the employee, employee name, id #, etc. The next xnumber of columns and rows are for specifcs on the expense - date, incurred, cost center #, meals amount, auto amount, airfare amount, etc. I need to submit the employee information in one table and the expense information into a seperate table in an Access db. The CFX_Excel tag seems either parse all of the data into one large output or I can seperate the data as I have done with modifying the values to be specific for one section, but then I am only returning one section of the sheet and not he other. I am a novice with CF but any help is appreciated.
<cfx_excel action="read"
File="#prodThumbDir#/#prodThumbFile#"
Sheet= "1"
Result="qryResult"
Formula="process"
StartRow="5"
EndRow="17"
StartCol="A"
EndCol="0"
HeaderRow="4"
ProcessMerged="True"
DecimalDigit="2">
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.