Solved

Write and read from Excel

Posted on 2009-07-08
4
354 Views
Last Modified: 2013-12-26
want to read and Write from Excel using powerbuilder.
I have Excel Template with fix field name (for example empl_name) and i want to use same template and put employee name into excel field name empl_name then save it separately ..

the result will be many excel sheet with same template (header,  footer ..etc) with different into field name empl_name?

and also how to read from excel using cell name??
For example: users can change name into excel sheet then run program to update the name into Database...


I hope its clear !
0
Comment
Question by:Deyhim
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:shru_0409
ID: 24801683
Try with ExecRemote() function.

Please read in Help about this function, may this hlep u
0
 
LVL 1

Author Comment

by:Deyhim
ID: 24801956
this is only for active sheet??
OpenChannel ( applname, topicname {, windowhandle } )
0
 
LVL 1

Author Comment

by:Deyhim
ID: 24802003
can i do some things using OLE??
0
 
LVL 14

Accepted Solution

by:
shru_0409 earned 500 total points
ID: 24802054
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now