Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable full column and row reference #24

Closed
shirisha95 opened this issue Jan 28, 2019 · 1 comment
Closed

Enable full column and row reference #24

shirisha95 opened this issue Jan 28, 2019 · 1 comment
Assignees

Comments

@shirisha95
Copy link

shirisha95 commented Jan 28, 2019

VLOOKUP doesn't work
Vlookup from one sheet to another throws 'negative dimensions are not allowed'

Steps to reproduce the behavior:

  1. Sample file
    Book1.xlsx
  2. Sample Code:
    sample.txt
  3. Error - Stack trace
    Failed DISPATCHING '='[BOOK.XLSX]SHEET2'!A:B' due to:
    ValueError('negative dimensions are not allowed',)
    Traceback (most recent call last):
    File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/schedula/utils/sol.py", line 748, in _set_function_node_output
    res = self._evaluate_function(args, node_id, node_attr, attr)
    File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/schedula/utils/sol.py", line 533, in _evaluate_function
    res = func(*args)
    File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/formulas/cell.py", line 166, in call
    return _assemble_values(base, values, sh.EMPTY)
    File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/formulas/ranges.py", line 103, in _assemble_values
    res = np.empty(_shape(**base), object)
    ValueError: negative dimensions are not allowed

Expected behavior
VLOOKUP is to be evaluated

@vinci1it2000 vinci1it2000 self-assigned this Feb 5, 2019
@vinci1it2000
Copy link
Owner

As I mention in the email the problem is not the VLOOKUP but just the range definition. Ranges like A:B or 1:6 (i.e. full column or row reference) are not fully supported in this version.

If you are on rush I suggest to modify the excel file specifying the range as A1:B4. Otherwise, I'm working to solve it.

@vinci1it2000 vinci1it2000 changed the title Vlookup gives negative dimensions are not allowed error Enable full column and row reference Mar 12, 2019
@vinci1it2000 vinci1it2000 added this to the Next Release milestone Mar 12, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants