Module - Enumerations

Collection of the MS Excel constants.

Enumerations

Parameters:

Name	Description
empty	Empty file.
workbook	Workbook file.

Parameters:

Name	Description
overwrite	Overwrite the destination file if a file with the same name already exists in the destination.
duplicate	Create a copy of the file if a file with the same name already exists in the destination.
throwError	Throw a FileAlreadyExists error if a file with the same name already exists in the destination.

Parameters:

Name	Description
readOnly	Read only access.
readWrite	Read write access.
noAccess	No access.

Parameters:

Name	Description
formulas	Retrieve formulas.
values	Retrieve values.
numberFormat	Retrieve number formats.

Parameters:

Name	Description
standard	A unique value is returned in case of a unique cell range, otherwise a 2-D array is returned.
reduceToList	A unique value is returned in case of unique cell range, a 1-D array is return for single row or single column range and otherwise a 2-D dimension is returned.
objectsHeadersOnFirstRow	Return a list of objects. The properties of the objects are determined by the headers of the first row of the range.
objectsNoHeaders	Return a list of objects. Properties of the objects are generated automatically with col1, col2, col3 based on the position in the worksheet.

Parameters:

Name	Description
index	An index is returned : 1, 2, 16384, ...
name	A column name is returned : 'A', 'B', 'XFD', ...

Parameters:

Name	Description
attachment	The name of files attached to an email message.
bcc	The bcc field of an email message, specified as an SMTP address, display name, or alias.
body	The body of an email message.
cc	The Cc field of an email message, specified as an SMTP address, display name, or alias.
from	The sender of an email message, specified as an SMTP address, display name, or alias.
hasAttachment	True if an email message contains an attachment that is not an inline attachment, false otherwise.
importance	The importance of an email message, which a sender can specify when sending a message. The possible values are low, medium, or high.
kind	The type of message. The possible values are contacts, docs, email, faxes, im, journals, meetings, notes, posts, rssfeeds, tasks, or voicemail.
participants	The from, to, Cc, and bcc fields of an email message, specified as an SMTP address, display name, or alias.
received	The date of receipt of an email message.
recipients	The to, Cc, and bcc fields of an email message, specified as an SMTP address, display name, or alias.
sent	The sent date of an email message.
size	The size of an item in bytes.
subject	The text in the subject line of an email message.
to	The to field of an email message, specified as an SMTP address, display name, or alias.
isRead	Is read

Parameters:

Name	Description
deleteditems	The folder in which items are moved to when they are deleted.
drafts	The folder that contains unsent messages.
inbox	The inbox folder
junkemail	The junk email folder
outbox	The outbox folder
sentitems	The sent items folder

Parameters:

Name	Description
subject	The subject of the event
startDateTime	Date and time. Start of the time interval for which you want to list events
endDateTime	Date and time. End of the time interval for which you want to list events

Parameters:

Name	Description
available	The user is available (status free or working elsewhere)
tentative	The user has an event that is neither accepted nor declined
unavailable	The user is unavailable (status busy).
outOfOffice	The user is out of the office (status busy or out of the office)

Parameters:

Name	Description
busy	The user is busy
tentative	The user is trying to join a meeting
outofOffice	The user is out of the office
free	The user is free
workingElsewhere	The user is working elsewhere

Parameters:

Name	Description
none	The user has not replied
tentative	The user will try to attend the meeting
accepted	The user has accepted the meeting request
declined	The user has declined the meeting request

Parameters:

Name	Description
Dateline_Standard_Time	International Date Line West
UTC_minus_11	Coordinated Universal Time-11
Aleutian_Standard_Time	Aleutian Islands
Hawaiian_Standard_Time	Hawaii
Marquesas_Standard_Time	Marquesas Islands
Alaskan_Standard_Time	Alaska
UTC_minus_09	Coordinated Universal Time-09
Pacific_Standard_Time	Pacific Time (US & Canada)
Pacific_Standard_Time__Mexico_	Baja California
UTC_minus_08	Coordinated Universal Time-08
Mountain_Standard_Time	Mountain Time (US & Canada)
Mountain_Standard_Time__Mexico_	Chihuahua, La Paz, Mazatlán
US_Mountain_Standard_Time	Arizona
Yukon_Standard_Time	Yukon
Canada_Central_Standard_Time	Saskatchewan
Central_America_Standard_Time	Central America
Central_Standard_Time	Central Time (US & Canada)
Central_Standard_Time__Mexico_	Guadalajara, Mexico City, Monterrey
Easter_Island_Standard_Time	Easter Island
Cuba_Standard_Time	Havana
Eastern_Standard_Time	Eastern Time (US & Canada)
Eastern_Standard_Time__Mexico_	Chetumal
Haiti_Standard_Time	Haiti
SA_Pacific_Standard_Time	Bogotá, Lima, Quito, Rio Branco
Turks_And_Caicos_Standard_Time	Turks and Caicos
US_Eastern_Standard_Time	Indiana (East)
Atlantic_Standard_Time	Atlantic Time (Canada)
Central_Brazilian_Standard_Time	Cuiaba
Pacific_SA_Standard_Time	Santiago
Paraguay_Standard_Time	Asunción
SA_Western_Standard_Time	Georgetown, La Paz, Manaus, San Juan
Venezuela_Standard_Time	Caracas
Newfoundland_Standard_Time	Newfoundland
Argentina_Standard_Time	City of Buenos Aires
Bahia_Standard_Time	Salvador
E__South_America_Standard_Time	Brasilia
Greenland_Standard_Time	Greenland
Magallanes_Standard_Time	Punta Arenas
Montevideo_Standard_Time	Montevideo
SA_Eastern_Standard_Time	Cayenne, Fortaleza
Saint_Pierre_Standard_Time	Saint Pierre and Miquelon
Tocantins_Standard_Time	Araguaina
Mid_minus_Atlantic_Standard_Time	Mid-Atlantic - Old.
UTC_minus_02	Coordinated Universal Time-02
Azores_Standard_Time	Azores
Cape_Verde_Standard_Time	Cabo Verde Is.
GMT_Standard_Time	Dublin, Edinburgh, Lisbon, London
Greenwich_Standard_Time	Monrovia, Reykjavik
UTC	Coordinated Universal Time
Central_Europe_Standard_Time	Belgrade, Bratislava, Budapest, Ljubljana, Prague
Central_European_Standard_Time	Sarajevo, Skopje, Warsaw, Zagreb
Morocco_Standard_Time	Casablanca
Romance_Standard_Time	Brussels, Copenhagen, Madrid, Paris
W__Central_Africa_Standard_Time	West Central Africa
W__Europe_Standard_Time	Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
E__Europe_Standard_Time	Chisinau
Egypt_Standard_Time	Cairo
FLE_Standard_Time	Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
GTB_Standard_Time	Athens, Bucharest
Israel_Standard_Time	Jerusalem
Kaliningrad_Standard_Time	Kaliningrad
Libya_Standard_Time	Tripoli
Middle_East_Standard_Time	Beirut
Namibia_Standard_Time	Windhoek
South_Africa_Standard_Time	Harare, Pretoria
South_Sudan_Standard_Time	Juba
Sudan_Standard_Time	Khartoum
Syria_Standard_Time	Damascus
West_Bank_Standard_Time	Gaza, Hebron
Arab_Standard_Time	Kuwait, Riyadh
Arabic_Standard_Time	Baghdad
Belarus_Standard_Time	Minsk
E__Africa_Standard_Time	Nairobi
Iran_Standard_Time	Tehran
Jordan_Standard_Time	Amman
Russian_Standard_Time	Moscow, St. Petersburg
Turkey_Standard_Time	Istanbul
Volgograd_Standard_Time	Volgograd
Arabian_Standard_Time	Abu Dhabi, Muscat
Astrakhan_Standard_Time	Astrakhan, Ulyanovsk
Azerbaijan_Standard_Time	Baku
Caucasus_Standard_Time	Yerevan
Georgian_Standard_Time	Tbilisi
Mauritius_Standard_Time	Port Louis
Russia_Time_Zone_3	Izhevsk, Samara
Saratov_Standard_Time	Saratov
Afghanistan_Standard_Time	Kabul
Ekaterinburg_Standard_Time	Ekaterinburg
Pakistan_Standard_Time	Islamabad, Karachi
Qyzylorda_Standard_Time	Qyzylorda
West_Asia_Standard_Time	Ashgabat, Tashkent
India_Standard_Time	Chennai, Kolkata, Mumbai, New Delhi
Sri_Lanka_Standard_Time	Sri Jayawardenepura
Nepal_Standard_Time	Kathmandu
Bangladesh_Standard_Time	Dhaka
Central_Asia_Standard_Time	Nur-Sultan
Omsk_Standard_Time	Omsk
Myanmar_Standard_Time	Yangon (Rangoon)
Altai_Standard_Time	Barnaul, Gorno-Altaysk
N__Central_Asia_Standard_Time	Novosibirsk
North_Asia_Standard_Time	Krasnoyarsk
SE_Asia_Standard_Time	Bangkok, Hanoi, Jakarta
Tomsk_Standard_Time	Tomsk
W__Mongolia_Standard_Time	Hovd
China_Standard_Time	Beijing, Chongqing, Hong Kong, Urumqi
North_Asia_East_Standard_Time	Irkutsk
Singapore_Standard_Time	Kuala Lumpur, Singapore
Taipei_Standard_Time	Taipei
Ulaanbaatar_Standard_Time	Ulaanbaatar
W__Australia_Standard_Time	Perth
Aus_Central_W__Standard_Time	Eucla
Korea_Standard_Time	Seoul
North_Korea_Standard_Time	Pyongyang
Tokyo_Standard_Time	Osaka, Sapporo, Tokyo
Transbaikal_Standard_Time	Chita
Yakutsk_Standard_Time	Yakutsk
AUS_Central_Standard_Time	Darwin
Cen__Australia_Standard_Time	Adelaide
AUS_Eastern_Standard_Time	Canberra, Melbourne, Sydney
E__Australia_Standard_Time	Brisbane
Tasmania_Standard_Time	Hobart
Vladivostok_Standard_Time	Vladivostok
West_Pacific_Standard_Time	Guam, Port Moresby
Lord_Howe_Standard_Time	Lord Howe Island
Bougainville_Standard_Time	Bougainville Island
Central_Pacific_Standard_Time	Solomon Is, New Caledonia
Magadan_Standard_Time	Magadan
Norfolk_Standard_Time	Norfolk Island
Russia_Time_Zone_10	Chokurdakh
Sakhalin_Standard_Time	Sakhalin
Fiji_Standard_Time	Fiji
Kamchatka_Standard_Time	Petropavlovsk-Kamchatsky - Old
New_Zealand_Standard_Time	Auckland, Wellington
Russia_Time_Zone_11	Anadyr, Petropavlovsk-Kamchatsky
UTC_plus_12	Coordinated Universal Time+12
Chatham_Islands_Standard_Time	Chatham Islands
Samoa_Standard_Time	Samoa
Tonga_Standard_Time	Nuku'alofa
UTC_plus_13	Coordinated Universal Time+13
Line_Islands_Standard_Time	Kiritimati Island

Parameters:

Name	Description
equal	The value is strictly equal.
lessThan	The value is less than.
greaterThan	The value is greater than.
lessThanOrEqual	The value is less than or equal.
greaterThanOrEqual	The value is greater than or equal.

Parameters:

Name	Description
text	Text type: Maximum of 255 characters
multiLineText	Text type: Long text
number	Number type
dateTime	DateTime type
boolean	Boolean type
unsupported	Some types are not supported when you retrieve column details.

Parameters:

Name	Description
text	Text type: Maximum of 255 characters
multiLineText	Text type: Long text
number	Number type
dateTime	DateTime type
boolean	Boolean type

Parameters:

Name	Description
Available	Available
AvailableIdle	AvailableIdle
Away	Away
BeRightBack	BeRightBack
Busy	Busy
BusyIdle	BusyIdle
DoNotDisturb	DoNotDisturb
Offline	Offline
PresenceUnknown	PresenceUnknown

Parameters:

Name	Description
renderAsText	Render as text, tags are not computed
renderAsHtml	Render as html, tags are not computed

Parameters:

Name	Description
normal	Normal importance
high	High importance
urgent	Urgent importance

Parameters:

Name	Description
equal	The value is strictly equal.
contains	The value is contained.
lessThan	The value is less than.
greaterThan	The value is greater than.
lessThanOrEqual	The value is less than or equal.
greaterThanOrEqual	The value is greater than or equal.

Parameters:

Name	Description
title	Title of the chat
createdDateTime	Date and time when the chat was created
lastMessageCreatedDateTime	Date and time when the last message of the chat was created.
lastUpdatedDateTime	Last date and time when the chat was updated. (Chat was renamed or a member was changed.)
memberName	The name of the member of the chat
lastMessageText	The last message sent in the chat

Parameters:

Name	Description
any	Does not filter upon chat type
oneToOne	Filter on one-to-one chat (chat between two users)
group	Filter on group chat (chat between more than two users)
meeting	Filter on meeting chat (chat associated with an online meeting)

Parameters:

Name	Description
beforebegin	Adds the supplied content before the target
afterbegin	Adds the supplied content just inside the target, before its first child. Applies only to body, div, ol, and ul elements
beforeend	Adds the supplied content just inside the element, before its last child. Applies only to body, div, ol, and ul elements
afterend	Adds the supplied content after the target
replace	Replaces the target with the supplied content

Parameters:

Name	Description
name	Name of Notebook
createdDateTime	Date and time when the notebook was created
lastModifiedDateTime	Last date and time when the notebook was updated
createdByName	Name of the user who created the notebook

Parameters:

Name	Description
name	Name of Section
createdDateTime	Date and time when the section was created
lastModifiedDateTime	Last date and time when the section was updated
notebookName	Name of Parent Notebook

Parameters:

Name	Description
title	Page Title
createdDateTime	Date and time when the page was created
lastModifiedDateTime	Last date and time when the page was updated
sectionName	Name of Parent Section

Parameters:

Name	Description
equal	The value is strictly equal.
contains	The value is contained.
lessThan	The value is less than.
greaterThan	The value is greater than.
lessThanOrEqual	The value is less than or equal.
greaterThanOrEqual	The value is greater than or equal.

Parameters:

Name	Description
html	Output the HTML of the page
text	Output the raw text of the page