Class Workbook

Namespace

FileFormat.Cells

Assembly

FileFormat.Cells.dll

public class Workbook : IDisposable

Inheritance

object

Workbook

Implements

IDisposable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

Workbook()

public Workbook()

Workbook(string)

public Workbook(string filePath)

Parameters

filePath string

Fields

spreadsheetDocument

protected SpreadsheetDocument spreadsheetDocument

Field Value

SpreadsheetDocument

stylesPart

protected WorkbookStylesPart stylesPart

Field Value

WorkbookStylesPart

workbookpart

protected WorkbookPart workbookpart

Field Value

WorkbookPart

worksheetPart

protected WorksheetPart worksheetPart

Field Value

WorksheetPart

Properties

BuiltinDocumentProperties

public BuiltInDocumentProperties BuiltinDocumentProperties { get; set; }

Property Value

BuiltInDocumentProperties

DefaultStyleId

public uint DefaultStyleId { get; }

Property Value

uint

Worksheets

public List<Worksheet> Worksheets { get; }

Property Value

List<Worksheet>

Methods

AddSheet(string)

public Worksheet AddSheet(string sheetName)

Parameters

sheetName string

Returns

Worksheet

CreateStyle(string, double, string)

public uint CreateStyle(string fontName, double fontSize, string hexColor)

Parameters

fontName string

fontSize double

hexColor string

Returns

uint

Dispose()

public void Dispose()

Dispose(bool)

protected virtual void Dispose(bool disposing)

Parameters

disposing bool

RemoveSheet(string)

public bool RemoveSheet(string sheetName)

Parameters

sheetName string

Returns

bool

Save()

public void Save()

Save(Stream)

public void Save(Stream stream)

Parameters

stream Stream

Save(string)

public void Save(string filePath)

Parameters

filePath string

UpdateDefaultStyle(string, double, string)

public void UpdateDefaultStyle(string newFontName, double newFontSize, string hexColor)

Parameters

newFontName string

newFontSize double

hexColor string