Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
cfspreadsheet column limit
17 views
Skip to first unread message
Joe L
Aug 8, 2018, 2:29:53 PM8/8/18
to
Hello,
We are using Coldfusion 9.0.2 on a Windows server 2008 R2. I have a MS Excel Spreadsheetwhich has 192 rows and 40 columns. When I use <cfspreadsheet> to read the .xls file, it seems to read all of the rows and columns. Here is the tag I am using
<cfspreadsheet action="read" src="#outdir#\#infile#" query="theData2" sheetname ="xyz" headerrow="1" />
The xsheet has columns A - AU populated with data. When I dump the #theData2# it shows all of the rows and columns. I then do a <cfloop query="theData2"> and print out one of the fields for each row.
It looks like any column after AM gives the error "Variable col_name is undefined". The same thing happens if I change the <cfloop> to <cfouput query="theData2">. This appears to be a limitation. Has anyone come across this limit also? Any ideas to get around this are greatly appreciated.
Joe
We are using Coldfusion 9.0.2 on a Windows server 2008 R2. I have a MS Excel Spreadsheetwhich has 192 rows and 40 columns. When I use <cfspreadsheet> to read the .xls file, it seems to read all of the rows and columns. Here is the tag I am using
<cfspreadsheet action="read" src="#outdir#\#infile#" query="theData2" sheetname ="xyz" headerrow="1" />
The xsheet has columns A - AU populated with data. When I dump the #theData2# it shows all of the rows and columns. I then do a <cfloop query="theData2"> and print out one of the fields for each row.
It looks like any column after AM gives the error "Variable col_name is undefined". The same thing happens if I change the <cfloop> to <cfouput query="theData2">. This appears to be a limitation. Has anyone come across this limit also? Any ideas to get around this are greatly appreciated.
Joe
0 new messages