Get worksheet used range

The following example shows you how to get the used range of an Excel worksheet, which contains all non-empty cells.

C# example

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Independentsoft.Graph;
using Independentsoft.Graph.Workbooks;

namespace Sample
{
    class Program
    {
        static async Task Main(string[] args)
        {
            try
            {
                GraphClient client = new GraphClient();
                client.ClientId = "63333333-209e-454e-b7bd-55a4d201270f";
                client.Tenant = "independentsoft.onmicrosoft.com";
                client.ClientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

                Range range = await client.GetWorksheetUsedRange("workbook-drive-item-id-123", "worksheet-id-456");

                Console.WriteLine("Address = " + range.Address);
                Console.WriteLine("RowCount = " + range.RowCount);
                Console.WriteLine("ColumnCount = " + range.ColumnCount);

                Console.Read();
            }
            catch (GraphException ex)
            {
                Console.WriteLine("Error: " + ex.Code);
                Console.WriteLine("Message: " + ex.Message);
                Console.Read();
            }
        }
    }
}

VB example

Imports Independentsoft.Graph
Imports Independentsoft.Graph.Workbooks

Namespace Sample
    Class Module1
        Shared Sub Main(ByVal args As String())
            Dim task = New Task(AddressOf Run)
            task.Start()
            Console.Read()
        End Sub

        Shared Async Sub Run()
            Try
                Dim client As GraphClient = New GraphClient()
                client.ClientId = "63333333-209e-454e-b7bd-55a4d201270f"
                client.Tenant = "independentsoft.onmicrosoft.com"
                client.ClientSecret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"

                Dim range As Range = Await client.GetWorksheetUsedRange("workbook-drive-item-id-123", "worksheet-id-456")

                Console.WriteLine("Address = " & range.Address)
                Console.WriteLine("RowCount = " & range.RowCount)
                Console.WriteLine("ColumnCount = " & range.ColumnCount)

            Catch ex As GraphException
                Console.WriteLine("Error: " & ex.Code)
                Console.WriteLine("Error: " & ex.Message)
                Console.Read()
            End Try
        End Sub
    End Class
End Namespace

IndependentsoftProfessional software libraries for developers

Graph .NET > Tutorial > Get worksheet used range

Need help? Ask our developers: