Stack Overflow
Stack Overflow

Questions tagged [cfspreadsheet]

111 questions
1
vote
0 answers

ColdFusion - POI setCellStyle without affecting it's existing style?

I have a cellStyle created for the Excel file to have row striping. I also want to set any cells with numeric values to RIGHT ALIGN. I can accomplish this by checking the value of the cell, and if numeric I setCellStyle(styleRightAlign) where…
Phil
  • 4,029
  • 9
  • 62
  • 107
1
vote
2 answers

cfspreadsheet save as .csv, Excel says "The file format and extension of FILE.csv don't match."

I've created a cold fusion page to output a client list from MYSQL into a CSV file for easy uploading to SalesForce.com I can generate the file with all the correct information. However, when I try to open it with excel I get the error: "The file…
Matthew Louis
  • 45
  • 2
  • 6
1
vote
1 answer

How do I show multiple tabs using the "read" function for CFSPREADSHEET?

I would like to show multiple tabs, i.e. multiple sheets, from an xls file in the browser using Coldfusion. I have the logic pretty worked out, but I'm not sure if there is a way to do it. My logic would be as…
m4ttr33d
  • 13
  • 2
1
vote
1 answer

CF10 CFSPREADSHEET Column Names - escaping special characters

So apparently I can't use any special characters, not even abbreviate with a dot for setting column names in cfspreadsheet. Is there a way to get around this? I'm basically dumping my query results into an excel file using cfspreadsheet and need to…
bman2013
  • 387
  • 1
  • 4
  • 13
1
vote
3 answers

cfspreadsheet - how to write to excel WITHOUT showing column headers

I'm writing query results to an excel spreadsheet using cfspreadsheet (in ColdFusion). The customer does not want the header rows showing up on the excel sheet. The excludeheaderrow attribute is only for reading. Does anyone know if it's possible…
Kirsten
  • 27
  • 1
  • 13
1
vote
0 answers

Excel Reference Cell value

I am trying to read the values from excel A which has the referenced data from another excel sheet B. Code so far:
Gaurav S
  • 999
  • 8
  • 16
1
vote
0 answers

Issue while reading Spreadsheet from ColdFusion

I am facing an Issue while reading Excel sheet (xls/xlsx) created from Microsoft Office 2013. Here are the…
Sks
  • 612
  • 7
  • 23
1
vote
1 answer

cfspreadsheet cannot add rows to object created using query result

'excelFileQuery' contains a query.
rrk
  • 15,677
  • 4
  • 29
  • 45
1
vote
1 answer

Coldfusion query of queries with row numbers passed to second query

I'm doing the following query of queries. The first dump of the query shows the entire excel sheet, the second dump shows the results of the second query. I'm doing a validation check of the excel sheet to make sure there are no more pit bulls…
ConfusedDeer
  • 3,335
  • 8
  • 44
  • 72
1
vote
2 answers

Query of Queries failing in Coldfusion 10

I'm getting and error when I tried to do a query of query. Table named allData was not found in memory. The name is misspelled or the table is not defined. I have an excel document and I'm outputting to a coldfusion var called allData, then I'm…
ConfusedDeer
  • 3,335
  • 8
  • 44
  • 72
1
vote
2 answers

Error while creating validation dropdown in spreadsheet using ColdFusion

I am just creating a validation dropdown in a spreadsheet, from a database query, using ColdFusion. But I am getting the following error "string literals in formulas can't be bigger then 255 character ASCII" Can any one please help to rectify this…
user3313928
  • 17
  • 6
1
vote
0 answers

Coldfusion Spreadsheet Blank Cells

I'm trying to write a script to upload an excel sheet into a database, but I'm stuck on a small issue. The script needs to be dynamic so that it doesn't need to change to upload a different excel sheet, simply the sheet must follow the same…
Sterling Archer
  • 22,070
  • 18
  • 81
  • 118
1
vote
2 answers

In coldfusion, cfspreadsheet Hidden tabs do not remain hidden

I am trying to hide a tab of a spreadsheet in CF 9, but the tab does not remain hidden. I am working with the hidden data, then saving the worbook using CF functions. I added the following before using spreadsheetsave: sheetIndex = sObj.SHEETNUMBER…
user3005033
  • 131
  • 6
1
vote
1 answer

cfspreadsheet content in cells on multiple lines

We are working with cfspreadsheet and have a data sheet from a client which contains content that spans multiple lines in one particular cell. Some of the content has formatting applied so some content is bold and some other content spans multiple…
user125264
  • 1,809
  • 2
  • 27
  • 54
1
vote
2 answers

CFSpreadsheet Date formatting issue

I'm running ColdFusion 10 locally and running into two issues with a database that was recently converted from Oracle to MSSQL. What I'm trying to do is output data from the database into a spreadsheet using cfspreadsheet. There are 3 columns in a…
bman2013
  • 387
  • 1
  • 4
  • 13
1 2 3 4
5
6 7 8