Solved

multiple cfx_excel tags to parse different sections of excel spreadsheet?

Posted on 2008-10-15
1
505 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to Import and export files in WordPress. 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 : Click on Too…

615 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