Solved

multiple cfx_excel tags to parse different sections of excel spreadsheet?

Posted on 2008-10-15
1
489 Views
Last Modified: 2013-12-20
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">

Open in new window

0
Comment
Question by:dbarnes2
1 Comment
 
LVL 63

Accepted Solution

by:
Zvonko earned 500 total points
ID: 22761913
I assume what you get from that cfx_excel is a table liek from a cfquery.
Now you can use that one result table to do the next cfqueries with dbtype set to query.
Like this:
<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">
 

<cfquery name="tblEmployee" dbtype="query" >

  SELECT col1, col2, col3 from qryResult

</cfquery>
 

<cfquery name="tblExpense" dbtype="query" >

  SELECT col4, col5, col6 from qryResult

</cfquery>

Open in new window

0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now