Get worksheets

The following example shows you how to get worksheets from an Excel workbook.

C# example

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Independentsoft.Graph;
using Independentsoft.Graph.Files;
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";

                IList<Worksheet> worksheets = await client.GetWorksheets("workbook-drive-item-id", new DriveId("b!T7ZW_FMzJ02x_G6HteZHZ"));

                for (int i = 0; i < worksheets.Count; i++)
                {
                    Console.WriteLine("Name = " + worksheets[i].Name);
                    Console.WriteLine("Id = " + worksheets[i].Id);
                    Console.WriteLine("Visibility = " + worksheets[i].Visibility);
                    Console.WriteLine("");
                }

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

VB example

Imports System.Collections.Generic
Imports Independentsoft.Graph
Imports Independentsoft.Graph.Files
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 worksheets As IList(Of Worksheet) = Await client.GetWorksheets("workbook-drive-item-id", New DriveId("b!T7ZW_FMzJ02x_G6HteZHZ"))

                For i As Integer = 0 To worksheets.Count - 1
                    Console.WriteLine("Name = " & worksheets(i).Name)
                    Console.WriteLine("Id = " & worksheets(i).Id)
                    Console.WriteLine("Visibility = " & worksheets(i).Visibility.ToString())
                    Console.WriteLine("")
                Next

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

    End Class
End Namespace

IndependentsoftAny library, any programming language

Graph .NET > Tutorial > Get worksheets

Need help? Ask our developers: