title: Download an excel file and read content with azure functions
body: <p>I am trying to write a C# Azure Function to download and open an excel file using the OpenXml-SDK.</p>
  
  <p>Office Interop doesn't work here because office is not available to the Azure Function.</p>
  
  <p>I am trying to use OpenXml-SDK to open and read the file which seems to require a path to the saved file and not the url or a Stream downloaded from the remote url.</p>
  
  <p>Given I don't know of a way to temporary store the excel file in Azure Functions, I used Azure File Storage.</p>
  
  <p>I uploaded the excel file from the url to Azure File Storage, however I cannot open the excel file with OpenXML-SDK.</p>
  
  <p>I tested the excel file in Azure File Storage is working, however, when I try to open the OpenXML.SpreadsheetDocument form a MemoryStream I get error indicating the file is corrupt.</p>
  
  <p>If I try to open the SpreadsheetDocument passing the file Uri (<a href="https://docs.microsoft.com/en-us/azure/storage/storage-dotnet-how-to-use-files#develop-with-file-storage" rel="noreferrer">https://docs.microsoft.com/en-us/azure/storage/storage-dotnet-how-to-use-files#develop-with-file-storage</a>) then the address passes the 260 character limit.</p>
  
  <p>I'm open to using a library other than OpenXML and ideally I would prefer not to have to store the excel file.</p>