XLSX: Work with worksheets in XLSX document

In This Topic

SpreadsheetEditorControl and WpfSpreadsheetEditorControl controls allow to work (view, add, rename, move, delete) with worksheets of XLSX document in desktop (WinForms, WPF) application.
Worksheets can be changed programmatically.

Add new worksheet to an XLSX document

Here is C#/VB.NET code that demonstrates how to add the new worksheet to XLSX document:

public void AddWorksheetToXlsxDocument(Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl editorControl)
{
    // get visual editor for spreadsheet document
    Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor spreadsheetVisualEditor = editorControl.VisualEditor;

    // add new worksheet after focused worksheet
    spreadsheetVisualEditor.AddWorksheet();
}

VB.NET

Public Sub AddWorksheetToXlsxDocument(editorControl As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl)
    ' get visual editor for spreadsheet document
    Dim spreadsheetVisualEditor As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor = editorControl.VisualEditor

    ' add new worksheet after focused worksheet
    spreadsheetVisualEditor.AddWorksheet()
End Sub

Copy an existing worksheet into XLSX document

Here is C#/VB.NET code that demonstrates how to copy an existing worksheet into XLSX document:

public void CopyWorksheetInXlsxDocument(Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl editorControl)
{
    // get visual editor for spreadsheet document
    Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor spreadsheetVisualEditor = editorControl.VisualEditor;

    // create copy of focused worksheet and paste created copy after focused worksheet
    spreadsheetVisualEditor.CopyWorksheet();
}

VB.NET

Public Sub CopyWorksheetInXlsxDocument(editorControl As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl)
    ' get visual editor for spreadsheet document
    Dim spreadsheetVisualEditor As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor = editorControl.VisualEditor

    ' create copy of focused worksheet and paste created copy after focused worksheet
    spreadsheetVisualEditor.CopyWorksheet()
End Sub

Rename an existing worksheet of XLSX document

Here is C#/VB.NET code that demonstrates how to rename an existing worksheet of XLSX document:

public void RenameWorksheetInXlsxDocument(Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl editorControl)
{
    // get visual editor for spreadsheet document
    Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor spreadsheetVisualEditor = editorControl.VisualEditor;

    // rename the focused worksheet
    spreadsheetVisualEditor.RenameWorksheet("NewWorksheetName");
}

VB.NET

Public Sub RenameWorksheetInXlsxDocument(editorControl As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl)
    ' get visual editor for spreadsheet document
    Dim spreadsheetVisualEditor As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor = editorControl.VisualEditor

    ' rename the focused worksheet
    spreadsheetVisualEditor.RenameWorksheet("NewWorksheetName")
End Sub

Move an existing worksheet of XLSX document

Here is C#/VB.NET code that demonstrates how to move the first worksheet to the third place in XLSX document with three worksheets:

public void MoveWorksheetInXlsxDocument(Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl editorControl)
{
    // get visual editor for spreadsheet document
    Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor spreadsheetVisualEditor = editorControl.VisualEditor;

    // move the first worksheet to the third place
    spreadsheetVisualEditor.MoveWorksheet(0, 2);
}

VB.NET

Public Sub MoveWorksheetInXlsxDocument(editorControl As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl)
    ' get visual editor for spreadsheet document
    Dim spreadsheetVisualEditor As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor = editorControl.VisualEditor

    ' move the first worksheet to the third place
    spreadsheetVisualEditor.MoveWorksheet(0, 2)
End Sub

Delete an existing worksheet from XLSX document

Here is C#/VB.NET code that demonstrates how to delete an existing worksheet from XLSX document:

public void DeleteWorksheetInXlsxDocument(Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl editorControl)
{
    // get visual editor for spreadsheet document
    Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor spreadsheetVisualEditor = editorControl.VisualEditor;

    // remove the focused worksheet
    spreadsheetVisualEditor.RemoveWorksheet();
}

VB.NET

Public Sub DeleteWorksheetInXlsxDocument(editorControl As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetEditorControl)
    ' get visual editor for spreadsheet document
    Dim spreadsheetVisualEditor As Vintasoft.Imaging.Office.Spreadsheet.UI.SpreadsheetVisualEditor = editorControl.VisualEditor

    ' remove the focused worksheet
    spreadsheetVisualEditor.RemoveWorksheet()
End Sub

Send Feedback