Read and Write from Excel to Powerbuilder

How i can read and write data into Excel Using power builder?
i used OLE object to read "not write" from Excel but what is the easiest way to read and write?

can i have sample?
how to use pfc?
note I'm using Powerbuilder 10.5


Thanks.
LVL 1
DeyhimAsked:
Who is Participating?
 
diasroshanConnect With a Mentor Commented:
Hi,

Try this,
http://gethelp.devx.com/techtips/pb_pro/10min/10min1298.asp

If u want to keep it simple,
Check PB Help for SaveAs

Cheers,
Rosh
0
 
DeyhimAuthor Commented:
Thanks,

im looking to control Excel sheet not only saveas, i have excel sheet template and i want to pass some data from database to excel and then read from excel to database "using excel cell name" not to save datawindow as excel.

thanks

0
 
diasroshanCommented:
Hi,

guess the above link shud be of help to u.

Cheers,
Rosh
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Treety_PatnaikCommented:
hi,
     if u want to move the datas from excel to datawindow then
     U can use the function dw_1.ImportClipboard ( 0 , 99999 , 1, 25, 1) .
0
 
DeyhimAuthor Commented:
hi,
i want to USE pfc 10.5, i think its the solution,
any guide?
0
 
DeyhimAuthor Commented:
not complete
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.