Sheet 类

定义

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
[DocumentFormat.OpenXml.SchemaAttr(22, "sheet")]
public class Sheet : DocumentFormat.OpenXml.OpenXmlLeafElement

public class Sheet : DocumentFormat.OpenXml.OpenXmlLeafElement

[DocumentFormat.OpenXml.SchemaAttr(22, "sheet")]
public class Sheet : DocumentFormat.OpenXml.OpenXmlLeafElement

[DocumentFormat.OpenXml.SchemaAttr("x:sheet")]
public class Sheet : DocumentFormat.OpenXml.OpenXmlLeafElement

[DocumentFormat.OpenXml.SchemaAttr("x:sheet")]
public class Sheet : DocumentFormat.OpenXml.TypedOpenXmlLeafElement

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
public class Sheet : DocumentFormat.OpenXml.OpenXmlLeafElement

[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
[<DocumentFormat.OpenXml.SchemaAttr(22, "sheet")>]
type Sheet = class
    inherit OpenXmlLeafElement

type Sheet = class
    inherit OpenXmlLeafElement

[<DocumentFormat.OpenXml.SchemaAttr(22, "sheet")>]
type Sheet = class
    inherit OpenXmlLeafElement

[<DocumentFormat.OpenXml.SchemaAttr("x:sheet")>]
type Sheet = class
    inherit OpenXmlLeafElement

[<DocumentFormat.OpenXml.SchemaAttr("x:sheet")>]
type Sheet = class
    inherit TypedOpenXmlLeafElement

[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
type Sheet = class
    inherit OpenXmlLeafElement

Public Class Sheet
Inherits OpenXmlLeafElement

Public Class Sheet
Inherits TypedOpenXmlLeafElement

继承

Object

OpenXmlElement

OpenXmlLeafElement

Sheet

继承

Object

OpenXmlElement

OpenXmlLeafElement

TypedOpenXmlLeafElement

Sheet

属性

OfficeAvailabilityAttribute SchemaAttrAttribute

示例

下面的代码示例在现有电子表格文档的工作簿中插入一个新工作表。

using System;  
using System.Linq;  
using DocumentFormat.OpenXml.Packaging;  
using DocumentFormat.OpenXml.Spreadsheet;  

namespace SheetEx  
{  
    class Program  
    {  
        // Insert a new worksheet in a spreadsheet document.  
        static void Main(string[] args)  
        {  
            string document = @"C:\users\public\documents\SheetsEx.xlsx";  

            // Open the document for editing.  
            using (SpreadsheetDocument spreadsheetDocument  
                = SpreadsheetDocument.Open(document, true))  
            {  
                // Add a blank WorksheetPart.  
                WorksheetPart newWorksheetPart =   
                    spreadsheetDocument.WorkbookPart.AddNewPart<WorksheetPart>();  
                newWorksheetPart.Worksheet = new Worksheet(new SheetData());  

                Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook  
                    .GetFirstChild<Sheets>();  
                string relationshipId = spreadsheetDocument.WorkbookPart  
                    .GetIdOfPart(newWorksheetPart);  

                // Get a unique ID for the new worksheet.  
                uint sheetId = 1;  
                if (sheets.Elements<Sheet>().Count() > 0)  
                   sheetId = sheets.Elements<Sheet>().Select(s => s.SheetId.Value).Max() + 1;  

                // Give the new worksheet a name.  
                string sheetName = "mySheet" + sheetId;  

                // Append the new worksheet and associate it with the workbook.  
                Sheet sheet = new Sheet() { Id = relationshipId, SheetId = sheetId,  
                    Name = sheetName };  
                sheets.Append(sheet);  

                Console.WriteLine("A new sheet has been inserted into the workbook.\nPress a key.");  
                Console.ReadKey();  
            }  
        }  
    }  
}  

Imports System.Linq  
Imports DocumentFormat.OpenXml.Packaging  
Imports DocumentFormat.OpenXml.Spreadsheet  

Module Module1  
    ' Insert a new worksheet in a spreadsheet document.  
    Sub Main(ByVal args As String())  
        Dim document As String = "C:\users\public\documents\SheetsEx.xlsx"  

        ' Open the document for editing.  
        Using spreadsheetDocument As SpreadsheetDocument = _  
            spreadsheetDocument.Open(document, True)  
            ' Add a blank WorksheetPart.  
            Dim newWorksheetPart As WorksheetPart = _  
                spreadsheetDocument.WorkbookPart.AddNewPart(Of WorksheetPart)()  
            newWorksheetPart.Worksheet = New Worksheet(New SheetData())  

            Dim sheets As Sheets = _  
                spreadsheetDocument.WorkbookPart.Workbook.GetFirstChild(Of Sheets)()  
            Dim relationshipId As String = _  
                spreadsheetDocument.WorkbookPart.GetIdOfPart(newWorksheetPart)  

            ' Get a unique ID for the new worksheet.  
            Dim sheetId As UInteger = 1  
            If sheets.Elements(Of Sheet)().Count() > 0 Then  
                sheetId = sheets.Elements(Of Sheet)().[Select](Function(s) _  
                           s.SheetId.Value).Max() + 1  
            End If  

            ' Give the new worksheet a name.  
            Dim sheetName As String = "mySheet" & sheetId  

            ' Append the new worksheet and associate it with the workbook.  
            Dim sheet As New Sheet() With { _  
             .Id = relationshipId, _  
             .SheetId = sheetId, _  
             .Name = sheetName _  
            }  
            sheets.Append(sheet)  

            Console.WriteLine("A new sheet has been inserted into the workbook." _  
                              & vbLf & "Press a key.")  
            Console.ReadKey()  
        End Using  
    End Sub  
End Module  

注解

[ISO/IEC 29500-1 第 1 版]

工作表 (工作表信息)

此元素定义此工作簿中的工作表。 工作表数据存储在单独的部件中。

[注意：此元素的内容模型 (CT_Sheet) 的 W3C XML 架构定义位于 §A.2 中。 注释结束]

ISO/IEC29500：2008。