| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| hi, just want some advice on how should i do this thing... i have an excel template with this format http://2.bp.blogspot.com/_Bm41qk00ot...2PW-5JI/s1600- h/excel_x.bmp sheet name : studentlist row header 1 : no row header 2 : studentno row header 3 : name i have a query like this <cfquery name="studentlist" datasources="mydb"> select studentno, name from student </cfquery> my task is, i want to output the studentlist recordset to the excel template in that StudentList worksheet and write to that excel starting from row number 6. how do i do that? using cffile and append? i have try it and successfully if using new workbook and new sheet not updating an excel and predefined sheet. thanks for the suggestion guys... haire <img src="http://2.bp.blogspot.com/_Bm41qk00otI/SLYA5Md5j7I/AAAAAAAAAB8/GK0Y2PW-5JI/s 1600-h/excel_x.bmp" > |
![]() |
| Thread Tools | |
| Display Modes | |
In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.