Cell 类

定义

public class Cell : DocumentFormat.OpenXml.Spreadsheet.CellType

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
[DocumentFormat.OpenXml.SchemaAttr(22, "c")]
public class Cell : DocumentFormat.OpenXml.Spreadsheet.CellType

[DocumentFormat.OpenXml.SchemaAttr(22, "c")]
public class Cell : DocumentFormat.OpenXml.Spreadsheet.CellType

[DocumentFormat.OpenXml.SchemaAttr("x:c")]
public class Cell : DocumentFormat.OpenXml.Spreadsheet.CellType

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
public class Cell : DocumentFormat.OpenXml.Spreadsheet.CellType

type Cell = class
    inherit CellType

[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
[<DocumentFormat.OpenXml.SchemaAttr(22, "c")>]
type Cell = class
    inherit CellType

[<DocumentFormat.OpenXml.SchemaAttr(22, "c")>]
type Cell = class
    inherit CellType

[<DocumentFormat.OpenXml.SchemaAttr("x:c")>]
type Cell = class
    inherit CellType

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

Public Class Cell
Inherits CellType

继承

Object

OpenXmlElement

OpenXmlCompositeElement

CellType

Cell

继承

Object

OpenXmlElement

OpenXmlCompositeElement

TypedOpenXmlCompositeElement

CellType

Cell

属性

OfficeAvailabilityAttribute SchemaAttrAttribute

示例

下面的代码示例创建一个新工作簿，在工作簿中插入工作表，并在指定的单元格地址中写入单词“Microsoft”。

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

namespace CellEx  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            // Create a spreadsheet document by providing a file name.  
            string fileName = @"C:\Users\Public\Documents\myCellEx.xlsx";  

            SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.  
                Create(fileName, SpreadsheetDocumentType.Workbook);  

            // Add a WorkbookPart to the document.  
            WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();  
            workbookpart.Workbook = new Workbook();  

            // Add a WorksheetPart to the WorkbookPart.  
            WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>();  
            worksheetPart.Worksheet = new Worksheet(new SheetData());  

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

            // Append a new worksheet and associate it with the workbook.  
            Sheet sheet = new Sheet()  
            {   Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart),  
                SheetId = 1, Name = "mySheet"  
            };  
            sheets.Append(sheet);  
            Worksheet worksheet = new Worksheet();  
            SheetData sheetData = new SheetData();  
            Row row = new Row();  
            Cell cell = new Cell()   
                { CellReference = "A1", DataType = CellValues.String,  
                    CellValue = new CellValue("Microsoft") };  
            row.Append(cell);  
            sheetData.Append(row);  
            worksheet.Append(sheetData);  
            worksheetPart.Worksheet = worksheet;  

            // Close the document.  
            spreadsheetDocument.Close();  
            Console.WriteLine("All done. Press any key.");  
            Console.ReadKey();  
        }  
    }       
}  

Imports DocumentFormat.OpenXml  
Imports DocumentFormat.OpenXml.Packaging  
Imports DocumentFormat.OpenXml.Spreadsheet  
Module Module1  
    Sub Main()  
        ' Create a spreadsheet document by providing a file name.  
        Dim fileName As String = "C:\Users\Public\Documents\myCellEx.xlsx"  

        Dim spreadsheetDocument As SpreadsheetDocument = _  
            spreadsheetDocument.Create(fileName, SpreadsheetDocumentType.Workbook)  

        ' Add a WorkbookPart to the document.  
        Dim workbookpart As WorkbookPart = spreadsheetDocument.AddWorkbookPart()  
        workbookpart.Workbook = New Workbook()  

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

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

        ' Append a new worksheet and associate it with the workbook.  
        Dim sheet As New Sheet() With { _  
         .Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), _  
         .SheetId = 1, .Name = "mySheet"}  
        sheets.Append(Sheet)  
        Dim worksheet As New Worksheet()  
        Dim sheetData As New SheetData()  
        Dim row As New Row()  
        Dim cell As New Cell() With {.CellReference = "A1", .DataType = CellValues.[String], _  
         .CellValue = New CellValue("Microsoft")}  
        row.Append(Cell)  
        sheetData.Append(row)  
        worksheet.Append(sheetData)  
        worksheetPart.Worksheet = worksheet  

        ' Close the document.  
        spreadsheetDocument.Close()  
        Console.WriteLine("All done. Press any key.")  
        Console.ReadKey()  
    End Sub  
End Module  

注解

[ISO/IEC 29500-1 第 1 版]

c (单元格)

此集合表示工作表中的单元格。 此处表示了有关单元格的位置（引用）、值、数据类型、格式设置和公式的信息。

[示例：此示例显示网格中地址为 C6、样式索引为“6”且值元数据索引为“15”的单元格存储的信息。 该单元格包含公式和该公式的已计算结果。

<c r="C6" s="1" vm="15">  
  <f>CUBEVALUE("xlextdat9 Adventure Works",C$5,$A6)</f>  
  <v>2838512.355</v>  
</c>  

示例结束]

虽然单元格可以具有公式元素 f 和值元素 v，但当单元格的类型 t 为 inlineStr 时，仅允许该元素作为子元素。

[示例：

下面是在单元格中表达字符串而不是使用共享字符串表的示例。

<row r="1" spans="1:1">  
  <c r="A1" t="inlineStr">  
    <is><t>This is inline string example</t></is>  
  </c>  
</row>  

示例结束]

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

ISO/IEC29500：2008。