Convert your excel and csv as API

⚠️ Archived: this project is no longer maintained. Don't deploy it on a public server.

It fetches whatever file location a request passes to it without restricting it, it turns off HTTPS certificate checks, and its pinned dependencies date from 2022 (with current pandas every request fails). These will not be fixed.

Maintained alternatives:

• Datasette to publish your own CSV or Excel data as a JSON API, with filtering
• opensheet to read a Google Sheet as JSON

It can read from excel and csv file url

Documentation

Please open https://excel2api.herokuapp.com/docs

Documentation explanation:

• host/v1/api/excel

  • query string sheet_name is sheet name to open
  • query string sheet_url is url where excel will be open
  • query string row_range is range row:
    • 1:50 mean will display data from row 1 to 49
    • :50 mean will display data from first to 49
    • 50 mean will display data from first to 49
  • query string column_range is range row:
    • date mean will display only column date
    • date,age mean will display only column date and age

• host/v1/api/csv

  • query string sheet_url is url where csv will be open
  • query string row_range is range row:
    • 1:50 mean will display data from row 1 to 49
    • :50 mean will display data from first to 49
    • 50 mean will display data from first to 49
  • query string column_range is range row:
    • date mean will display only column date
    • date,age mean will display only column date and age

Manual Installation

• Need python 3.7+
• Backed by python fast api
• pip install -r requirements.txt
• Run with command uvicorn main:app --reload --port 8000

Manual Installation

• Need python 3.7+
• pip install -r requirements.txt
• change configuration in conf/.env.yaml
• Backed by python fast api

Running unit test

  python -m unittest discover -v -s ./tests

Contribution

We are always happy to have new contributions. We have marked issues good for anyone looking to get started, and welcome.