Question: How to get excel sheet column/row value?

Question

How to get excel sheet column/row value?

Answers 1
Added at 2016-12-20 23:12
Tags
Question

I have a excel sheet

<cfspreadsheet action="read" src="test.xlsx" sheet=1 rows="2-7" format="html" name="csvData"> 

How would i get the value of specic column and output the value?

For example:

                     Actual 
testtet test         9040416.9299998 
test test tettest    6406129.51 

I would like to get column 2, row 3 which is the value of 6406129.51.

Answers to

How to get excel sheet column/row value?

nr: #1 dodano: 2016-12-21 06:12

This is how you can get the value of specific rows and column form excel.

<cfspreadsheet action="read" src="test.xlsx" rows="2-7" sheet="1" query="test"/>
<cfdump var="#test["col_2"][3]#">
Source Show
◀ Wstecz