从Azure Blob存储下载CSV到浏览器

Question

我可以成功地上传到Azure Blob存储，但我在下载文件（csv和pdf文件）时遇到了问题。

我的目标是将文件下载到浏览器（因为这将是一个web应用程序，我不知道下载文件的本地路径）。

        string connString = ConfigurationManager.ConnectionStrings["MyTestStorageAccount"].ConnectionString;
        CloudStorageAccount cloudStorageAccount = CloudStorageAccount.Parse(connString);
        CloudBlobClient _blobClient = cloudStorageAccount.CreateCloudBlobClient();
        CloudBlobContainer _cloudBlobContainer = _blobClient.GetContainerReference("filestorage");
        CloudBlockBlob _blockBlob = _cloudBlobContainer.GetBlockBlobReference("testfile.csv");
        Response.AddHeader("Content-Disposition", "attachment; filename=" + "testfile.csv");
        _blockBlob.DownloadToStream(Response.OutputStream);

Answer 1

我在mvc中按照你的代码下载csv，当我打开它的时候，里面的内容不是我添加的，而是一些html模板。

如果这是您的问题，您可以参考以下代码：

public ActionResult Download()
    {
CloudStorageAccount cloudStorageAccount = CloudStorageAccount.Parse(CloudConfigurationManager.GetSetting("StorageConnectionString"));

            CloudBlobClient _blobClient = cloudStorageAccount.CreateCloudBlobClient();
            CloudBlobContainer _cloudBlobContainer = _blobClient.GetContainerReference("data");
            CloudBlockBlob _blockBlob = _cloudBlobContainer.GetBlockBlobReference("table.csv");
            Response.AddHeader("Content-Disposition", "attachment; filename=" + "table.csv");
             MemoryStream ms = new MemoryStream();
            _blockBlob.DownloadToStream(ms);
            ms.Position = 0;
            return File(ms, "application/octet-stream", "table.csv");
}

您还可以返回重定向（blobUrl）；

有关详细信息，请参阅以下代码：

public ActionResult Download()
    {
        CloudStorageAccount account = new CloudStorageAccount(new StorageCredentials("accountname", "accountkey"), true);
        var blobClient = account.CreateCloudBlobClient();
        var container = blobClient.GetContainerReference("container-name");
        var blob = container.GetBlockBlobReference("file-name");
        var sasToken = blob.GetSharedAccessSignature(new SharedAccessBlobPolicy()
            {
                Permissions = SharedAccessBlobPermissions.Read,
                SharedAccessExpiryTime = DateTime.UtcNow.AddMinutes(10),//assuming the blob can be downloaded in 10 miinutes
            }, new SharedAccessBlobHeaders()
            {
                ContentDisposition = "attachment; filename=file-name"
            });
        var blobUrl = string.Format("{0}{1}", blob.Uri, sasToken);
        return Redirect(blobUrl);
    }