ByProgrammers Blog

iOS

2 min read

How to create multiple targets in XCode?

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.

Jan 06, 2019 Read Tutorial

Excel

3 min read

How to save retrieved SQL server result to excel with Python?

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 […]

Dec 30, 2018 Read Tutorial

Excel

2 min read

How to read / write and create excel easily with Python?

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 […]

Dec 26, 2018 Read Tutorial

Python

2 min read

How to access SQL server with Python?

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 […]

Dec 25, 2018 Read Tutorial

iOS

1 min read

Swift: Switch between Storyboards

Assuming you’ve created a storyboard called “SettingControllerSB.storyboard”. Next, you will need to give the View Controller a name via “Storyboard ID” as shown below.

Dec 25, 2018 Read Tutorial