Excel/VBA Right Function
The Right function returns specified numbers of characters from the right of the string.
It takes two arguments – both are required:
The Right function returns specified numbers of characters from the right of the string.
It takes two arguments – both are required:
By using openpyxl.drawing.image module, you may insert images to the Excel sheet using Python programs.
In Excel, freezing columns or rows while scrolling through data can be very useful, especially for sheets with large data.
By using max_column, you may get the last column in the Excel sheet. In this tutorial, we will show you in a Python program to get the last column number in a sheet.
PasteSpecial function in VBA Normally, as you copy/paste a cell or range of cells in…
In this tutorial, we will show ways to get the last row number by using Python openpyxl library.
The IIf function (capital II and small f) can be taken as a simple form of If..Then..Else statements.
In this tutorial, we will look at how to get a sheet by name and then perform some operations like adding a row, coloring data, setting interior/background color to that sheet – rather than active sheet.
In this tutorial, we will show you getting the list of Sheets in an Excel Workbook by using Pandas.
CountA function returns counts of cells that are not empty (in range or array).
Alternatively, CountA returns the count of cell in range or array with data.
The read_excel method has a parameter index_col which default value is: index_col=None
Other values supported are int, list of int.
The CDate function converts an expression to date type.
AutoFill is a pretty useful method in VBA that can be used to auto fill the cells in the specified range.
In VBA, you may add single line comments or block (multiple line comments) by using:
Single quote for single comment
Using the menu option for block of comments
The Weekday function returns the number of day of the Week for the given date.