Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1255
  • Last Modified:

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!"
  • 2
1 Solution
I found this :


not sure if that helps you out any :)

Other then that take a look on www.pscode.com  :)
wdc2222Author Commented:
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.
Thats fine, he solved it himself so :) Need I say more :)
Closed, 500 points refunded.
Community Support Moderator (Graveyard shift)

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now