kjuliff
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
A "C", if you didn't like my comment you shouldn't accept it as an answer.
It was just for reference.
CJ
It was just for reference.
CJ
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