Solved

How to write to an Excel file on the server

Posted on 2003-11-18
4
1,304 Views
Last Modified: 2013-12-24
I can use CFCONTENT to write data to an Excel server. I can create an datasource and query an Excel table. But how can I insert data into an Excel file on the server?
0
Comment
Question by:kjuliff
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
cheekycj earned 250 total points
ID: 9773723
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9776326
well if u can read thru excel sheet - then i guesss the same DSN shld help u to write to the excel file as well.

If ur using CFMX 6.1 - then in ur CFADMIN - under ur datasources - u'll see a option "advanced settings" - in that u have checkboxes for insert / update etc for the excel DSN. chk the ones u need & u shld be able to insert/update ur excel sheet on the server.

also u'll have another checkbox there "maintain connection" - make sure this is UNCHECKED !

ur insert query to the excel sheet will be as similar as the one to any DB Table ...

HTH

K'Rgds
Anand
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9776327
well if u can read thru excel sheet - then i guesss the same DSN shld help u to write to the excel file as well.

If ur using CFMX 6.1 - then in ur CFADMIN - under ur datasources - u'll see a option "advanced settings" - in that u have checkboxes for insert / update etc for the excel DSN. chk the ones u need & u shld be able to insert/update ur excel sheet on the server.

also u'll have another checkbox there "maintain connection" - make sure this is UNCHECKED !

ur insert query to the excel sheet will be as similar as the one to any DB Table ...

HTH

K'Rgds
Anand
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 9782393
A "C", if you didn't like my comment you shouldn't accept it as an answer.

It was just for reference.

CJ
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question