Get worksheets

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

C++ example

#include <iostream>
#include <vector>

#include "independentsoft/graph/graph_client.hpp"
#include "independentsoft/graph/graph_exception.hpp"
#include "independentsoft/graph/enum_util.hpp"
#include "independentsoft/graph/workbooks/worksheet.hpp"
#include "independentsoft/graph/files/drive_id.hpp"

using namespace independentsoft::graph;
using namespace independentsoft::graph::workbooks;
using namespace independentsoft::graph::files;

int main()
{
    try
    {
        GraphClient client;

        client.client_id = "63333333-209e-454e-b7bd-55a4d201270f";
        client.tenant = "independentsoft.onmicrosoft.com";
        client.client_secret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

        std::vector<Worksheet> worksheets = sync_wait(client.get_worksheets("workbook-drive-item-id", DriveId("b!T7ZW_FMzJ02x_G6HteZHZ")));

        for (std::size_t i = 0; i < worksheets.size(); i++)
        {
            std::cout << "Name = " << worksheets[i].name << std::endl;
            std::cout << "Id = " << worksheets[i].id << std::endl;
            std::cout << "Visibility = " << enum_util::to_string(worksheets[i].visibility) << std::endl;
            std::cout << "" << std::endl;
        }
    }
    catch (const GraphException& ex)
    {
        std::cout << "Error: " << ex.code << std::endl;
        std::cout << "Message: " << ex.message << std::endl;
    }

    return 0;
}

IndependentsoftProfessional software libraries for developers

Graph C++ > Tutorial > Get worksheets

Need help? Ask our developers: