coba pakai cara ini mas
//---------------------------------------
lole_OLE = CREATE OleObject
result = lole_OLE.ConnectToNewObject( "excel.application" )
lole_OLE.Workbooks.open("C:\test.xls") // perumpamaan
lole_sheet = lole_OLE.Application.ActiveWorkbook.WorkSheets[1] // kalo lebih
dari satu worksheet bisa di looping dengan [2] ..[3]....dst
dw_1.object.a[1] = string(lole_Sheet.cells(1, 2).value)
DESTROY lole_OLE
destroy lole_sheet
//---------------------------------------------------
ctt : kalo di excel row yg mau diupload more than 1 di looping aja...
ini contoh sederhana nya..mungkin bisa dikembangkan dari sini..
semoga bermanfaat..
rgds,-
-rio-
----- Original Message -----
From: "Awa Gartiwa" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, April 10, 2007 6:44 PM
Subject: [indopb] Upload Data Exel
>
> Help me donk,..
>
> aku mau upload data dari excel ke database lewat aplikasi,..
> bagaimana ya,...
>
>
> kalau download dw_1.SaveAs()
>
> Kalau Upload ....................... ? mau diupload ke dw_1
> Thx,
> Awa
>
> _________________________________________________________________
> Can't afford to quit your job? - Earn your AS, BS, or MS degree online in
> 1
> year.
> http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143
>
>
>
> -----------------------------------------------
> IndoPB - Indonesia PB User Group
> An Indonesian PowerBuilder User Group's Event
> 2nd PowerBuilder Update
> Rumah Sakit Jantung Harapan Kita
> 26/27 August 2006
> To Register :
> http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> Disclaimer: Although this message has been checked for all known viruses
> using Trend Micro InterScan Messaging Security Suite, Bukopin
> accept no liability for any loss or damage arising
> from the use of this E-Mail or attachments.
>
Disclaimer: Although this message has been checked for all known viruses
using Trend Micro InterScan Messaging Security Suite, Bukopin
accept no liability for any loss or damage arising
from the use of this E-Mail or attachments.
-----------------------------------------------
IndoPB - Indonesia PB User Group
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register :
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indopb/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indopb/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
