Solved

multiple cfx_excel tags to parse different sections of excel spreadsheet?

Posted on 2008-10-15
1
503 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 …
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
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 update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

739 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