pydata / pydata/xarray

Supporting Excel Spreadsheets?

Open
#9,385 5 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement io topic-backends topic-DataTree
Dominant language
Python
Stars
4.2k
Forks
1.4k
Avg merge
2d 15h
Merged PRs (30d)
14

Description

from @ahuang11 in https://github.com/xarray-contrib/datatree/issues/342

I wonder if xarray-datatree should support reading Excel spreadsheets since a lot of the world still uses Excel, and I'm working with one right now.

I imagine the tree's leaves would contain each sheet, analogous to netCDF groups.

Perhaps it doesn't have to be limited Excel, and would be able to read Google Sheets directly by passing a URL.

Just a random thought.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The issue names no files, tests, or entry points. First clarify whether support should cover Excel files, Google Sheets URLs, or both, and how sheets map to tree leaves. Done would require an agreed scope and corresponding implementation and tests.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
data
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.