Stack Overflow
Stack Overflow

Questions tagged [cfspreadsheet]

111 questions
3
votes
2 answers

How to get cfspreadsheet to render html

I'm trying to create an excel file with cfspreadsheet. In one of the columns I have html code, but for some reason, in the excel file the html doesn't get rendered it's just plain text. eg. blabla instead of being bolded. Do you know any…
Stir Zoltán
  • 4,033
  • 3
  • 16
  • 14
2
votes
4 answers

comma in array element breaks spreadsheet

When adding data to an array, one of the elements has commas in its value. An example of the value is "Trim marks at 103, 96, and 90". Using the following code to add the array elements to the spreadsheet object, the partdescription element, as…
aparker81
  • 263
  • 1
  • 5
  • 23
2
votes
1 answer

Reading column format with cfspreadsheet

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 table. Thus far I just format everything as varchars,…
Rumpleteaser
  • 4,142
  • 6
  • 39
  • 52
2
votes
2 answers

cfspreadsheet fails to read empty rows

Given a spreadsheet with N logical rows Where one row is totally blank* cfspreadsheet action="read" will return a query with a RecordCount of N - 1. *A totally blank row is a row where every cell is actually blank. See CELL_TYPE_BLANK in the POI…
Jared Beck
  • 16,796
  • 9
  • 72
  • 97
2
votes
3 answers

Cold Fusion 2018: how to save .xlsx file as .csv

CF2018 on Win2019 Trying to save user-uploaded .xlsx file as .csv file to be processed into Oracle database. Running this code, which completes without errors, but the result is not legible:
epipko
  • 473
  • 5
  • 18
2
votes
1 answer

Can cfspreadsheet output null values from a query without changing them to blanks?

I'm running a SQL query to grab some data. Then using CF's spreadsheet functions to export it as an Excel file. The problem is that cells in the query that are null are getting a non-null character in them. They LOOK blank when you open the…
Tim Gill
  • 55
  • 7
2
votes
2 answers

How to fix Number stored as text in cfspreadsheet

I'm making a excel cell format in cfspreadsheet (Coldfusion 10) as a number but when it convert to excel it show warning at cell which is Number Stored as Text. Can I know how to fix this? Because I need the format as a number.Here is my…
SySyBy
  • 827
  • 1
  • 7
  • 11
2
votes
2 answers

How to make top align in cfspreadsheet after merge cell using ColdFusion 10

I'm making a cell top align, after a merge cell by using spreadsheet functions. What I found on google and CFML Reference Adobe ColdFusion 10 was only left (default), right, center, justify, general, fill, and center_selection. Is there any other…
SySyBy
  • 827
  • 1
  • 7
  • 11
2
votes
0 answers

Column Formatting cfspreadsheet

I am using cfspreadheet in ColdFusion 10. I am aligning my 5th column to the right. Columns 1 through 44 align right then 44 through 73 start aligning left again. Is this typical when trying to format a spreadsheet?
David Brierton
  • 6,977
  • 12
  • 47
  • 104
2
votes
2 answers

How to show full number in Excel sheet?

I'm exporting a query to an Excel file using cfspeadsheet. It's working and creating the Excel sheet. However, the problem is that one of the columns, ie card_number, contains a 15 digit number, which is displayed like this: 4.5421E+15. Is there a…
anatp_123
  • 1,165
  • 2
  • 10
  • 25
2
votes
1 answer

SpreadSheetAddImage - Add image with set width and height

I'm using SpreadSheetAddImage in ColdFusion 10 to add an image to the header are of my spreadsheet. The problem I'm running in to is the function takes an anchor position for example if I want to run the image from cell 1 row 1 to cell 5 row 5 I…
Phil
  • 4,029
  • 9
  • 62
  • 107
2
votes
1 answer

Getting leading zero displayed without quotes

I want to remove single but when I remove it, then leading zero is not displayed. I want leading zero to be displayed but without quotes. My column data type is varchar : SELECT…
Umair Khan
  • 283
  • 3
  • 13
2
votes
0 answers

cfspreadsheet is reading empty string when columns are specified

I have tried to read an xlsx file with the usage of cfspreadsheet and dump it on the webpage. Code:
De De De De
  • 326
  • 3
  • 10
  • 31
2
votes
2 answers

How to add particular columns of a query to spreadsheet object in Coldfusion

I have a query object which contains 5 columns, but I only need to add 4 columns to the spreadsheet. When I am using it is adding all the columns to the spreadsheet. I cannot remove the 5th column…
user3427540
  • 1,162
  • 1
  • 14
  • 30
2
votes
5 answers

How to read columns with spaces from coldfusion queries?

I am reading data from a spreadsheet. One of the column in the spreadsheet contains spaces. For Example, Columns names are [first name,last name,roll]. I am getting a qryObj after reading the spreadsheet. Now when i am trying to read first name from…
Deepak Kumar Padhy
  • 4,128
  • 6
  • 43
  • 79
1 2
3
4 5 6 7 8