utility Archives - SQLRelease

An Introduction to mssql-cli – Cross platform Interactive command line tool for SQL Server

Leave a Comment / Python, SQL Server / Gopal Krishna Ranjan / Apr 30, 2020 / sql tools, utility

In this post, we are going to discuss a new cross-platform and interactive command-line query tool that can be used to communicate with Microsoft SQL Server. Unlike sqlcmd command-line utility, mssql-cli supports cross-platform and can be used on Windows, macOS, Linux, Ubuntu, Debian, CentOS, Fedora, and etc. This is an open-source tool and it supports […]

An Introduction to mssql-cli – Cross platform Interactive command line tool for SQL Server Read More »

Python use case – Save each worksheet as a separate excel workbook

In this post “Python use case – Save each worksheet as a separate excel workbook“, we are going to learn that how we can create a separate workbook for each worksheet of a given excel file. We will be copying data, values, formatting and all other settings of the sheet in the newly created workbook.