simpan ke dbf aja. dbf juga bisa dibuka pake excel. lebar kolomnya akan disamakan dgn panjang kolom di db.
yazid <[EMAIL PROTECTED]> wrote: Ada masalah ketika save ke excel, yaitu ketika kolom di dw isinya 00000000 yg berupa string, tapi ketangkep di excelnya jadi 0 (karena dianggap angka-general) Ada yg punya ide, gimana biar diexcelnya 00000 juga ? Thanks --- In [email protected], [EMAIL PROTECTED] wrote: > > Kalau mau coba cara selain saveas(), coba pakai function saveasascii() yg > akan menyimpan datawindow dlm format ASCII/text dan bisa dibuka dg excel > jg. > > Regards, > > Nurhamid Abdulbasith > PT Avon Indonesia > > > > > "yazid" <[EMAIL PROTECTED]> > Sent by: [email protected] > 21/12/2005 10:38 AM > Please respond to indopb > > To: [email protected] > cc: > Subject: [indopb] Re: save dw preview to excell - not dw > (solved) > > > Thanks Mas Nurhamid > > ==================== > string docname, named > integer value > > value = GetFileSaveName("Select File", & > docname, named, "DOC", & > "Excel Files (*.xls),*.HTM," + & > " All Files (*.*), *.*") > > docname = left(docname, len(trim(docname)) - 4 ) > > IF value = 1 THEN > dw_1.Saveas(docname + '.xls', HTMLTable!, True) > END IF > =============== > > Sedikit modifikasi supaya namanya bukan test.htm.xls > > Yazid > Axiasolusi > > --- In [email protected], [EMAIL PROTECTED] wrote: > > > > Mas Yazid, > > Coba pakai function : GetFileSaveName(), function ini akan membuka > window > > dialog dimana user bisa pilih folder dan nama filenya. > > Contoh : > > > > string docname, named > > integer value > > > > value = GetFileSaveName("Select File", & > > docname, named, "DOC", & > > "HTML Files (*.HTM),*.HTM," + & > > " All Files (*.*), *.*") > > > > IF value = 1 THEN //bila user klik OK button > > dw_1.Saveas(docname, HTMLTable!, True) > > END IF > > > > Regards, > > > > Nurhamid Abdulbasith > > PT Avon Indonesia > > > > > > > > > > > > "yazid" <[EMAIL PROTECTED]> > > Sent by: [email protected] > > 21/12/2005 09:37 AM > > Please respond to indopb > > > > To: [email protected] > > cc: > > Subject: [indopb] Re: save dw preview to excell - not > dw > > > > > > Thanks to Erwansyah > > > > Ada pertanyaan lagi, kalo saya pake fungsi saveas dibawah > > =========== > > dw_1.SaveAs('test.xls', HTMLTable!, True) > > =========== > > maka file test.xls nya : > > 1. akan ditaruh di folder yg sama dgn db > > 2. nama file xls statis > > > > Gimana caranya supaya, > > 1. folder bisa milih, (browse) > > 2. nama bisa dinamis (user bisa namain sesukanya) > > > > Saya coba pake > > ========= > > dw_1.SaveAs('', HTMLTable!, True) > > ========= > > > > Tapi di save dialognya, format savenya HTML, dan utk namanya perlu > > ditambah .xls > > > > Kalo utk operator atau user (format HTML dan .xls) agak > membingungkan > > & sedikit gak biasa. > > Ada ide, supaya folder & nama bisa dinamis tapi gak membingunkan > user? > > > > Thanks > > > > > > > > > > --- In [email protected], Erwam Suaj <[EMAIL PROTECTED]> > wrote: > > > > > > saveastype pake htmltable ... filenya manipulasi ke > > > xls aja beres > > > > > > contoh : dwcontrol.saveas('test.xls', htmltable!,true) > > > > > > > > > Coba deh and buktikan sendiri > > > > > > Erwansyah > > > > > > > > > --- yazid <[EMAIL PROTECTED]> wrote: > > > > > > > Need clue .... > > > > > > > > Perintah dibawah ini digunakan utk menyimpan data2 > > > > dari datawindow ke > > > > file excell atau lainnya. > > > > =============== > > > > dwcontrol.SaveAs ( { filename, saveastype, > > > > colheading } ) > > > > =============== > > > > > > > > Yg saya belum tau, gimana caranya menyimpan data2 > > > > setelah dw di > > > > preview, krn jika menggunakan perintah > > > > dwcontrol.saveas() diatas, > > > > kolom2 COMPUTE tidak akan tersimpan ke file excell > > > > dan kolom2 yg tidak > > > > ditampilkan dipreview akan ke simpan di file excell. > > > > > > > > Thanks > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor > > > > --------------------~--> > > > > Get Bzzzy! (real tools to help you find a job). > > > > Welcome to the Sweet Life. > > > > > > > http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/NhFolB/TM > > > > > > > ---------------------------------------------------------------- -- > -- > > ~-> > > > > > > > > > > > > ----------------------------------------------- > > > > Reuni SMA Negeri 1 Angkatan 1988 > > > > Hari/ Tanggal : Minggu, 18 Desember 2005 > > > > Pukul : 09.00 ââ¬" 12.00 WIB > > > > Lokasi : SMA Negeri 1 Jl. Ir H. Juanda Bandung > > > > Info lanjut hub.: Udjo 0811140603, Ilo 021 ââ¬" > > > > 70682007, Ratih 08122129539, Alland 0818202247, > > > > Happy 08161815734 > > > > ----------------------------------------------- > > > > IndoPB - Indonesia PB User Group > > > > To Post a message, send it to: [EMAIL PROTECTED] > > > > To Unsubscribe,send a blank message to: > > > > [EMAIL PROTECTED] > > > > Yahoo! Groups Links > > > > > > > > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Tired of spam? Yahoo! Mail has the best spam protection around > > > http://mail.yahoo.com > > > > > > > > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor ------------------- - > ~--> > > Most low income homes are not online. Make a difference this holiday > > season! > > http://us.click.yahoo.com/5UeCyC/BWHMAA/TtwFAA/NhFolB/TM > > ------------------------------------------------------------------ -- > ~-> > > > > ----------------------------------------------- > > Reuni SMA Negeri 1 Angkatan 1988 > > Hari/ Tanggal : Minggu, 18 Desember 2005 > > Pukul : 09.00 ââ¬" 12.00 WIB > > Lokasi : SMA Negeri 1 Jl. Ir H. Juanda Bandung > > Info lanjut hub.: Udjo 0811140603, Ilo 021 ââ¬" 70682007, Ratih > 08122129539, > > Alland 0818202247, Happy 08161815734 > > ----------------------------------------------- > > IndoPB - Indonesia PB User Group > > To Post a message, send it to: [EMAIL PROTECTED] > > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > ------------------------ Yahoo! Groups Sponsor -------------------- ~--> > Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. > http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/NhFolB/TM > -------------------------------------------------------------------- ~-> > > ----------------------------------------------- > Reuni SMA Negeri 1 Angkatan 1988 > Hari/ Tanggal : Minggu, 18 Desember 2005 > Pukul : 09.00 â" 12.00 WIB > Lokasi : SMA Negeri 1 Jl. Ir H. Juanda Bandung > Info lanjut hub.: Udjo 0811140603, Ilo 021 â" 70682007, Ratih 08122129539, > Alland 0818202247, Happy 08161815734 > ----------------------------------------------- > IndoPB - Indonesia PB User Group > To Post a message, send it to: [EMAIL PROTECTED] > To Unsubscribe,send a blank message to: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > > > > > > [Non-text portions of this message have been removed] > ----------------------------------------------- Reuni SMA Negeri 1 Angkatan 1988 Hari/ Tanggal : Minggu, 18 Desember 2005 Pukul : 09.00 12.00 WIB Lokasi : SMA Negeri 1 Jl. Ir H. Juanda Bandung Info lanjut hub.: Udjo 0811140603, Ilo 021 70682007, Ratih 08122129539, Alland 0818202247, Happy 08161815734 ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] --------------------------------- YAHOO! GROUPS LINKS Visit your group "indopb" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Wahyu Kurniawan, A.Md. HP : 08561884559 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
