Solved

multiple cfx_excel tags to parse different sections of excel spreadsheet?

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

861 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

23 Experts available now in Live!

Get 1:1 Help Now