Questions tagged [cfspreadsheet]
111 questions
1
vote
1 answer
cfspreadsheet with large numbers needs to be formatted as a string
I have 16 digit number that needs to show all the digits. If I just key it into Excel I can put a ' in front of the number and it keeps the number from going into scientific notation. When I do the same in I get the number with a '…
James A Mohler
- 11,060
- 15
- 46
- 72
1
vote
1 answer
Coldfusion SpreadsheetAddImage function does not insert image
I am currently on CF version 9.0.1 and I'm having trouble getting the SpreadsheetAddImage function to properly insert an image into the spreadsheet that I am generating. I'm not getting any error message, its just that the image does not display in…
user1489298
- 50
- 6
1
vote
1 answer
reading excel and inserting into database
i am using the following code to handle the insets: but it is taking too much time, how can i enhance it or make in work faster:
Regual
- 377
- 1
- 5
- 20
1
vote
0 answers
Coldfusion SpreadSheetFormatCell fails in one app but not another
I copied an export cfc that creates an Excel file from a query object from another application to this application but for some reason it fails. I have used the exact same cfc in several other applications on the same server. It still works in the…
Aaron
- 1,042
- 2
- 12
- 30
1
vote
2 answers
ColdFusion CFSpreadsheet reads empty cells
I give my client a template that they are supposed to populate and then they upload the spreadsheet and I read the file with cfspreadsheet in order to copy the data into a database table.
Pretty easy. The template has only one column in it. The…
Joe Simes
- 124
- 1
- 9
1
vote
1 answer
Format as table
I'm using to output a database query to an Excel spreadsheet. When these spreadsheets are created manually it is possible to highlight all the cells and 'Format as table'. This means when the table header is clicked, the user can…
blarg
- 3,773
- 11
- 42
- 71
1
vote
1 answer
Images and formatting not working on a multi-tabbed XLSx file generated with ColdFusion
The code below will generate the file with two notable errors:
The SpreadSheetSetColumnWidth appears to stop working after 21 lines on the second tab
The image does not appear on the second tab
Hopefully this is just a rookie mistake and not…
BTThomas
- 151
- 1
- 2
- 8
1
vote
1 answer
Coldfusion: cfspreadsheet reading date incorrectly
Im using cfspreadsheet to read data from spreadsheets inside one of my applications. I've had a great deal of difficulty dealing with date columns. If I format the cell as date english (NZ) it displays right in the spreadsheet, but when I try to…
Rumpleteaser
- 4,142
- 6
- 39
- 52
1
vote
1 answer
Can I add a spreadsheet row and then format it?
I'm using cfspreadsheet to generate an excel spreadsheet. I'm adding rows one by one. Immediately after I add the row, I want to format it. Something like this:
froadie
- 79,995
- 75
- 166
- 235
0
votes
1 answer
Reference QoQ in CFSpreadsheet
I've inherited a page that builds an inventory query from four table and outputs them with a QoQ:
select *
from getJobs
where partnum =…
aparker81
- 263
- 1
- 5
- 23
0
votes
1 answer
ColdFusion: new sheet if query column values don't match
I have a query that shows results as below and it needs to export those results into excel. But instead of 1 sheet, I need multi tab excel sheets based on uniqueness of ID column
So the first sheet should be all results, 2nd spread sheet should be…
user2675939
- 361
- 2
- 6
- 22
0
votes
1 answer
SpreadsheetWrite
I'm using CFScript to create and save a spreadsheet. However, SpreadsheetWrite isn't producing a file.
...
...
...
spreadsheetWrite(sObj, yourSheet, "yes");
It does not produce an error, but there's no…
genericHCU
- 4,394
- 2
- 22
- 34
0
votes
1 answer
cfspreadsheet combine two sheets with one on top?
Is it possible to easily combine two xlsx spreadsheets? I basically just want to take sheet1 from spreadsheet1.xlsx and put it at the top of sheet1 on spreadsheet2.xlsx
Renshi
- 77
- 7
0
votes
1 answer
Mapping user spreadsheet columns to database fields
I’m not sure where to start on this project. I know how to read the contents of the excel spreadsheet, I know how to identify the header row, I know how to loop over the contents. I believe I have the UX portion worked out but I am not sure how to…
HPWD
- 2,232
- 4
- 31
- 61
0
votes
1 answer
How to read a big excel file using multithreaded programming in Coldfusion/Lucee?
I am trying to read a big excel file with using 10 threads as shown in the code bellow:
…
edam
- 910
- 10
- 29