Create worksheet

The following example shows you how to add a new worksheet to an Excel workbook.

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

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");

            Worksheet worksheet = client.createWorksheet("workbook-drive-item-id-123", "NewSheet");

            System.out.println("Id: " + worksheet.getId());
            System.out.println("Name: " + worksheet.getName());
        }
        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 > Create worksheet

Need help? Ask our developers: