Table of Contents

Interface IXLSheet

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public interface IXLSheet
Extension Methods

Properties

Charts 

IXLCharts Charts { get; }

Property Value

IXLCharts

Name

Gets or sets the name (caption) of this worksheet.

string Name { get; set; }

Property Value

string

PageSetup

Gets an object to manipulate the sheet's print options.

IXLPageSetupBase PageSetup { get; }

Property Value

IXLPageSetupBase

Pictures 

IXLPictures Pictures { get; }

Property Value

IXLPictures

Position

Gets or sets the position of the sheet.

When setting the Position all other sheets' positions are shifted accordingly.

int Position { get; set; }

Property Value

int

RelId 

string? RelId { get; set; }

Property Value

string

SheetId 

int SheetId { get; set; }

Property Value

int

SheetView

Gets an object to manage how the sheet is going to be displayed by Excel.

IXLSheetViewBase SheetView { get; }

Property Value

IXLSheetViewBase

TabActive 

bool TabActive { get; set; }

Property Value

bool

TabSelected 

bool TabSelected { get; set; }

Property Value

bool

Visibility 

XLWorksheetVisibility Visibility { get; set; }

Property Value

XLWorksheetVisibility

Workbook 

XLWorkbook Workbook { get; }

Property Value

XLWorkbook

Methods

AddPicture(Stream) 

IXLPicture AddPicture(Stream stream)

Parameters

stream Stream

Returns

IXLPicture

AddPicture(Stream, XLPictureFormat) 

IXLPicture AddPicture(Stream stream, XLPictureFormat format)

Parameters

stream Stream
format XLPictureFormat

Returns

IXLPicture

AddPicture(Stream, XLPictureFormat, string) 

IXLPicture AddPicture(Stream stream, XLPictureFormat format, string name)

Parameters

stream Stream
format XLPictureFormat
name string

Returns

IXLPicture

AddPicture(Stream, string) 

IXLPicture AddPicture(Stream stream, string name)

Parameters

stream Stream
name string

Returns

IXLPicture

AddPicture(Stream, string, int) 

IXLPicture AddPicture(Stream stream, string name, int Id)

Parameters

stream Stream
name string
Id int

Returns

IXLPicture

AddPicture(string) 

IXLPicture AddPicture(string imageFile)

Parameters

imageFile string

Returns

IXLPicture

AddPicture(string, string) 

IXLPicture AddPicture(string imageFile, string name)

Parameters

imageFile string
name string

Returns

IXLPicture

Cleanup() 

void Cleanup()

Delete()

Deletes this worksheet.

void Delete()

Hide() 

IXLSheet Hide()

Returns

IXLSheet

Picture(string) 

IXLPicture Picture(string pictureName)

Parameters

pictureName string

Returns

IXLPicture

SetTabActive() 

IXLSheet SetTabActive()

Returns

IXLSheet

SetTabActive(bool) 

IXLSheet SetTabActive(bool value)

Parameters

value bool

Returns

IXLSheet

SetTabSelected() 

IXLSheet SetTabSelected()

Returns

IXLSheet

SetTabSelected(bool) 

IXLSheet SetTabSelected(bool value)

Parameters

value bool

Returns

IXLSheet

Unhide() 

IXLSheet Unhide()

Returns

IXLSheet