#ERR The function call failed - Cannot skip more rows than are present

[Matthew Berry]

Hi there,

I have a Python module that registers fine with xlSlim.

One of the python functions in that module always returns the following error when I call it from Excel:  "#ERR The function call failed - Cannot skip more rows than are present"

The same function works just fine when called from the Python file in the '__main__' block.

The function takes a DataFrame and returns DataFrame.  It is defined as follows:

def build_line_items(combinedNetworks:pd.DataFrame) -> pd.DataFrame:

When calling it from Excel, I pass it a cacheHandle to a DataFrame object.

Any ideas what causes this error, and how to avoid it?

Thanks!

Matt

[xlSlim Dev]

Hi,

That looks like you may be passing in an empty data frame. I would suggest verifying that the data frame is being created as expected in Excel. You could use the ViewPyObject() function for that.

Regards,

Russel 

--
You received this message because you are subscribed to the Google Groups "xlSlim Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xlslim-suppor...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/xlslim-support/d743e5b5-f46e-4c35-b572-dd32cf0eda55n%40googlegroups.com.

[Matthew Berry]

Thanks. 

The object is cached as expected when inspected with ViewPyObject.

[xlSlim Dev]

That is curious, could you tell me how many rows and columns are in the data frame please?

Thanks,

Russel 

[Matthew Berry]

As verified with ViewPyObject(), the input DataFrame has:  

16 columns + the index

116 data rows + column header

Oddly, the same function does work if called with build_line_items_from_handle(cacheHandle)  version.

[xlSlim Dev]

Ah of course, I should have thought of that. Functions that accept a data frame can be called in two ways - a) passing in the data from an Excel range or b) passing in a handle to a cached data frame. a) uses the original function name and b) appends _from_handle to the function name. 

Regards,

Russel 

To view this discussion on the web, visit https://groups.google.com/d/msgid/xlslim-support/24dbc10a-c2a2-4447-a616-7d4d879b250an%40googlegroups.com.

[Matthew Berry]

So for any function that accepts as input ONLY a single DataFrame, do we have to use the _from_handle version for it to work properly?

[xlSlim Dev]

Yes if passing in a cache handle. It is explained in this page:

https://russelwebber.github.io/xlslim-docs/html/user/dataframes.html#passing-pandas-dataframes-to-python-functions

[Matthew Berry]

Yep, it's right there in the docs, as you noted.  Thank you!