C# Класс Smrf.AppLib.ExcelActiveWorksheetRestorer

Saves and restores the active worksheet of an Excel workbook.
Writing to a worksheet that isn't active causes problems with the selection in Excel. To avoid such problems, use this class to activate the worksheet that needs to be written to and then restore the original active worksheet when you're done writing. The activations are done with Excel's screen updating turned off, so they are not visible to the user.

Call ActivateWorksheet to activate the worksheet that needs to be written to. Call Restore when you're done writing.

If you activate a worksheet by other means but still want to use this class to save and restore the original active worksheet, call to save the active worksheet state and call Restore when you're done writing.

Наследование: Object
Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство Тип Описание
m_oWorkbook Workbook

Открытые методы

Метод Описание
ActivateWorksheet ( Worksheet worksheet ) : ExcelActiveWorksheetState
ExcelActiveWorksheetRestorer ( Microsoft workbook ) : System

Initializes a new instance of the class.
GetActiveWorksheetState ( ) : ExcelActiveWorksheetState
Restore ( ExcelActiveWorksheetState excelActiveWorksheetState ) : void

Приватные методы

Метод Описание
AssertValid ( ) : void

Описание методов

ActivateWorksheet() публичный Метод

public ActivateWorksheet ( Worksheet worksheet ) : ExcelActiveWorksheetState
worksheet Worksheet
Результат ExcelActiveWorksheetState

ExcelActiveWorksheetRestorer() публичный Метод

Initializes a new instance of the class.
public ExcelActiveWorksheetRestorer ( Microsoft workbook ) : System
workbook Microsoft /// Workbook containing the worksheet that will be activated. ///
Результат System

GetActiveWorksheetState() публичный Метод

public GetActiveWorksheetState ( ) : ExcelActiveWorksheetState
Результат ExcelActiveWorksheetState

Restore() публичный Метод

public Restore ( ExcelActiveWorksheetState excelActiveWorksheetState ) : void
excelActiveWorksheetState ExcelActiveWorksheetState
Результат void

Описание свойств

m_oWorkbook защищенное свойство

protected Workbook m_oWorkbook
Результат Workbook