使用Java在Sharepoint中读取Excel文件

Question

我在Sharepoint上有一个带有读取权限的Excel文件，我需要使用Java读取/下载它。以下代码示例会出现403禁止错误。请帮助我解决这个问题。

 CredentialsProvider credsProvider = new BasicCredentialsProvider();
        credsProvider.setCredentials(
                new AuthScope(AuthScope.ANY),
                new NTCredentials("username", "password", "https://abc-my.sharepoint.com", "abc"));
        CloseableHttpClient httpclient = HttpClients.custom()
                .setDefaultCredentialsProvider(credsProvider)
                .build();
        try {
            HttpGet httpget = new HttpGet("https://abc-my.sharepoint.com/:x:/r/personal/_layouts/15/Doc.aspx?sourcedoc=%dedededed-9889-098-AAAA-wbxcdssj%7D&file=my_excel.xlsx");


            CloseableHttpResponse response = httpclient.execute(httpget);
            try {

                EntityUtils.consume(response.getEntity());
            } finally {
                response.close();
            }
        } finally {
            httpclient.close();
        }

- Udesh Sendanayake

Answer 1

您可以参考以下博客来在Java代码中验证请求：Java-service integration with SharePoint Online via REST API。

或者您可以使用Microsoft Graph API读取Excel文件并使用SharePoint App-Only授权访问。了解更多。 Microsoft Graph Auth Preview SDK for Java
如何在Excel SharePoint文件中读取元数据（JSON）。

- Amos