Sets the password used to protect the file from automatic writes. Syntax Parameters password The password to use to protect the file; null or the empty string will remove write protection from the file.userName The name of the user to store as the FileWriteProtectedBy value. If null is specified and a valid passwo...
Sets the password used to protect the file from automatic writes. Syntax Parameters password The password to use to protect the file; null or the empty string will remove write protection from the file.userName The name of the user to store as the FileWriteProtectedBy value. If null is specified and a valid passwo...
Sets the password used to protect the file from automatic writes. Overload List
Sets the password used to encrypt the document on subsequent saves. Syntax Parameters password The password to use to encrypt the document; null will prevent the document from being encrypted on subsequent saves.
Sets the password used to encrypt the document on subsequent saves. Syntax Parameters password The password to use to encrypt the document; null or the empty string will prevent the document from being encrypted on subsequent saves.
Sets the password used to encrypt the document on subsequent saves. Overload List
Gets or sets the value which indicates whether carriage return characters should be removed from string values in cells when the workbook is saved to an Excel file. Syntax Property Value True if the saved workbook file should not contain the carriage return characters from cell values; False to export the string v...
Gets the read-only collection of preset table styles in the workbook. Syntax
Gets the collection of custom styles in the workbook. Syntax Property Value The collection of custom styles in the workbook. Remarks Use this collection to add custom styles to Excel workbook. The user can apply those styles to different parts of excel workbook and thereby set complex formatting with ease.
Temporarily suspends the calculation of formulas. Syntax Remarks This should be used when adding many formulas or modifying large amounts of data on a workbook at once so formulas are not calculated each time cells are dirtied. For each call to SuspendCalculations, a call to ResumeCalculations must be made. As soo...