Solved

multiple cfx_excel tags to parse different sections of excel spreadsheet?

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Search on a site 5 114
Strange space issue in Chrome browser 8 114
Question to locate the problem 18 127
DW 2017 background color change 5 9
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
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 add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…

829 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