In this article, I will show you how to make an excel cell expand it’s width and height to fit the input text width or height automatically.
How To Make Excel Cells Expand To Fit Text Automatically Read More »
There are three ways to adjust excel worksheet row height and column width as below. I will tell you how to do it one by one with an example in this article. Adjust it by hand. Adjust it by ribbon menu item. Adjust it by popup menu item.
How To Adjust Excel WorkSheet Row Height And Column Width Read More »
My excel display language is Chinese by default, but for some reason, I need to change the excel display language to English. This article will tell you how to change the excel display and editing language, and after that, you will find the whole office software display and editing language has all been changed as
How To Change Microsoft Office ( Word, Excel etc ) Display And Editing Language Read More »
Sometimes you need to know which bit-version dose your installed Microsoft office software is, then you can download and install additional software such as office language package according to your current office software bit version. In this article, I will tell you how to check whether your installed office software is a 32-bit or 64-bit
How To Check MS Office Is 32 Or 64 Bit Version Read More »
In this article I will tell you how to use the python openpyxl library to freeze excel sheet rows and columns, it also tells you how to split excel sheets into multiple panes with examples.
How To Use Python Openpyxl To Freeze Excel Rows Columns And Split Panes Read More »
In this article, I will tell you how to use the python openpyxl library to copy one excel sheet data to another excel sheet, the two excel sheets can be in the same excel file or different excel file. If you do not know the openpyxl library, you can read the article How To Create
How To Use Python Openpyxl To Copy Excel Sheet Data In Same And Different Excel File Read More »
In this article, I will show you how to use python library openpyxl to easily create an excel workbook, add a worksheet to the workbook, insert cell data and save the workbook object to a local excel file. It will also show you how to read a local excel file and load all the excel
How To Create / Load Excel File In Python Using Openpyxl Read More »
In this article, i will show you how to use python regular expression module ( python re module ) to parse a string to return the first matched string and all matched strings.
How To Find First And All Matched String Use Python Regex Pattern Object Read More »
Pymongo is a popular mongo database python driver library. We can use it to manage the mongo database. In this article, I will show you how to install pymongo library and how to use pymongo to connect to the mongo database. It also tells you how to create a mongo database and collection in python
How To Connect MongoDB And Create Database Collection In Python Source Code Read More »
I use Sourcetree to manage my example project source files on windows 10, and it uses a git version control system. But when I commit or merge my project files, it shows a Filename too long error. After investigating, I finally find the method to fix it.
How To Fix Filename Too Long Error When Use Git On Windows 10 Read More »