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

#include <iostream>

#include "independentsoft/graph/graph_client.hpp"
#include "independentsoft/graph/graph_exception.hpp"
#include "independentsoft/graph/workbooks/range.hpp"

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

int main()
{
    try
    {
        GraphClient client;
        client.client_id = "63333333-209e-454e-b7bd-55a4d201270f";
        client.tenant = "independentsoft.onmicrosoft.com";
        client.client_secret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";

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

        std::cout << "Address = " << range.address << std::endl;
        std::cout << "RowCount = " << range.row_count << std::endl;
        std::cout << "ColumnCount = " << range.column_count << 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 worksheet used range

Need help? Ask our developers: