Similar methods, different parameters

[lamazze]

Hello,

I've shared a ExcelWorksheet (EEPlus) object by calling "engine.SetValue()".
Everything works fine except the Cell property returns an ExcelRange class that has two identical methods (not sure if my vocabulary is right):

• public ExcelRange this[string Address]
• public ExcelRange this[int Row, int Col]

If in Jint, I use "sheet.Cells["A1"].Value, I have the content of the cell.
But if I use "sheet.Cells[1, 1].Value" which should return the same thing, I have the following error message: "1 is undefined"

I'm not sure but I think it has to do with the fact it expects a string and stop there ?

Thank you
lamazze

[lahma]

Two-dimensional indexers probably just aren't supported, Jint understands the basic indexer.

[lamazze]

Thank you lahma. Do you reckon it's worth doing a feature request ?

[lahma]

I'd suggest creating a PR instead if you need the feature. Pull request with test case(s) and required code tweaks is the best option to get the feature landed 👍🏻

[SebastianStehle]

How would it look in javascript?

[lahma]

Hah, good catch. Maybe my morning brain. Might be easiest to have an extension method to handle this. Like Cells(1, 1)?

[lahma]

A JS equivalent would probably mean supplying an array to indexer call, like sheet.Cells[ ([1, 1]) ] and Jint would need to interpret that.

[lamazze]

For your information, with the stable version I can use: sheet.Cells["A1"].Value and not sheet.Cells[0, 0].Value.
But with the beta, nothing is working:

• When I use sheet.Cells["A1"].Value, the error is "Array was not a one-dimensional array"
• When I use sheet.Cells[0, 0].Value, the error is "Address is not valid"

[viruscamp]

Javascript grammar won't do the thing you want. Maybe it's comma operator .

sheet.Cells[1, 3].Value;
//is just
sheet.Cells[3].Value;

[viruscamp]

It's possible to separate sheet.Cells["idx"] and sheet.Cells[1].

And can we export the underlying methods ?

sheet.get_Item(1,3).Value;
sheet.set_Item(3,4, sth);

[lamazze]

@viruscamp using get_Item "solves" the problem.

sheet.Cells["A1"].Value returns the content of the cell
sheet.Cells[1, 1].Value returns "1 is undefined"
sheet.Cells[1][1].Value returns "1 is undefined"
sheet.Cells.get_Item(1, 1).Value returns the content of the cell
sheet.Cells.get_Item("A1").Value returns the content of the cell

[lamazze]

I forgot to mention that these are the result with v2 of JINT.
With 3 beta, nothing works:
sheet.Cells["A1"].Value returns "Array was not a one-dimensional array"
sheet.Cells[1, 1].Value returns "Address is not valid"
sheet.Cells[1][1].Value returns "Address is not valid"
sheet.Cells.get_Item(1, 1).Value returns "Array was not a one-dimensional array"
sheet.Cells.get_Item("A1").Value returns "Array was not a one-dimensional array"

[lahma]

OK so I think the expected outcomes for 3.x would be:

sheet.Cells["A1"].Value returns "Array was not a one-dimensional array" // SHOULD WORK
sheet.Cells[1, 1].Value returns "Address is not valid" // SHOULD NOT WORK AS NOT JS COMPATIBLE
sheet.Cells[1][1].Value returns "Address is not valid" // SHOULD WORK
sheet.Cells.get_Item(1, 1).Value returns "Array was not a one-dimensional array" // SHOULD WORK
sheet.Cells.get_Item("A1").Value returns "Array was not a one-dimensional array" // SHOULD WORK

[viruscamp]

sheet.Cells[1][1].Value returns "Address is not valid" // I donot like this
sheet.Cells.get_Item(1, 1).Value returns "Array was not a one-dimensional array" // I think it's enough

It will import a curring function like object sheet.Cells[1], and will make more harder overloads.

[viruscamp]

Assume we have such c# class:

class TestIndexer
{
  public static double this[int idx] { get; set; }
  public static string this[int idx, string ref] { get; set; }
}

In js, the grammar sheet.Cells[1][1].Value returns "Address is not valid" will make ambiguity,
TestIndexer[0] is a double or TestIndexer[0]['abc'] is a string?