Convert your excel and csv as API

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.

GitHub

View Github