You must Sign In to post a response.
  • Category: ASP.Net MVC

    Query About storing MS Excel sheet to database

    Hiiii
    How to store the MS Excel sheet as Entity into the database?
    Please suggest me.
  • #754138
    Hi,

    You can convert your excelsheet into datauri and then you can save it in your database.

    Later on you can dycript than datauri and you can generate excel from it and use it or save it

    I hope you got my point.

    Regards,
    Nirav Prabtani (Senior Web Developer)
    Email : niravjprabtani@gmail.com
    blog : niravprabtani.blogspot.in

  • #754168
    You can not insert the Entire excel sheet value in the Database, rather it is advisable to insert the sheet in the form of table so that all the columns and Rows can come as it is.
    Thanks & Regards
    Anil Kumar Pandey
    Microsoft MVP, DNS MVM

  • #754259
    See this post, it presents detailed steps on how to Export Data from Excel to Datatable in C#

    http://janewdaisy.wordpress.com/2011/11/29/c-export-data-from-excel-to-datatable/

    Good luck.


  • Sign In to post your comments