Exemplos de Xcl.Range em C# (CSharp)

Exemplo n.º 1

    public Xcl.Range GetDestinationRange(Worksheet sheet)
    {
        var    lastRow = dh.GetLastRow(sheet);
        string range   = "A" + ((lastRow + 1) + ":A" + (lastRow + 3));

        Xcl.Range rng = sheet.Range[range];
        return(rng);
    }

Exemplo n.º 2

    public Xcl.Range GetDestinationRange(Worksheet sheet)
    {
        DataHandler dh    = new DataHandler();
        string      range = "A" + ((dh.GetLastRow(sheet) + 1) + ":A" + (dh.GetLastRow(sheet) + 3));

        Xcl.Range rng = sheet.Range[range];
        return(rng);
    }