Class ExcelPackage

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public sealed class ExcelPackage : IDisposable

Inheritance

object

ExcelPackage

Implements

IDisposable

Inherited Members

object.GetType()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Constructors

ExcelPackage()

public ExcelPackage()

ExcelPackage(FileInfo)

public ExcelPackage(FileInfo newFile)

Parameters

newFile FileInfo

ExcelPackage(FileInfo, bool)

public ExcelPackage(FileInfo template, bool useStream)

Parameters

template FileInfo

useStream bool

ExcelPackage(FileInfo, bool, string)

public ExcelPackage(FileInfo template, bool useStream, string password)

Parameters

template FileInfo

useStream bool

password string

ExcelPackage(FileInfo, FileInfo)

public ExcelPackage(FileInfo newFile, FileInfo template)

Parameters

newFile FileInfo

template FileInfo

ExcelPackage(FileInfo, FileInfo, string)

public ExcelPackage(FileInfo newFile, FileInfo template, string password)

Parameters

newFile FileInfo

template FileInfo

password string

ExcelPackage(FileInfo, string)

public ExcelPackage(FileInfo newFile, string password)

Parameters

newFile FileInfo

password string

ExcelPackage(Stream)

public ExcelPackage(Stream newStream)

Parameters

newStream Stream

ExcelPackage(Stream, Stream)

public ExcelPackage(Stream newStream, Stream templateStream)

Parameters

newStream Stream

templateStream Stream

ExcelPackage(Stream, Stream, string)

public ExcelPackage(Stream newStream, Stream templateStream, string Password)

Parameters

newStream Stream

templateStream Stream

Password string

ExcelPackage(Stream, string)

public ExcelPackage(Stream newStream, string Password)

Parameters

newStream Stream

Password string

Fields

MaxColumns

public const int MaxColumns = 16384

Field Value

int

MaxRows

public const int MaxRows = 1048576

Field Value

int

Properties

Compatibility

public CompatibilitySettings Compatibility { get; }

Property Value

CompatibilitySettings

Compression

public CompressionLevel Compression { get; set; }

Property Value

CompressionLevel

DoAdjustDrawings

public bool DoAdjustDrawings { get; set; }

Property Value

bool

Encryption

public ExcelEncryption Encryption { get; }

Property Value

ExcelEncryption

File

public FileInfo File { get; set; }

Property Value

FileInfo

Package

public ZipPackage Package { get; }

Property Value

ZipPackage

Stream

public Stream Stream { get; }

Property Value

Stream

Workbook

public ExcelWorkbook Workbook { get; }

Property Value

ExcelWorkbook

Methods

Dispose()

public void Dispose()

GetAsByteArray()

public byte[] GetAsByteArray()

Returns

byte[]

GetAsByteArray(string)

public byte[] GetAsByteArray(string password)

Parameters

password string

Returns

byte[]

Load(Stream)

public void Load(Stream input)

Parameters

input Stream

Load(Stream, string)

public void Load(Stream input, string Password)

Parameters

input Stream

Password string

Save()

public void Save()

Save(string)

public void Save(string password)

Parameters

password string

SaveAs(FileInfo)

public void SaveAs(FileInfo file)

Parameters

file FileInfo

SaveAs(FileInfo, string)

public void SaveAs(FileInfo file, string password)

Parameters

file FileInfo

password string

SaveAs(Stream)

public void SaveAs(Stream OutputStream)

Parameters

OutputStream Stream

SaveAs(Stream, string)

public void SaveAs(Stream OutputStream, string password)

Parameters

OutputStream Stream

password string