• 1 reply
  • Latest Post - ‏2012-12-28T20:51:52Z by SystemAdmin
1883 Posts

Pinned topic variable range in SheetWrite

‏2012-12-28T13:28:15Z |
Hi all,

I have a problem where solution array (2D) has variable width. I'm using sheetwrite to work with the solution, but i've found that apparently it doesn't support using a string variable to specify the array lenght. Here is an example of what i want to do:

Result = {"anything"};

SheetConnection sheet2("Solution.xlsx");
Qproduct to SheetWrite(sheet2,Result);

Is there anyway that Aheetwrite accepts array dimensio parameter (in this case Result) as a string variable instead of a fixed array or named excel array?

Many thanks for your help!
Updated on 2012-12-28T20:51:52Z at 2012-12-28T20:51:52Z by SystemAdmin
  • SystemAdmin
    1883 Posts

    Re: variable range in SheetWrite

    In your sample, Result is not a string but a set of string elements.
    Did you try with
    Result = "anything";

    If you're working with sets, then you need to refer to a specific element of the set, for example

    Hope this helps
    Updated on 2014-03-26T05:51:34Z at 2014-03-26T05:51:34Z by iron-man