Why `headers` instead of `header` in `xl()`?

[fzumstein]

Pandas uses pd.read_excel(header) so I would have expected xl() to use header instead of headers (also, I'd say a table/dataframe only has a single header)?

[keyur32]

Thanks for the report. A few considerations the team had:

• This was based on what Excel users expect, for example in the create table dialog, it's long referred to as headers:
  

• The xl() function is meant to be configurable. Currently the Initialization pane is read only but we plan to allow users to override and pass in their own conversion functions (we'll share documentation on that later). So for example, instead of a dataframe you will be able to set the default to return a numpy array.

[fzumstein]

Thanks for the explanation! However, in a PY cell, I am in the Python world, so I think it makes more sense to take over Python syntax rather than Excel syntax.

[SergeiStPete]

Thanks for the explanation! However, in a PY cell, I am in the Python world, so I think it makes more sense to take over Python syntax rather than Excel syntax.

Oh, it depends. On the other hand that's Excel user who tests the water with Python.

[SergeiStPete]

• So for example, instead of a dataframe you will be able to set the default to return a numpy array. If so do I understand correctly numpy will be connected by default for all subscriptions where Python is available?