Row Class

Definition

[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))]
[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
[DocumentFormat.OpenXml.SchemaAttr(22, "row")]
public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

[DocumentFormat.OpenXml.SchemaAttr(22, "row")]
public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

[DocumentFormat.OpenXml.SchemaAttr("x:row")]
public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

[DocumentFormat.OpenXml.SchemaAttr("x:row")]
public class Row : DocumentFormat.OpenXml.TypedOpenXmlCompositeElement

[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))]
public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))]
[DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))]
[DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)]
public class Row : DocumentFormat.OpenXml.OpenXmlCompositeElement

[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))>]
[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
[<DocumentFormat.OpenXml.SchemaAttr(22, "row")>]
type Row = class
    inherit OpenXmlCompositeElement

type Row = class
    inherit OpenXmlCompositeElement

[<DocumentFormat.OpenXml.SchemaAttr(22, "row")>]
type Row = class
    inherit OpenXmlCompositeElement

[<DocumentFormat.OpenXml.SchemaAttr("x:row")>]
type Row = class
    inherit OpenXmlCompositeElement

[<DocumentFormat.OpenXml.SchemaAttr("x:row")>]
type Row = class
    inherit TypedOpenXmlCompositeElement

[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))>]
type Row = class
    inherit OpenXmlCompositeElement

[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.Cell))>]
[<DocumentFormat.OpenXml.ChildElementInfo(typeof(DocumentFormat.OpenXml.Spreadsheet.ExtensionList))>]
[<DocumentFormat.OpenXml.OfficeAvailability(DocumentFormat.OpenXml.FileFormatVersions.Office2007)>]
type Row = class
    inherit OpenXmlCompositeElement

Public Class Row
Inherits OpenXmlCompositeElement

Public Class Row
Inherits TypedOpenXmlCompositeElement

Inheritance

Object

OpenXmlElement

OpenXmlCompositeElement

Row

Inheritance

Object

OpenXmlElement

OpenXmlCompositeElement

TypedOpenXmlCompositeElement

Row

Attributes

ChildElementInfoAttribute OfficeAvailabilityAttribute SchemaAttrAttribute

Examples

The following code example creates a spreadsheet documents, adds a row to the cell table, and writes the number "123" in the cell A1.

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

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

            // Create a spreadsheet document by using the file name.  
            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);  

            // Get the sheetData cell table.  
            SheetData sheetData = worksheetPart.Worksheet.GetFirstChild<SheetData>();  

            // Add a row to the cell table.  
            Row row;  
            row = new Row() { RowIndex = 1 };  
            sheetData.Append(row);  

            // Add the cell to the cell table at A1.  
            Cell refCell = null;  
            Cell newCell = new Cell() { CellReference = "A1" };  
            row.InsertBefore(newCell, refCell);  

            // Set the cell value to be a numeric value of 123.  
            newCell.CellValue = new CellValue("123");  
            newCell.DataType = new EnumValue<CellValues>(CellValues.Number);  

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

            Console.WriteLine("All done. Press 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\RowEx.xlsx"  

        ' Create a spreadsheet document by using the file name.  
        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)()  

        ' 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)  

        ' Get the sheetData cell table.  
        Dim sheetData As SheetData = _  
            worksheetPart.Worksheet.GetFirstChild(Of SheetData)()  

        ' Add a row to the cell table.  
        Dim row As Row  
        row = New Row() With { _  
         .RowIndex = 1 _  
        }  
        sheetData.Append(row)  

        ' Add the cell to the cell table at A1.  
        Dim refCell As Cell = Nothing  
        Dim newCell As New Cell() With { _  
         .CellReference = "A1" _  
        }  
        row.InsertBefore(newCell, refCell)  

        ' Set the cell value to be a numeric value of 123.  
        newCell.CellValue = New CellValue("123")  
        newCell.DataType = New EnumValue(Of CellValues)(CellValues.Number)  

        ' Close the document.  
        spreadsheetDocument.Close()  

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

Remarks

[ISO/IEC 29500-1 1st Edition]

row (Row)

The element expresses information about an entire row of a worksheet, and contains all cell definitions for a particular row in the worksheet.

[Example:

This row expresses information about row the worksheet, and contains 3 cell definitions.

<row r="2" spans="2:12">  
  <c r="C2" s="1">  
    <f>PMT(B3/12,B4,-B5)</f>  
    <v>672.68336574300008</v>  
  </c>  
  <c r="D2">  
    <v>180</v>  
  </c>  
  <c r="E2">  
    <v>360</v>  
  </c>  
</row>  

end example]

[Note: The W3C XML Schema definition of this element’s content model (CT_Row) is located in §A.2. end note]

� ISO/IEC29500: 2008.

Constructors

Properties

Methods

Explicit Interface Implementations

Applies to