Stack Overflow
Stack Overflow

Questions tagged [cfspreadsheet]

111 questions
2
votes
1 answer

cfspreadsheet and modifing tab contents, getting tab exists on update

I am attempting to read a 'named tab' of a spreadsheet into a table, update the values, then save them back to the same tab I am trying to see if its just me or something odd in the spreadsheet functions, pseudo code follows. ( I don't think I am…
user3005033
  • 131
  • 6
2
votes
1 answer

coldfusion 10 cfspreadsheet get meta data from columns

we are currently using cfspreadsheet to process excel spreadsheets that are being imported into our app. At present we dont have an easy way of validating the data types that are imported from the data as we are trying to work with a QoQ object…
user125264
  • 1,809
  • 2
  • 27
  • 54
2
votes
2 answers

Applying conditional formatting with CFSpreadsheet

In continuation of a previous thread, I've reached pretty close to where I want and have learned a lot. I'm under CF10 on a MSSQL Server 2008 environment. I have a report I'm generating using cfspreadsheet and then spitting out values based on…
bman2013
  • 387
  • 1
  • 4
  • 13
2
votes
1 answer

SpreadsheetFormatColumn() Right Border

When I run this code: flinstones = "fred,wilma,pebbles"; Workbook = Spreadsheetnew("Workbook"); for (i = 1; i lte listlen(flinstones); i ++) { ThisFlinstone = ListGetAt(Flinstones, i); if (ThisFlinstone ==…
Dan Bracuk
  • 20,699
  • 4
  • 26
  • 43
2
votes
1 answer

Spreadsheet Cell Formatting

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 expect. I expect a worksheet named "4D,CCCU,SDAU" which…
Dan Bracuk
  • 20,699
  • 4
  • 26
  • 43
2
votes
2 answers

Comma is invalid when using dataformat

Here is my code to output a query to a spreadsheet. //Use an absolute path for the files. ---> theDir=GetDirectoryFromPath(GetCurrentTemplatePath()); theFile=theDir & "getTestInv.xls"; //Create an empty ColdFusion spreadsheet…
Alias
  • 415
  • 1
  • 6
  • 20
2
votes
1 answer

CFSpreadsheet loses SpreadSheetAddFreezePane when updating

I am trying to add spreadsheets to a workbook with a freeze pane. The freeze pane will work if the action is write but not if I add another sheet using update. theSheet = SpreadsheetNew(SheetName);…
Rob Geissler
  • 41
  • 1
1
vote
1 answer

Coldfusion - Memory efficient xlsx/excel generation

I am trying to build a excel xlsx workbook using Coldfusion. I am use the various spreadsheetXYZ functions to do so. A problem I have come across is that some of the exports I am running have lots of data, and so it seems memory becomes of concern.…
Duncan Palmer
  • 2,865
  • 11
  • 63
  • 91
1
vote
0 answers

Coldfusion- read large excel(xlsx) files using cfspreadsheet

I have a large .xlsx file (20mb) I need to read the data and create tab separated files. I am having problems with loading this file (OutOfMemoryError) and java heap error by using cfspreadsheet Update ColdFusion 10 Java 7
brahmam
  • 11
  • 3
1
vote
2 answers

output database data using cfscript

I'm not familiar with cfscript having used tags for ever so not sure how to output a database query. Normally #field1#
#field2#

 How do I do that in cfscript? Updated as per the comment below and…
Paul Hopkinson
  • 431
  • 1
  • 6
  • 14
1
vote
2 answers

can I use cfspreadsheet to update data within in an already existing template without losing styles in it?

can I use cfspreadsheet to update/add some data within in an already existing template without losing styles in it? I got a template with some column headers and tabular styling in it with some colors n all, so can I process that file and update…
A DEv
  • 255
  • 1
  • 19
1
vote
0 answers

CFSpreadsheet not formatting dates

I think I have read just about every post on this topic and none of the proposed solutions works in my case so here goes. I am using CF9 (upgrade not an option) for this project. I query a date field from a MSSQL database and use…
Jay2001
  • 59
  • 7
1
vote
1 answer

How to loop through cfspreadsheet headers?

I have an excel file that I am trying to read and then display the values of the headers in a drop down. The first row in my excel file has all of the values (header names). I used the code below, but what happens is that all the header names appear…
Gosi
  • 2,004
  • 3
  • 24
  • 36
1
vote
1 answer

How to create tab delimited text file from cfquery?

I have created query using cfspreadsheet. Now I'm wondering if it's possible to convert query to tab delimited text file. This is my code to get the query:
espresso_coffee
  • 5,980
  • 11
  • 83
  • 193
1
vote
1 answer

How to keep CF spreadsheet population from hanging?

I'm running into a snag as I populate the rows of a cf spreadsheet object and create an xls file. On my dev server, the entire process takes only about a minute, but on my prod server, the page starts hanging indefinitely inside the very first…
Cmaso
  • 1,095
  • 1
  • 10
  • 23
1 2 3
4
5 6 7 8