Solved

Write and read from Excel

Posted on 2009-07-08
4
352 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
Comment Utility
Try with ExecRemote() function.

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

Author Comment

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

Author Comment

by:Deyhim
Comment Utility
can i do some things using OLE??
0
 
LVL 14

Accepted Solution

by:
shru_0409 earned 500 total points
Comment Utility
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

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: …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
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.

762 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

6 Experts available now in Live!

Get 1:1 Help Now