Questions tagged [cfspreadsheet]
111 questions
9
votes
2 answers
cfscript equivalent of cfspreadsheet action="read"
What is the equivalent of this...
in cfscript?
cfscript has spreadSheetRead(fileName) - but the result is an object with the file metadata, Even if I specify the sheet,…
j-p
- 3,698
- 9
- 50
- 93
8
votes
1 answer
Format a text on cell in two color in Coldfusion
Using Coldfusion 10, I need to format a cell contents in two color(Black and Blue). Let a cell on spreadsheet contains a string "Text1: Text2". where color of "Text1" should be black and "Text2" should be blue.
I have tried below code, but it…
Prak
- 815
- 7
- 18
8
votes
1 answer
Create an excel file export with non standard column names (with spaces) using cfwheels, coldfusion and cfspreadsheet
This is more of a how-to than an actual question. (I searched and couldn't find a solution, so I came up with this)
I needed to create an excel file export that would allow users to :
filter the data using a form, from the original table
Export the…
Bob Marley
- 238
- 1
- 9
7
votes
1 answer
ColdFusion Spreadsheet Memory issue
I am using ColdFusion to export a fairly few number of rows (around 1000) but large number of columns (around 300) to Excel. It is a multi-sheet Excel file with at least two of the sheets having the large number of columns. Using cfspreadsheet…
DG3
- 5,070
- 17
- 49
- 61
6
votes
1 answer
cfSpreadsheet 2-digit years
In ColdFusion 11, I'm using cfSpreadsheet to convert a .xls file into a query object. Here is a screenshot of my demo spreadsheet:
I use this code to see the query object as soon as it is created:
M.Shute
- 347
- 1
- 2
- 11
6
votes
1 answer
How to access query column with multiple words?
I'm using a cfspreadsheet read to read a sheet into a query object.
The problem is, some of the headers contain more than one…
froadie
- 79,995
- 75
- 166
- 235
6
votes
1 answer
Can I adjust the widths of Excel columns without setting them each individually?
I'm using cfspreadsheet to generate an Excel spreadsheet using ColdFusion. I insert a header row, and then use spreadsheetAddRows to dump a query into the sheet. The problem is that the columns are often not wide enough. I know I can use…
froadie
- 79,995
- 75
- 166
- 235
5
votes
2 answers
CFSpreadSheet functions using up memory for large data sets
We have a Coldfusion application that is running a large query (up to 100k rows) and then displaying it in HTML. The UI then offers an Export button that triggers writing the report to an Excel spreadsheet in .xlsx format using the cfspreadsheet…
teaman
- 469
- 7
- 18
5
votes
1 answer
Conditional Formatting Excel File Using ColdFusion
I'm building a spreadsheet dynamically using the cfscript spreadsheetNew method.
i.e.
downloadDoc = spreadsheetNew("spreadSheetName");
spreadsheetAddRow(downloadDoc,"spreadsheetCols");
....
One of the columns I'm…
kuhl
- 172
- 1
- 11
5
votes
1 answer
Query created from Query returned from cfspreadsheet not having proper values
Today I came across a very odd case while reading a vlue from a spreadsheet and trying to filter them on a condition and a create a spreadsheet from the filtered data. Here are my steps
Read Excel sheet
shemy
- 573
- 1
- 5
- 15
4
votes
3 answers
Coldfusion CSV to Spreadsheet
I have a few processes that utilize the CFSpreadsheet tag to import and then manipulate Excel data. This works great for .XLS & .XLSX files, however, it doesn't work if the data is sent as a .CSV file since CFSpreadsheet apparently was never…
Paul B
- 93
- 5
4
votes
2 answers
How can I define the number of rows on cfspreadsheet object?
I am in the process of learning ColdFusion and I am trying to work with spreadsheets using spreadsheetFormatRows(spreadsheetObject, dataFormat, rangeOfRowsFormated)
How can I set the range to include all of the rows, except the header row, which is…
DoArNa
- 491
- 2
- 9
- 29
4
votes
0 answers
cfspreadsheet cell data trim issue on different ColdFusion versions
Take the following code...
#data["Doc…
gfrobenius
- 3,987
- 8
- 34
- 66
4
votes
1 answer
CFSpreadsheet borders for Merged Cells
I searched around for this for awhile, so forgive me if there is an answer already. I am having trouble applying borders to merged cells using CFSpreadsheet. Below is some example code.
newSS = SpreadsheetNew('Testing'); //Create…
vivasuzi
- 75
- 7
