使用PHP从URL下载.xlsx文件

发布于 2025-01-31 20:16:54 字数 360 浏览 2 评论 0原文

我使用PHP从URL上下载Excel文件的问题。该文件可在Microsoft SharePoint服务器上公开访问，并在直接通过链接访问时自动下载。这是我的代码：

$url = 'https://example.sharepoint.com/somefile.xlsx?download=1';
$file = file_put_contents('template.xlsx', file_get_contents($url));

脚本成功地创建了服务器上的template.xlsx文件，但是文件本身为0字节，当我尝试打开它时，我会沿着“ excel无法打开文件”的行会出现错误，因为文件格式是因为文件格式或文件扩展名无效”。我想念什么？

原文

I'm having issues downloading an excel file onto my web server from a URL using PHP. The file is publicly accessible on a Microsoft Sharepoint server and downloads automatically when accessed directly via the link. Here is my code:

$url = 'https://example.sharepoint.com/somefile.xlsx?download=1';
$file = file_put_contents('template.xlsx', file_get_contents($url));

The script successfully creates the template.xlsx file on the server, however the file itself is 0 bytes and when I try to open it I get an error along the lines of "Excel cannot open the file because the file format or file extension is invalid". What am I missing?

分享到QQ

分享到微博