Getting Excel Data

[vt2009]

I have an automated Tradestation strategy that needs to get data for each symbol from a spreadsheet I made. I have had problems using ElXL function that is built by Tradestation. I keep getting the error: Workshheet name should not contain extended path information.

The problem is that I dont have the extended path information in the code to begin with so I dont understand this error.


Here is my simple excel code based on the demo:



inputs:
string WorkbookName("FuturesBigList.xls"),
string WorksheetName("FeatureList");
var:bool WorksheetReady(false);
var:bool XLStarted(false);

XLStarted=ELXL_Initialize;
If XLStarted then
begin
WorksheetReady=ELXL_WithSheet(WorkbookName,WorkSheetName);

vars: string Instrument(GetSymbolName);
vars: string ExcelSymbol("");
vars: int GetSheet(1);
vars: int getrow(2);
vars: int getcolum(1);
vars: int RowCounter(2);
Vars:Margin$(1);
vars:double oNumvar(0);
Vars:string oStringVal("");
vars:bool getrtn(false);

If WorksheetReady then begin

For GetRow =2 to 100 begin
RowCounter=getrow;
getrtn= ELXL_GetCellStringRC(Getrow,1,oStringVal);
ExcelSymbol= oStringVal;
print("ExcelSymbol", Excelsymbol);
If ExcelSymbol=Instrument then begin
getrtn= ElXL_GetCellNumberRC(Getrow,12,oNumvar);
Margin$=oNumvar;
print("GetRow",Getrow);
print("margin$",margin$);
end;
end;
end;
end;

 

[ManiGandan]

Hi vt2009,

I got the same error, But I tried in xlsx and it worked for me. Try it out with xlsx.(Excel 2007).

Cheers..
MGN.