I'm seeking information to start using EleXcel to interface Multicharts with Excel.
Anyone is using it?
I want to test these function but no luck yet. I,m just turning around...
- Start Excel sheet
- Read a double value from a cell
- Write a double value to a cell
- Read a string from a cell
- Write a string to a cell
Martin - I have used this in the past. If I recall - you can't really open the spreadsheet directly but it can read/write to an already open spreadsheet. I would try to find an example code to perform couple of these operations ( have to dig through and also need to make sure they work.
This is a sample code ( compiles fine but haven't tested it completely):
XLStarted = ELXL_Initialize ;
ifInitialized=falsethenraiseruntimeerror("Excel Initialization Failure"); end;
// Main Program
GetRtn=ELXL_GetcellNumberRC(2,1,var1);// Second Row Column 1
SetRtn=ELXL_SetCellNumberRC(2,2,var1);// Second Row Column 2