Hello


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

Any help truly appreciated

Martin

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):

----
Vars:WorkbookName("Test.xls");
Vars:WorksheetName("Sheet1");
Vars:Initialized(false);
Vars:boolXLStarted(false);
Vars:boolWorksheetReady(false);
Vars:boolGetRtn(false);
Vars:boolSetRtn(false);
Vars:var1(0);
Vars:var2(0);
Vars:var3("");
Vars:var4("");
　
　
// Initialization
Once(CurrentBar=1)begin
ifInitialized=falsethen
begin
XLStarted = ELXL_Initialize ;
WorksheetReady=ELXL_WithSheet(WorkbookName,WorksheetName);

ifXLStartedandWorksheetReadythenInitialized=true;
end;
ifInitialized=falsethenraiseruntimeerror("Excel Initialization Failure");
end;
// Main Program
iflastbaronchart_sandbarstatus(1)=2thenbegin
GetRtn=ELXL_GetcellNumberRC(2,1,var1);// Second Row Column 1
SetRtn=ELXL_SetCellNumberRC(2,2,var1);// Second Row Column 2

GetRtn=ELXL_GetCellStringRC(3,1,var3);
SetRtn=ELXL_SetCellStringRC(3,2,var3);
end;
-------

Thanks EJTrader I will look around that.

Martin