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 spr...

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 th...

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" sh...

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...

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 create...

What is the equivalent of this... <cfspreadsheet action="read" src="#form.uploadedFile#" query="mycontent" > in cfscript? cfscript has spreadSheetRead(fileName) - but the result is an o...

Edit at the end Can anyone see what I am doing wrong? These are my expectations and observations: I expect a worksheet named Search Parameters to have cell a1 in bold red font. I get what I expec...

I'm using a cfspreadsheet read to read a sheet into a query object. <cfspreadsheet action="read" src="TestExcel.xls" sheet="1" query="spreadsheetData" headerrow="1" excludeHeaderRow="true"> ...

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...

Is it possible to get the datatype or format of a column or cell in a spreadsheet when you read it using cfspreadsheet? I am converting spreadsheet data from an excel spreadsheet to a database tab...