How to write to an Excel file on the server

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?
LVL 1
kjuliffAsked:
Who is Participating?
 
cheekycjCommented:
0
 
anandkpCommented:
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
 
anandkpCommented:
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
 
cheekycjCommented:
A "C", if you didn't like my comment you shouldn't accept it as an answer.

It was just for reference.

CJ
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.