Get worksheet cell

The following example shows you how to retrieve the value of a specific cell in an Excel worksheet.

import com.independentsoft.graph.GraphClient;
import com.independentsoft.graph.GraphException;
import com.independentsoft.graph.workbooks.Cell;

public class Console {

    public static void main(String[] args)
    {
        try
        {
            GraphClient client = new GraphClient();

            client.setClientId("63333333-209e-454e-b7bd-55a4d201270f");
            client.setTenant("independentsoft.onmicrosoft.com");
            client.setUsername("info@independentsoft.onmicrosoft.com");
            client.setPassword("password");

            Cell cell = client.getWorksheetCell("workbook-drive-item-id-123", "worksheet-id-456", 0, 0);

            System.out.println("Address: " + cell.getAddress());
            System.out.println("Value: " + cell.getValue());
            System.out.println("Formula: " + cell.getFormula());
        }
        catch (GraphException e)
        {
            System.out.println(e.getCode());
            System.out.println(e.getMessage());

            e.printStackTrace();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JGraph > Tutorial > Get worksheet cell

Need help? Ask our developers: