Table of Contents

Class XlsWorkbook

Namespace
Spire.Xls.Core.Spreadsheet
Assembly
Spire.XLS.dll
public class XlsWorkbook : XlsObject, IDisposable, IWorkbook, IExcelApplication
Inheritance
XlsWorkbook
Implements
Inherited Members

Fields

DEF_BAD_SHEET_NAME 

public const string DEF_BAD_SHEET_NAME = "#REF"

Field Value

string

DEF_COMENT_PARSE_COLOR 

public static readonly Color DEF_COMENT_PARSE_COLOR

Field Value

Color

DEF_FIRST_USER_COLOR 

public const int DEF_FIRST_USER_COLOR = 8

Field Value

int

Properties

ActiveSheet

Returns an object that represents the active sheet (the sheet on top) in the active workbook or in the specified window or workbook. Returns Nothing if no sheet is active. Read-only.

public IWorksheet ActiveSheet { get; }

Property Value

IWorksheet

ActiveSheetIndex

Gets / sets index of the active sheet.

public int ActiveSheetIndex { get; set; }

Property Value

int

AddInFunctions

Returns collection of all workbook's add-in functions. Read-only.

public IAddInFunctions AddInFunctions { get; }

Property Value

IAddInFunctions

Allow3DRangesInDataValidation

Indicates whether to allow usage of 3D ranges in DataValidation list property (MS Excel doesn't allow).

public bool Allow3DRangesInDataValidation { get; set; }

Property Value

bool

ArgumentsSeparator

Formula arguments separator.

public string ArgumentsSeparator { get; }

Property Value

string

Author

Returns or sets the author of the comment. Read-only String.

public string Author { get; set; }

Property Value

string

BuiltInDocumentProperties

Returns collection that represents all the built-in document properties for the specified workbook. Read-only. The following code snippet illustrates how to get the built in document properties:

//Create workbookWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");//Get the built in document propertiesIBuiltInDocumentProperties builtInDocumentProperties = workbook.DocumentProperties;
public IBuiltInDocumentProperties BuiltInDocumentProperties { get; }

Property Value

IBuiltInDocumentProperties

Charts

Collection of the chart objects.

public ICharts Charts { get; }

Property Value

ICharts

Chartsheets 

public List<ChartSheet> Chartsheets { get; }

Property Value

List<ChartSheet>

CodeName

Name which is used by macros to access the workbook items.

public string CodeName { get; set; }

Property Value

string

CurrentHeaderId 

public int CurrentHeaderId { get; set; }

Property Value

int

CurrentObjectId 

public int CurrentObjectId { get; set; }

Property Value

int

CurrentShapeId 

public int CurrentShapeId { get; set; }

Property Value

int

CustomDocumentProperties

Returns collection that represents all the custom document properties for the specified workbook. Read-only. The following code snippet illustrates how to get the custom document properties:

//Create workbookWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");//Get the document propertiesICustomDocumentProperties documentProperties = workbook.CustomDocumentProperties;
public ICustomDocumentProperties CustomDocumentProperties { get; }

Property Value

ICustomDocumentProperties

DataConns 

public DataConnections DataConns { get; }

Property Value

DataConnections

Date1904

True if the workbook uses the 1904 date system. Read / write Boolean.

public bool Date1904 { get; set; }

Property Value

bool

DefaultXFIndex 

public int DefaultXFIndex { get; set; }

Property Value

int

DetectDateTimeInValue

Indicates whether library should try to detect string value passed to Value (and Value2) property as DateTime. Setting this property to false can increase performance greatly for such operations especially on Framework 1.0 and 1.1. Default value is true.

public bool DetectDateTimeInValue { get; set; }

Property Value

bool

DisableMacrosStart

This Property allows users to disable load of macros from document. Excel on file open will simply skip macros and will work as if document does not contain them. This options works only when file contains macros (HasMacros property is True).

public bool DisableMacrosStart { get; set; }

Property Value

bool

DisplayWorkbookTabs

Indicates whether tabs are visible.

public bool DisplayWorkbookTabs { get; set; }

Property Value

bool

DisplayedTab

Index of tab which will be displayed on document open.

public int DisplayedTab { get; set; }

Property Value

int
public ExternalLinkCollection ExternalLinks { get; }

Property Value

ExternalLinkCollection

FirstCharSize 

public int FirstCharSize { get; set; }

Property Value

int

FullFileName 

public string FullFileName { get; }

Property Value

string

HasDuplicatedNames 

public bool HasDuplicatedNames { get; set; }

Property Value

bool

HasMacros

True indicate that opened workbook contains VBA macros.

public bool HasMacros { get; }

Property Value

bool

InnerAddInFunctions 

public XlsAddInFunctionsCollection InnerAddInFunctions { get; }

Property Value

XlsAddInFunctionsCollection

InnerFonts 

public XlsFontsCollection InnerFonts { get; }

Property Value

XlsFontsCollection

InnerPalette 

public List<Color> InnerPalette { get; }

Property Value

List<Color>

InnerWorksheets 

protected XlsWorksheetsCollection InnerWorksheets { get; }

Property Value

XlsWorksheetsCollection

IsCellProtection

True if cell is protected.

public bool IsCellProtection { get; }

Property Value

bool

IsDisplayPrecision

True if cell is protected.

public bool IsDisplayPrecision { get; set; }

Property Value

bool

IsHScrollBarVisible

Gets or sets a value indicating whether to display horizontal scroll bar. This sample shows how to hide horizontal scroll bar:

//Create workbookWorkbook workbook = new Workbook();//Hide horizontal scroll barworkbook.IsHScrollBarVisible = false;//Save to fileworkbook.SaveToFile("IsHScrollBarVisible.xlsx");
public bool IsHScrollBarVisible { get; set; }

Property Value

bool

IsLoaded 

public bool IsLoaded { get; }

Property Value

bool

IsRightToLeft

Indicates whether worksheet is displayed right to left.

public bool IsRightToLeft { get; set; }

Property Value

bool

IsVScrollBarVisible

Gets or sets a value indicating whether to display vertical scroll bar. This sample shows how to hide vertical scroll bar:

//Create workbookWorkbook workbook = new Workbook();//Hide vertical scroll barworkbook.IsVScrollBarVisible = false;//Save to fileworkbook.SaveToFile("IsVScrollBarVisible.xlsx");
public bool IsVScrollBarVisible { get; set; }

Property Value

bool

IsWindowProtection

True if window is protected.

public bool IsWindowProtection { get; }

Property Value

bool

Loading 

public bool Loading { get; }

Property Value

bool

MaxColumnCount

Returns maximum column count for each worksheet in this workbook. Read-only.

public int MaxColumnCount { get; }

Property Value

int

MaxDigitWidth 

public double MaxDigitWidth { get; }

Property Value

double

MaxIndent 

public int MaxIndent { get; }

Property Value

int

MaxRowCount

Returns maximum row count for each worksheet in this workbook. Read-only.

public int MaxRowCount { get; }

Property Value

int

MaxXFCount 

public int MaxXFCount { get; }

Property Value

int

Names

For an ReservedHandle object, returns a Names collection that represents all the names in the active workbook. For a Workbook object, returns a Names collection that represents all the names in the specified workbook (including all worksheet-specific names). The following code snippet illustrates how to get names:

//Create workbookWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");//Get namesINameRanges names = workbook.NameRanges;
public INameRanges Names { get; }

Property Value

INameRanges

ObjectCount 

public int ObjectCount { get; }

Property Value

int

Objects 

protected XlsWorkbookObjectsCollection Objects { get; }

Property Value

XlsWorkbookObjectsCollection

OleSize 

public IXLSRange OleSize { get; set; }

Property Value

IXLSRange

Palette

Get Palette of colors which an Excel document can have. Here is a table of color indexes to places in the color tool box provided by Excel application:

| | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ---+---------------------------------------- |1 | 00 | 51 | 50 | 49 | 47 | 10 | 53 | 54 | |2 | 08 | 45 | 11 | 09 | 13 | 04 | 46 | 15 | |3 | 02 | 44 | 42 | 48 | 41 | 40 | 12 | 55 | |4 | 06 | 43 | 05 | 03 | 07 | 32 | 52 | 14 | |5 | 37 | 39 | 35 | 34 | 33 | 36 | 38 | 01 | ---+---------------------------------------- |6 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | |7 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |

The following code illustrates how to access the default colors of excel color palette:

//Create worksheetWorkbook workbook = new Workbook();Worksheet worksheet = workbook.Worksheets[0];//Get colorsSystem.Drawing.Color[] colors = workbook.Colors;//Get colorSystem.Drawing.Color color = colors[2];//Set colorworksheet["B2"].Style.Color = color;//Save to fileworkbook.SaveToFile("CellFormats.xlsx");
public Color[] Palette { get; }

Property Value

Color[]

PasswordToOpen

Gets / sets password to encrypt document.

public string PasswordToOpen { get; set; }

Property Value

string

ReadOnly

True if the workbook has been opened as Read-only. Read-only Boolean.

public bool ReadOnly { get; }

Property Value

bool

ReadOnlyRecommended

True to display a message when the file is opened, recommending that the file be opened as read-only.

public bool ReadOnlyRecommended { get; set; }

Property Value

bool

RowSeparator

Gets / sets row separator for array parsing.

public string RowSeparator { get; }

Property Value

string

Saved

True if no changes have been made to the specified workbook since it was last saved. Read/write Boolean.

public bool Saved { get; set; }

Property Value

bool

Saving 

public bool Saving { get; }

Property Value

bool

SecondCharSize 

public int SecondCharSize { get; set; }

Property Value

int

StandardFont

Returns or sets the name of the standard font. Read/write String. The following code illustrates how to set the standard font for the workbook:

//Create worksheetWorkbook workbook = new Workbook();Worksheet worksheet = workbook.Worksheets[0];//Set textworksheet["B2"].Text = "Text";//Set standard fontworkbook.DefaultFontName = "Arial";//Set standard font sizeworkbook.DefaultFontSize = 18;//Save to fileworkbook.SaveToFile("CellFormats.xlsx");
public string StandardFont { get; set; }

Property Value

string

StandardFontSize

Returns or sets the standard font size, in points. Read/write. The following code illustrates how to set the standard font size for the workbook:

//Create worksheetWorkbook workbook = new Workbook();Worksheet worksheet = workbook.Worksheets[0];//Set textworksheet["B2"].Text = "Text";//Set standard fontworkbook.DefaultFontName = "Arial";//Set standard font sizeworkbook.DefaultFontSize = 18;//Save to fileworkbook.SaveToFile("CellFormats.xlsx");
public double StandardFontSize { get; set; }

Property Value

double

StandardRowHeight 

public double StandardRowHeight { get; set; }

Property Value

double

StandardRowHeightInPixels 

public int StandardRowHeightInPixels { get; set; }

Property Value

int

Styles

Returns a Styles collection that represents all the styles in the specified workbook. Read-only. The following code snippet illustrates how to get the Styles:

//Create worksheetWorkbook workbook = new Workbook();Worksheet worksheet = workbook.Worksheets[0];//Set stylesIStyles styles = workbook.Styles;
public IStyles Styles { get; }

Property Value

IStyles

TabSheets

Returns collection of tab sheets. Read-only.

public ITabSheets TabSheets { get; }

Property Value

ITabSheets

ThrowOnUnknownNames

Indicates whether exception should be thrown when unknown name was found in a formula.

public bool ThrowOnUnknownNames { get; set; }

Property Value

bool

Version

Gets / sets excel version.

public ExcelVersion Version { get; set; }

Property Value

ExcelVersion

Worksheets

Returns a Sheets collection that represents all the worksheets in the specified workbook. Read-only Sheets object.

public IWorksheets Worksheets { get; }

Property Value

IWorksheets

Methods

Activate()

Activates the first window associated with the workbook.

[Obsolete("the method is not implemented")]
public void Activate()

AddFont(IFont) 

public IFont AddFont(IFont fontToAdd)

Parameters

fontToAdd IFont

Returns

IFont

Clone() 

[Obsolete("the method is not implemented")]
public IWorkbook Clone()

Returns

IWorkbook

Close()

Closes the object without saving.

public void Close()

Close(bool) 

public void Close(bool saveChanges)

Parameters

saveChanges bool

Close(bool, string) 

public void Close(bool SaveChanges, string Filename)

Parameters

SaveChanges bool
Filename string

Close(string)

Closes the object and saves changes into specified file.

public void Close(string Filename)

Parameters

Filename string

File name in which workbook will be saved if SaveChanges is true.

ColorDistance(Color, Color) 

protected double ColorDistance(Color color1, Color color2)

Parameters

color1 Color
color2 Color

Returns

double

ContainsFont(XlsFont) 

public bool ContainsFont(XlsFont font)

Parameters

font XlsFont

Returns

bool

ConvertUnits(double, MeasureUnits, MeasureUnits) 

public double ConvertUnits(double value, MeasureUnits from, MeasureUnits to)

Parameters

value double
from MeasureUnits
to MeasureUnits

Returns

double

CopyToClipboard()

Copies workbook to the clipboard.

[Obsolete("the method is not implemented")]
public void CopyToClipboard()

CopyToClipboard(XlsWorksheet) 

protected void CopyToClipboard(XlsWorksheet sheet)

Parameters

sheet XlsWorksheet

CreateFont() 

public IFont CreateFont()

Returns

IFont

CreateFont(IFont) 

public IFont CreateFont(IFont baseFont)

Parameters

baseFont IFont

Returns

IFont

CreateFont(IFont, bool) 

public IFont CreateFont(IFont baseFont, bool bAddToCollection)

Parameters

baseFont IFont
bAddToCollection bool

Returns

IFont

CreateFont(string, float, int) 

public IFont CreateFont(string familyName, float size, int fontStyles)

Parameters

familyName string
size float
fontStyles int

Returns

IFont

CreateTemplateMarkersProcessor() 

public IMarkersDesigner CreateTemplateMarkersProcessor()

Returns

IMarkersDesigner

DecodeName(string) 

public string DecodeName(string name)

Parameters

name string

Returns

string

Dispose()

Dispose object and free resources.

public override void Dispose()

EncodeName(string) 

public string EncodeName(string strName)

Parameters

strName string

Returns

string

FileWidthToPixels(double) 

public double FileWidthToPixels(double fileWidth)

Parameters

fileWidth double

Returns

double

FindAll(bool) 

public CellRange[] FindAll(bool findValue)

Parameters

findValue bool

Returns

CellRange[]

FindAll(DateTime) 

public CellRange[] FindAll(DateTime findValue)

Parameters

findValue DateTime

Returns

CellRange[]

FindAll(double, FindType) 

public CellRange[] FindAll(double findValue, FindType flags)

Parameters

findValue double
flags FindType

Returns

CellRange[]

FindAll(string, FindType) 

public CellRange[] FindAll(string findValue, FindType flags)

Parameters

findValue string
flags FindType

Returns

CellRange[]

FindAll(TimeSpan) 

public CellRange[] FindAll(TimeSpan findValue)

Parameters

findValue TimeSpan

Returns

CellRange[]

FindOne(bool) 

public IXLSRange FindOne(bool findValue)

Parameters

findValue bool

Returns

IXLSRange

FindOne(DateTime) 

public IXLSRange FindOne(DateTime findValue)

Parameters

findValue DateTime

Returns

IXLSRange

FindOne(double, FindType) 

public IXLSRange FindOne(double findValue, FindType flags)

Parameters

findValue double
flags FindType

Returns

IXLSRange

FindOne(string, FindType) 

public IXLSRange FindOne(string findValue, FindType flags)

Parameters

findValue string
flags FindType

Returns

IXLSRange

FindOne(TimeSpan) 

public IXLSRange FindOne(TimeSpan findValue)

Parameters

findValue TimeSpan

Returns

IXLSRange

GetBookIndex(int) 

public int GetBookIndex(int referenceIndex)

Parameters

referenceIndex int

Returns

int

GetMaxDigitWidth() 

public double GetMaxDigitWidth()

Returns

double

GetNearestColor(Color) 

public ExcelColors GetNearestColor(Color color)

Parameters

color Color

Returns

ExcelColors

GetNearestColor(Color, int) 

public ExcelColors GetNearestColor(Color color, int iStartIndex)

Parameters

color Color
iStartIndex int

Returns

ExcelColors

GetNearestColor(int, int, int) 

public ExcelColors GetNearestColor(int r, int g, int b)

Parameters

r int
g int
b int

Returns

ExcelColors

GetPaletteColor(ExcelColors) 

public Color GetPaletteColor(ExcelColors color)

Parameters

color ExcelColors

Returns

Color

InitializeCollections() 

protected void InitializeCollections()

IsExternalReference(int) 

public bool IsExternalReference(int reference)

Parameters

reference int

Returns

bool

IsFormatted(int) 

public bool IsFormatted(int xfIndex)

Parameters

xfIndex int

Returns

bool

Paste() 

protected void Paste()

PixelsToWidth(double) 

public double PixelsToWidth(double pixels)

Parameters

pixels double

Returns

double

Protect(bool, bool) 

public void Protect(bool bIsProtectWindow, bool bIsProtectContent)

Parameters

bIsProtectWindow bool
bIsProtectContent bool

Protect(bool, bool, string) 

public void Protect(bool bIsProtectWindow, bool bIsProtectContent, string password)

Parameters

bIsProtectWindow bool
bIsProtectContent bool
password string

Replace(string, DataColumn, bool) 

public void Replace(string oldValue, DataColumn newValues, bool isFieldNamesShown)

Parameters

oldValue string
newValues DataColumn
isFieldNamesShown bool

Replace(string, DataTable, bool) 

public void Replace(string oldValue, DataTable newValues, bool isFieldNamesShown)

Parameters

oldValue string
newValues DataTable
isFieldNamesShown bool

Replace(string, DateTime) 

public void Replace(string oldValue, DateTime newValue)

Parameters

oldValue string
newValue DateTime

Replace(string, double) 

public void Replace(string oldValue, double newValue)

Parameters

oldValue string
newValue double

Replace(string, double[], bool) 

public void Replace(string oldValue, double[] newValues, bool isVertical)

Parameters

oldValue string
newValues double[]
isVertical bool

Replace(string, int[], bool) 

public void Replace(string oldValue, int[] newValues, bool isVertical)

Parameters

oldValue string
newValues int[]
isVertical bool

Replace(string, string) 

public void Replace(string oldValue, string newValue)

Parameters

oldValue string
newValue string

Replace(string, string[], bool) 

public void Replace(string oldValue, string[] newValues, bool isVertical)

Parameters

oldValue string
newValues string[]
isVertical bool

ResetPalette()

Recover palette to default values. The following code snippets illustrates how to reset the palette:

//Create worksheetWorkbook workbook = new Workbook();Worksheet worksheet = workbook.Worksheets[0];//Get colorsSystem.Drawing.Color[] colors = workbook.Colors;//Check colorConsole.WriteLine(colors[2].Name);//Set colorcolors[2] = System.Drawing.Color.Yellow;//Reset paletteworkbook.ResetPalette();//Check colorConsole.WriteLine(workbook.Colors[2].Name);//Save to fileworkbook.SaveToFile("CellFormats.xlsx");
public void ResetPalette()

Save()

Saves changes to the specified workbook. This sample shows how to save changes to the specified workbook:

//Load workbookWorkbook workbook = new Workbook();workbook.LoadFromFile("Sample.xlsx");//Save to fileworkbook.Save();
public void Save()

SaveAs(Stream) 

public void SaveAs(Stream stream)

Parameters

stream Stream

SaveAs(Stream, ExcelSaveType) 

public void SaveAs(Stream stream, ExcelSaveType saveType)

Parameters

stream Stream
saveType ExcelSaveType

SaveAs(Stream, ExcelSaveType, ExcelVersion) 

public void SaveAs(Stream stream, ExcelSaveType saveType, ExcelVersion version)

Parameters

stream Stream
saveType ExcelSaveType
version ExcelVersion

SaveAs(Stream, string) 

public void SaveAs(Stream stream, string separator)

Parameters

stream Stream
separator string

SaveAs(string) 

public void SaveAs(string FileName)

Parameters

FileName string

SaveAs(string, ExcelSaveType) 

public void SaveAs(string fileName, ExcelSaveType saveType)

Parameters

fileName string
saveType ExcelSaveType

SaveAs(string, ExcelSaveType, ExcelVersion) 

public void SaveAs(string fileName, ExcelSaveType saveType, ExcelVersion version)

Parameters

fileName string
saveType ExcelSaveType
version ExcelVersion

SaveAs(string, string) 

public void SaveAs(string fileName, string separator)

Parameters

fileName string
separator string

SaveAs(string, string, bool) 

public void SaveAs(string fileName, string separator, bool addQuotationsForStringValue)

Parameters

fileName string
separator string
addQuotationsForStringValue bool

SaveAsEmfStream(int, Stream, int, int, int, int) 

public void SaveAsEmfStream(int sheetIndex, Stream EmfStream, int firstRow, int firstColumn, int lastRow, int lastColumn)

Parameters

sheetIndex int
EmfStream Stream
firstRow int
firstColumn int
lastRow int
lastColumn int

SaveAsHtml(string, HTMLOptions) 

[Obsolete("the method is not implemented")]
public void SaveAsHtml(string fileName, HTMLOptions saveOption)

Parameters

fileName string
saveOption HTMLOptions

SaveAsImageOrXps(Stream, FileFormat) 

public void SaveAsImageOrXps(Stream stream, FileFormat fileFormat)

Parameters

stream Stream
fileFormat FileFormat

SaveAsImageOrXps(string, FileFormat) 

public void SaveAsImageOrXps(string fileName, FileFormat fileFormat)

Parameters

fileName string
fileFormat FileFormat

SaveAsImages(int, int, int, int, int, float, float) 

public Stream SaveAsImages(int sheetIndex, int firstRow, int firstColumn, int lastRow, int lastColumn, float dpiX, float dpiY)

Parameters

sheetIndex int
firstRow int
firstColumn int
lastRow int
lastColumn int
dpiX float
dpiY float

Returns

Stream

SaveAsImages(int, float, float) 

public Stream SaveAsImages(int sheetIndex, float dpiX, float dpiY)

Parameters

sheetIndex int
dpiX float
dpiY float

Returns

Stream

SaveAsImages(float, float) 

public Stream[] SaveAsImages(float dpiX, float dpiY)

Parameters

dpiX float
dpiY float

Returns

Stream[]

SaveAsSkImages(int, float, float) 

public SKBitmap SaveAsSkImages(int sheetIndex, float dpiX, float dpiY)

Parameters

sheetIndex int
dpiX float
dpiY float

Returns

SKBitmap

SaveChartAsImage(ChartSheet, ConverterSetting) 

public Stream SaveChartAsImage(ChartSheet chartsheet, ConverterSetting imageOrPrintOptions)

Parameters

chartsheet ChartSheet
imageOrPrintOptions ConverterSetting

Returns

Stream

SaveChartAsImage(Worksheet, ConverterSetting) 

public Stream[] SaveChartAsImage(Worksheet worksheet, ConverterSetting imageOrPrintOptions)

Parameters

worksheet Worksheet
imageOrPrintOptions ConverterSetting

Returns

Stream[]

SaveChartAsImage(Worksheet, int, ConverterSetting) 

public Stream SaveChartAsImage(Worksheet worksheet, int chartIndex, ConverterSetting imageOrPrintOptions)

Parameters

worksheet Worksheet
chartIndex int
imageOrPrintOptions ConverterSetting

Returns

Stream

SaveToPdf(Stream) 

public void SaveToPdf(Stream stream)

Parameters

stream Stream

SaveToPdf(string) 

public void SaveToPdf(string fileName)

Parameters

fileName string

SaveToXlsm(Stream) 

public void SaveToXlsm(Stream stream)

Parameters

stream Stream

SaveToXlsm(string) 

public void SaveToXlsm(string fileName)

Parameters

fileName string

SetActiveWorksheet(XlsWorksheetBase) 

public void SetActiveWorksheet(XlsWorksheetBase sheet)

Parameters

sheet XlsWorksheetBase

SetChanged() 

public void SetChanged()

SetColorOrGetNearest(Color) 

public ExcelColors SetColorOrGetNearest(Color color)

Parameters

color Color

Returns

ExcelColors

SetColorOrGetNearest(int, int, int) 

public ExcelColors SetColorOrGetNearest(int r, int g, int b)

Parameters

r int
g int
b int

Returns

ExcelColors

SetMaxDigitWidth(int) 

public void SetMaxDigitWidth(int w)

Parameters

w int

SetPaletteColor(int, Color) 

public void SetPaletteColor(int index, Color color)

Parameters

index int
color Color

SetSeparators(char, char) 

public void SetSeparators(char argumentsSeparator, char arrayRowsSeparator)

Parameters

argumentsSeparator char
arrayRowsSeparator char

SetWriteProtectionPassword(string) 

public void SetWriteProtectionPassword(string password)

Parameters

password string

SplitPageInfo(ConverterSetting) 

public List<Dictionary<int, PageColRow>> SplitPageInfo(ConverterSetting converterSetting)

Parameters

converterSetting ConverterSetting

Returns

List<Dictionary<int, PageColRow>>

Unprotect()

Unprotects workbook.

public void Unprotect()

Unprotect(string) 

public void Unprotect(string password)

Parameters

password string

WidthToFileWidth(double) 

public double WidthToFileWidth(double width)

Parameters

width double

Returns

double