asked on

How to write and read from formula one spread sheet using Borland C++ Builder?

I want to put a formula one spread sheet in my program, and send data to cells from a var, and read from cells. The example that comes with it seems to be for delphi. I'm using C++ Builder 5. If there are other addins I can use, for which you know how to this please feel free to post as well, with a link to the addin.

---------------------------------------------- The example --------------------------------------------------------------
F1Book1.Col = 5
The following example shows the code required to read an Excel worksheet from disk using the Read method:
F1Book1.Read = "c:\excel\examples\amortize.xls"
The following example uses the Row, Col, Number, Formula, and Text properties to enter data in a worksheet. Numbers, 1 and 2, are entered in A1 and A2. A formula, SIN(A1) + COS(A2), is entered in A3. A text string is entered in B4.
F1Book1.Row = 1
F1Book1.Col = 1
F1Book1.Number = 1
F1Book1.Row = 2
F1Book1.Number = 2
F1Book1.Row = 3
F1Book1.Formula = "sin(A1) + cos(A2)"
F1Book1.Row = 4
F1Book1.Col = 2
F1Book1.Text = "The End!"

Shane Russell

I found this :

http://cellsheet.sourceforge.net/

not sure if that helps you out any :)

Other then that take a look on www.pscode.com :)

wdc2222

ASKER

It was quite simple

F1Book1->Col = 1;
F1Book1->Row = 1;
F1Book1->Number = 300;

stumbled on it when I typed row in help index, then there were exemples for stringgrids.

Shane Russell

Thats fine, he solved it himself so :) Need I say more :)

ASKER CERTIFIED SOLUTION

OzzMod

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial