Share via

Update data within an Excel file stored in blob

Nandan Hegde 32,416 Reputation points MVP
2020-09-18T11:07:18.267+00:00

Hello,
Is is possible to replace some characters within an Excel file that is present in Azure blob storage via powershell without downloading the Excel file?
As we were thinking to call it in Azure Function which is a serverless offering

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,551 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Julian Hüppauff 341 Reputation points Microsoft Employee
    2020-09-18T12:25:08.943+00:00

    You could look at the append blob operations.
    https://learn.microsoft.com/en-us/rest/api/storageservices/understanding-block-blobs--append-blobs--and-page-blobs

    If you just want to store a simple table, try Table Storage which would be a better fit for it :).

    2 people found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.