Questions tagged [cfspreadsheet]
111 questions
0
votes
0 answers
cfspreadsheet update cell directly
Can cfspreadsheet (or anything else using cold fusion) be used to update just a few cells in an existing xlsx spreadsheet?
I have updated entire sheets in the past - using an object - but the sheet in question is so massive and messy - I only want…
Torsten
- 29
- 3
0
votes
1 answer
cfspreadsheet making first item in row bold
I have a rowlist using cfspreadsheet in ColdFusion10.
I am trying to…
David Brierton
- 6,977
- 12
- 47
- 104
0
votes
0 answers
CFspreadsheet adding a % to format a column
I am using CF10 and trying to add a % sign to a spreadsheet.
I am having an issue with adding a % sign on my 5th column entries. (Only the entries starting the second row (not the header) and not the blank cells when the query is done running.…
David Brierton
- 6,977
- 12
- 47
- 104
0
votes
1 answer
How to read populated columns only with CFSpreadsheet
I am trying to use to read data from a spreadsheet and insert that data into a database table. Let's say my table has 10 possible columns: FName,LName,MName, Address1,Address2,Address3,city,state,zip and email. Users will be able to…
user3779216
- 75
- 1
- 8
0
votes
1 answer
cfspreadsheet causing variable undefined error
I'm attempting to read a spreadsheet that has predefined charts on multiple tabs using cfspreadsheet, but when it comes to processing the data, I get variable is undefined.
I've used the example from Adobe -…
J Vaden
- 1
- 1
0
votes
1 answer
POIUtility.cfc - Cannot read excel files: "Object instantiation exception"
I am using Ben Nadel's POIUtility.cfm to read and write to Excel files. There are some files which I can read very easily using the given code/file. But for some other files, I keep getting an instantiation error. I cannot figure out what's going…
Rahul Kumar
- 46
- 3
0
votes
1 answer
ColdFusion - POI Excel Workbook Format as Number
I'm creating an Excel file using ColdFusion and POI Workbook. The file is created great, however I have cells that contain numeric values and need to be stored as numbers for SUM and other functions to work properly.
I want to call code after the…
Phil
- 4,029
- 9
- 62
- 107
0
votes
1 answer
cfspreadsheet write to xlsx truncates some data
I can't figure out what's going on. I'm exporting data from our Oracle 12c db to Excel from a simple select query, using cfspreadsheet:
cmadsen
- 1
- 1
0
votes
2 answers
CFSpreadsheet Formatting Assistance
I have a spreadsheet query bringing back results. Negative numbers are formatted as ([$$123.12]) and positive numbers are formatted as ("$$123.12").
I need to format the negative number as -123.12 and the positive number as 123.12 before being…
John Eubanks
- 61
- 6
0
votes
1 answer
Using Spreadsheet in Query of Queries
I am reading a spreadsheet any trying to then run it in a query or Queries
James A Mohler
- 11,060
- 15
- 46
- 72
0
votes
1 answer
CFSpreadsheet formatting fails when using documented approach
If I try to format a cell with
columnFormat = {
integer = { alignment = "center", dataformat = '#,##0'},
...
In Adobe's documentation is…
James A Mohler
- 11,060
- 15
- 46
- 72
0
votes
3 answers
CFspreadsheet looping
I have a question regarding cfspreadsheet....So I'm using cfspreadshseet to create excel spreadsheets for reporting purposes. My page allows a user to select whatever columns from the database to include in the report. So here is an example:
The…
Artisdesigns
- 13
- 1
0
votes
2 answers
CFloop Processing Extremely slow
I am teaching myself CF Development and am using a shared CF Hosted Site for testing as I learn.
I have a spreadsheet containing 2500 plus records of data, in about 15 columns. The spreadsheet contains data critical to the basis of this application.…
Ken Mais
- 31
- 2
0
votes
1 answer
ColdFusion cfspreadsheet: error occurred while reading the Excel. The supplied POIFSFileSystem does not contain a BIFF8 'Workbook' entry
In ColdFusion 10 Spreadsheet:
I have a daily routine that reads a few Excel files and stores them in a database. I have recently started receiving a file with some macros. The service cannot read the file. If I open and save the file then it will…
user2962491
- 1
- 1
0
votes
2 answers
How to query through an excel document column using cfspreadsheet in ColdFusion?
I need to do some validation on an excel spreadsheet before I upload to database.
How do I query through an excel document column using cfspreadsheet in ColdFusion?
I need to verify that specific columns don't have any null values in any of their…
ConfusedDeer
- 3,335
- 8
- 44
- 72