CellValue 类

定义

public class CellValue : DocumentFormat.OpenXml.Spreadsheet.XstringType

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
[DocumentFormat.OpenXml.SchemaAttr(22, "v")]
public class CellValue : DocumentFormat.OpenXml.Spreadsheet.XstringType

[DocumentFormat.OpenXml.SchemaAttr(22, "v")]
public class CellValue : DocumentFormat.OpenXml.Spreadsheet.XstringType

[DocumentFormat.OpenXml.SchemaAttr("x:v")]
public class CellValue : DocumentFormat.OpenXml.Spreadsheet.XstringType

[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
public class CellValue : DocumentFormat.OpenXml.Spreadsheet.XstringType

type CellValue = class
    inherit XstringType

[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
[<DocumentFormat.OpenXml.SchemaAttr(22, "v")>]
type CellValue = class
    inherit XstringType

[<DocumentFormat.OpenXml.SchemaAttr(22, "v")>]
type CellValue = class
    inherit XstringType

[<DocumentFormat.OpenXml.SchemaAttr("x:v")>]
type CellValue = class
    inherit XstringType

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

Public Class CellValue
Inherits XstringType

继承

Object

OpenXmlElement

OpenXmlLeafElement

OpenXmlLeafTextElement

XstringType

CellValue

继承

Object

OpenXmlElement

OpenXmlLeafElement

OpenXmlLeafTextElement

TypedOpenXmlLeafTextElement

XstringType

CellValue

属性

OfficeAvailabilityAttribute SchemaAttrAttribute

示例

下面的代码示例创建名为“CellValue.xlsx”的电子表格文件，并在单元格 A2 中写入文本“Microsoft”。

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

namespace CellTypeEx  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            string fileName = @"C:\Users\Public\Documents\CellValueEx.xlsx";  

            // Create a spreadsheet document by supplying the fileName.  
            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() { RowIndex = 2U, Spans = new ListValue<StringValue>() };  
            Cell cell = new Cell()  
            {  
                CellReference = "A2",  
                DataType = CellValues.String,  
                CellValue = new CellValue("Microsoft")  
            };  

            row.Append(cell);  
            sheetData.Append(row);  
            worksheet.Append(sheetData);  
            worksheetPart.Worksheet = worksheet;  
            workbookpart.Workbook.Save();  

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

            Console.WriteLine("All done.\nPress a key.");  
            Console.ReadKey();  
        }  
    }  
}  

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

Module Module1  
    Sub Main(ByVal args As String())  
        Dim fileName As String = "C:\Users\Public\Documents\CellValueEx.xlsx"  

        ' Create a spreadsheet document by supplying the fileName.  
        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() With { _  
         .RowIndex = 2UI, _  
         .Spans = New ListValue(Of StringValue)() _  
        }  
        Dim cell As New Cell() With { _  
         .CellReference = "A2", _  
         .DataType = CellValues.[String], _  
         .CellValue = New CellValue("Microsoft") _  
        }  

        row.Append(cell)  
        sheetData.Append(row)  
        worksheet.Append(sheetData)  
        worksheetPart.Worksheet = worksheet  
        workbookpart.Workbook.Save()  

        ' Close the document.  
        spreadsheetDocument.Close()  

        Console.WriteLine("All done." & vbLf & "Press a key.")  
        Console.ReadKey()  
    End Sub  
End Module  

注解

[ISO/IEC 29500-1 第 1 版]

v (单元格值)

此元素表示单元格中包含的值。 如果单元格包含字符串，则此值为共享字符串表中的索引，指向实际字符串值。 否则，该单元格的值会在此元素中直接表示。 包含公式的单元格表示此元素中的公式的最后一次计算结果。

对于不希望实现共享字符串表的应用程序，可以使用 c (下的 <is><元素而不是 c>>) <下的 <v> 元素来表示“内联字符串”，其方式与在共享字符串表中表示字符串的方式相同。 [注意：请参阅 <示例> 。 注释结束]

[示例：在此示例中，单元格 B4 包含数字“360”，C4 包含 UTC 日期 1976 年 11 月 22 日 08：30。

<c r="B4">  
  <v>360</v>  
</c>  
<c r="C4" t="d">  
  <v>1976-11-22T08:30Z</v>  
</c>  

示例结束]

此元素的可能值由 ST_Xstring 简单类型 (§22.9.2.19) 定义。

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

ISO/IEC29500：2008。