0

I want to create a ASP.NET application which will fetch and store data from excel. For eg. currently i have automated excel reports using VBA and Macros, and user have to oem all the excels to get the data/charts/tables. All i want to let them open an asp.net application and from there only they can fetch reports, edit the reports and save the data and my excel will be used as DB. Please suggest is it's possible and if possible.

Community
  • 1
  • 1
Mukesh
  • 7
  • 1
  • 5
  • 1
    web is multi user environment, and excel is not well suited for concurrent access, so I would avoid this solution. – Giedrius Jun 12 '13 at 07:26
  • @Giedrius I understand your concern, but still was thinking to avoid my users multiple excels and let them do all at a place in case possible – Mukesh Jun 12 '13 at 07:31

1 Answers1

0

As far as extracting the excel spreadsheet data you can take a look at this post to see a couple alternatives.

As far as getting around the concurrent access issue, you can store the excel information in some form of multi-user concurrent persistant storage - could be on disk or in-memory store (sql server, couchbase, memcache, etc...) and then access information from that store on user request.

Community
  • 1
  • 1
bbqchickenrobot
  • 3,592
  • 3
  • 45
  • 67