locked
Upload and read Excel files in Azure RRS feed

  • Question

  • User966057038 posted

    Hi,

    I have an Azure account with only a Web App and SQL Database. I want to be able to upload Excel files and read them into a SQL database table (e.g., using EPPlus). Once the data is loaded into the SQL database, I have no need for the uploaded file.

    Is there a way for me to do this without subscribing to Azure Storage? I would like to use my SQL database if possible. 

    If that is not possible, and I have to use Azure Storage, then what is the best way to upload and iterate through Excel files? Does EPPlus provide for upload to Azure Storage or should I be using something else?

    Thanks for the help.

    Monday, May 18, 2015 2:33 PM

Answers

  • User1814019480 posted

    hi sir,

    Thanks for your posting!

    Base on my experience,  Azure Blob storage is best choice to store those files. However, if you want to store the Excel File into your SLQ Azure database, I think you can store your files as data type(binary) into you SQL Azure database. You can get and use this file via binary.

    And I suggest you can refer to this document for more details about how to store data using filestream:

    http://stackoverflow.com/a/662501

    http://stackoverflow.com/a/2579467

    Happy coding.

    Regards,

    Will

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, May 24, 2015 10:14 PM