SheetData.LocalName Свойство

Определение

Пространство имен:

DocumentFormat.OpenXml.Spreadsheet

Сборка:

DocumentFormat.OpenXml.dll

Сборка:

DocumentFormat.OpenXml.dll

Возвращает локальное имя элемента.

public override string LocalName { get; }

member this.LocalName : string

Public Overrides ReadOnly Property LocalName As String

Значение свойства

String

Возвращает .String

Примеры

В следующем примере создается документ электронной таблицы, добавляется книга, а также лист с именем mySheet.

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

namespace SheetDataEx  
{  
    class Program  
    {  
        // Create a spreadsheet, and and a sheet into it.  
        static void Main(string[] args)  
        {  
            string fileName = @"C:\Users\Public\Documents\SheetDataEx.xlsx";  

           // Create a spreadsheet document by using the file path.  
           SpreadsheetDocument spreadsheetDocument =  
                SpreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook);  

           // Add a WorkbookPart and Workbook objects.  
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();  
            workbookpart.Workbook = new Workbook();  

            // Add a WorksheetPart.  
            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();  

            // Create Worksheet and SheetData objects.  
            worksheetPart.Worksheet = new Worksheet(new SheetData());  

            // Add a Sheets object.  
            Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook  
                .AppendChild<Sheets>(new Sheets());  

            // Append the new worksheet named "mySheet" and associate it   
            // with the workbook.  
            Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart  
                .GetIdOfPart(worksheetPart), SheetId = 1, Name = "mySheet" };  
            sheets.Append(sheet);  

            // Close the file.  
            spreadsheetDocument.Close();  

            Console.WriteLine("The Spreadsheet file is created. Press a key");  
            Console.ReadKey();  
        }  
    }  
}  

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

Module Module1  

    Sub Main()  
        Dim fileName As String = "C:\Users\Public\Documents\SheetDataEx.xlsx"  

        ' Create a spreadsheet document by using the file path.  
        Dim spreadsheetDocument As SpreadsheetDocument = _  
            spreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook)  

        ' Add a WorkbookPart and Workbook objects.  
        Dim workbookpart As WorkbookPart = spreadsheetDocument.AddWorkbookPart()  
        workbookpart.Workbook = New Workbook()  

        ' Add a WorksheetPart.  
        Dim worksheetPart As WorksheetPart = workbookpart.AddNewPart(Of WorksheetPart)()  
        worksheetPart.Worksheet = New Worksheet(New SheetData())  

        ' Create Worksheet and SheetData objects.  
        worksheetPart.Worksheet = New Worksheet(New SheetData())  

        ' Add a Sheets object.  
        Dim sheets As Sheets = spreadsheetDocument.WorkbookPart.Workbook _  
        .AppendChild(Of Sheets)(New Sheets())  

        ' Append the new worksheet named "mySheet" and associate it   
        ' with the workbook.  
        Dim sheet As New Sheet() With { _  
         .Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), _  
         .SheetId = 1, .Name = "mySheet"}  

        sheets.Append(sheet)  

        ' Close the file.  
        spreadsheetDocument.Close()  

        Console.WriteLine("The Spreadsheet file is created. Press a key")  
        Console.ReadKey()  
    End Sub 'Main  
End Module