Questions tagged [cfspreadsheet]
111 questions
0
votes
1 answer
reading Excel (93-97) sheet with more than 65536 rows using cfspreadsheet
Hi I have to deal with data that is more than 65536 rows. and hence it comes into 2 different Excel Sheets, named as "Details" and "Details_1".
Basically whats happening is uploading Excel sheets, and using "cfspreadsheet" to "read" this data.
Once…
Fransis
- 275
- 1
- 5
- 15
0
votes
2 answers
Adding text / extra queries to cfspreadsheet output
I'm running Coldfusion 10 on Microsoft Windows Server 2008 R2 Data Center – SP 1 with a SQL Server 2012 datasource.
I have a cfspreadsheet tag on a page that goes like this:
Barrett Chamberlain
- 119
- 1
- 2
- 16
0
votes
2 answers
ColdFusion10 - query cfloop over an insert query
First post here. I'm using to create a query from Excel and then trying to insert the query results into MySQL table. That's working fine. I also need to take a value from one column and insert its proper ID number into the ID…
RobK
- 5
- 3
0
votes
2 answers
Coldfusion generated spreadsheet does not allow column formating
When creating a spreadsheet from a query, the spreadsheet that is produced will not allow a column of a datetime datatype to be formatted.
The spreadsheet creation is: