Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronic Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

Register Log in

Delphi/Builder using Excel server components

Status
Not open for further replies.

btbass

Advanced Member level 5
Joined
Jul 20, 2001
Messages
1,897
Helped
438
Reputation
880
Reaction score
287
Trophy points
1,363
Location
Oberon
Activity points
12,861
I am trying to use the Excel server components that come with Delphi/Builder. Has anybody used these?
I can start up Excel and get the active sheet, how do I detect when some one enters data in Excel, what value they entered and in what cell.
Any help would be appreciated.
:?:
 

diegolinder

Member level 3
Joined
Jun 3, 2002
Messages
54
Helped
3
Reputation
6
Reaction score
2
Trophy points
1,288
Location
Argentina
Activity points
376
I don't know excel component, i use TStringGrid is this component correct.
 

btbass

Advanced Member level 5
Joined
Jul 20, 2001
Messages
1,897
Helped
438
Reputation
880
Reaction score
287
Trophy points
1,363
Location
Oberon
Activity points
12,861
If you have the pro or enterprise version of Delphi or Builder, there is a component tab called servers which has a lot of servers for automating Micro$oft office. I am trying to use the excel servers to talk to Excel.
There is no help on using these components, allthough if you have code completion on, you get a list of functions.
Was hoping someone had done it and could post some sample code to read and write the active cell?
 

bobcat1

Advanced Member level 4
Joined
Jul 10, 2002
Messages
1,288
Helped
99
Reputation
198
Reaction score
34
Trophy points
1,328
Activity points
8,547
Hi I have used the WORD components

Hi I have used the WORD components to create some automted documents.

If you know how to write macro's it's makes the job easy.


I can upload some demo for msword i think the method is the same


bobi
 

Analyzer

Full Member level 6
Joined
Nov 18, 2001
Messages
374
Helped
3
Reputation
6
Reaction score
3
Trophy points
1,298
Activity points
3,518
I am using bcb 4.0 ent. and i am using 3rd party component to access office programs.I am not sure but you can not detect if user enters values to form and sheets.(You should hook up keyboard, active program.. blah blah blah) If you tell us what you'll do, maybe i can advice you different way ;)
 

btbass

Advanced Member level 5
Joined
Jul 20, 2001
Messages
1,897
Helped
438
Reputation
880
Reaction score
287
Trophy points
1,363
Location
Oberon
Activity points
12,861
What I am trying to do is a user enters a job ref number in Excel, the worksheet server component does have an OnChange event, so I can detect that. Then my program looks up the job ref number in a database and fills in some cells with the Company name, position, pay rate etc.
This thing could most probably be all done in Excel using the Visual basic tool. I use Delphi and Builder a lot, so feel comfortable using them, not to hot in VB. And of course, time is a problem.
:?
 

Status
Not open for further replies.
Toggle Sidebar

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Top