1
Vote

the size of characters passed to OPERX

description

Argument in OPERX can't have more than 255 characters.

Say for instance,
xstring data="{1,2,3;4,5,6;,7,8,9;10,... 255;256,257,258}";
ExcelX(xlfEvaluate, OPERX(&data[0].c_str()));
will stop due to the condition check in traits.h below
size_t n = ::strlen(s);
ensure (n <= limits<XLOPER>::maxchars);
I want to pass a huge table data and output to excel. Is there a fix on the maximum size issue?

comments

keithalewis wrote Nov 4, 2014 at 4:01 PM

define EXCEL12 to use wide character strings.