Row Classe

Definição

[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

Herança

Object

OpenXmlElement

OpenXmlCompositeElement

Row

Herança

Object

OpenXmlElement

OpenXmlCompositeElement

TypedOpenXmlCompositeElement

Row

Atributos

ChildElementInfoAttribute OfficeAvailabilityAttribute SchemaAttrAttribute

Exemplos

O exemplo de código a seguir cria uma planilha de documentos, adiciona uma linha à tabela de células e escreve o número "123" na célula 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  

Comentários

[ISO/IEC 29500-1 1st Edition]

row (Row)

O elemento expressa informações sobre uma linha inteira de uma planilha e contém todas as definições de célula para uma linha específica na planilha.

[Exemplo:

Essa linha expressa informações sobre a linha da planilha e contém três definições de célula.

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

exemplo de término]

[Observação: a definição do esquema XML do W3C do modelo de conteúdo (CT_Row) desse elemento está localizada em §A.2. nota final]

ISO/IEC29500: 2008.