First, go to Google Cloud. If you does not have an account, you are required to sign up an account in order to proceed next step. If you already have an account, please sign in to Google Cloud. After login to Google Cloud, go to Google Cloud Console. Create a new project via screenshots shown […]
These are the steps to install Django in Windows environment. ** Important Notes ** Use Command Prompt instead of PowerShell. 1.Download and install Python. Remember to add Path to environment variable. 2. Download and install PIP. 3. Install a virtual environment. 4. Create a virtual environment for all Django projects. 5. Activate the virtual environment. […]
If you are currently working for a company as an iOS developer, chances are you might need prepare your app to be run on different environments (e.g. Development, Testing and Production). Different environments will usually run on a different set of data such as the initial setting data or more specifically the API URL might be different.
Prerequisites: Ensure you have Python 3 and SQL server install on your environment If you not sure how to retrieve data from SQL server with Python 3 and how to write data to excel file wtih Python 3, you are recommended to read through other blog posts below if you find difficulties to follow this […]
Prerequisites: Ensure you have Python 3 install at your environment In order to interact with excel file with python, we need to install openpyxl. Run command below in terminal / cmd to install the library. Script 1: Read excel file Create a simple excel file “sample1.xlsx” with content above and saved it in my project […]
Prerequisites: Ensure you have python 3 and above installed in your environment Ensure you have SQL server Management Studio installed in your environment In order to connect to SQL server, we’re going to install python library pyodbc. To install this library please run command below: After that, complete library installation, we’re going to write a simple […]