Row Classe

Définition

[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

Héritage

Object

OpenXmlElement

OpenXmlCompositeElement

Row

Héritage

Object

OpenXmlElement

OpenXmlCompositeElement

TypedOpenXmlCompositeElement

Row

Attributs

ChildElementInfoAttribute OfficeAvailabilityAttribute SchemaAttrAttribute

Exemples

L’exemple de code suivant crée des documents de feuille de calcul, ajoute une ligne à la table de cellules et écrit le nombre « 123 » dans la cellule 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  

Remarques

[ISO/IEC 29500-1 1st Edition]

row (Row)

L’élément exprime des informations sur une ligne entière d’une feuille de calcul et contient toutes les définitions de cellule d’une ligne particulière dans la feuille de calcul.

[Exemple :

Cette ligne exprime des informations sur la ligne de la feuille de calcul et contient 3 définitions de cellules.

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

Fin de l’exemple]

[Remarque : La définition de schéma XML W3C du modèle de contenu de cet élément (CT_Row) se trouve dans §A.2. Fin de la remarque]

ISO/IEC29500 : 2008.

Constructeurs

Propriétés

Méthodes

Implémentations d’interfaces explicites

S’applique à