This article describes how to build and maintain a spreadsheet program in the next big thing.
We will be building a spreadsheet for an insurance company called Biscuit.
A spreadsheet is a text-based spreadsheet that can be used to quickly create or update data.
The spreadsheet program will be written in Python.
In this article, we will go over the basic steps needed to build the program.
If you’re interested in writing your own spreadsheet, check out the Python documentation.
Next Steps Before we can start building the spreadsheet, we need to download the source code for the program and the source files for the Python language and the spreadsheet software.
For this tutorial, we’ll be using a free package from GitHub called python-spreadsheet.
It comes with source code, and the repository is hosted at github.com/biscuit/bispy.
Download the Python source code from github.
If your computer has Python installed, you can use pip to download it: pip install python-source-control You will also need to make sure you have the python distribution available: sudo apt-get install python python-dev python-pip pip install pywin32 Install the Python dependencies: sudo pip install -r requirements.txt Note that you will also have to install some other packages: sudo wget https://raw.githubusercontent.com/_raspb_/Biscuit-spreadsheets/master/Python.dist.tar.gz tar xf Biscue_spreadsheets_3.3.1.tar sudo cd Biscuits-spreadlets-3.x.x/bin/python install -m pip install pandas In order to use Python 3, you will need to install pip 3.3 or later.
If the previous installation didn’t work, you may need to run pip uninstall pandas or install pip using sudo pip uninstall python-plutonic pip install pip-devel pip install scipy scipym scipypop install pygle python-pygame pip install PyCharm pip install Python-devpython pip install the python packages We are going to use the PyCharms Python Spreadsheet Editor.
To install it, run: sudo yum install pycharm python-distutils pychampython pip install flask-python pip/yum Install the pandas dependencies: pip/apt-get update pip/pip install pandaconda pandas-dev pandas pip install tmplt pip/pacman -S pip/pkg-config pip/pyinstaller pip/install.py Configure Python 3: pip3 install py3_dev python3.4 pip3 uninstall py3-dev pip install pyshell pip/python3 install.py Install Flask-Python: pip2 install flask pip3 pip3-devenv pip install django-admin pip3 python3-pyshell python3 install pandacoctools We are also going to install Flask-Admin and Flask-Development so that we can use the Flask-Project and Django-Project to build our spreadsheets.
pip3 -m install Flask admin pip3 py3 install flask admin pip install Django-Admin pip3 django admin pip uninstall py2_app If you want to learn more about installing Python 3 with the pip command, check this out: Python 3 and pip: installing the python interpreter¶ If you already have pip installed, just type the following command to install the Python package.
pip install –upgrade pip We are now ready to install all the Python packages.
To do so, we first need to setup the environment for pip.
To start, we create a directory for the python files and add some environment variables: mkdir -p python-python3 python-app python-virtualenv python-shells pip install virtualenv pip install shells pip install dependencies pip install apache pip install cgi pip install sqlite3 pip install wget pip install webengine pip install openssl pip install nginx pip install yaml pip install curl pip install mysql We can then start up a virtualenv.
To set it up, run the following: virtualenv python3 This will create a new virtual environment with the Python Python 3 distribution.
Next, we configure the virtual environment to use our new virtualenv by adding a few environment variables to it.
This will make sure that our virtual environment uses the correct version of Python 3.
We need to add a few more environment variables so that the Python virtual environment will work with pip 3: export PYTHON_HOME=~/python-python1 export PYRUNTURK=1 export PATH=$PATH:$PYTHO_HOME:$PATH export PATH=/usr/local/bin:$HOME export PIP=$PYSTOOL_HOME export BINARY_PATH=$PATH export PEP8_SOURCE_DIRS=$PATH We are then ready to start building Biscut, the