8.1.26.7 Worksheet::GetColFormats

It is recommended that you switch to the originpro package. PyOrigin is primarily for users who need to work with Origin version prior to 2021.

Description

Gets the column formats of all the columns in the worksheet

Syntax

GetColFormats()

Parameters

Return

A string containing all the column formats.

Examples

#Create Sheet in Book1 with 5 columns
 
#the following code will set column formats in a new worksheet
# 1st column - Numeric (0)
# 2nd column - Text    (1)
# 3rd column - Time    (2)
# 4th column - Date    (3)
# 5th column - Text and Numeric (9)
wks=PyOrigin.FindWorksheet('Book1')
Formats="01239"
wks.SetColFormats(Formats)
print(wks.GetColFormats())

See Also

Worksheet::SetColFormats