read excelsheet in azure uploaded as a blob

Question

I am using FileUpload control of asp.net and uploading the excel with some data. I can't save it in some folder. I can have stream of excel sheet file or I can have Blobstream after uploading excel as a blob. Now I want to convert that excel sheets 1st sheet to datatable so how shall I do that? I am using C# .NET. I don't want to use Interop library. I can use external libraries. Oledb connection is getting failed since I don't have any physical path of excel as a data source. I tried following links:

1) http://www.codeproject.com/Articles/14639/Fast-Excel-file-reader-with-basic-functionality

2) http://exceldatareader.codeplex.com/

Please help.

Answer 1

Hi,

Have you try this method from this blog?

http://www.aspspider.com/resources/Resource773.aspx

Here you can get first work sheet from Excel BlobStream, and convert it to DataSet.

Hope this helps.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 2

The link has given good method and there used some external libraries/dlls. But there is no link for that dll. So I searched for it but I found old dlls. In those dlls no methods like CompoundDocument.Read etc.

Answer 3

Hello,

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

From this link: http://excellibrary.googlecode.com/svn-history/r43/trunk/src/ExcelLibrary/Office/Excel/SpreadSheet/Workbook.cs i find CompoundDocument class in these references:

using ExcelLibrary.CompoundDocumentFormat;
using ExcelLibrary.BinaryFileFormat;
using ExcelLibrary.BinaryDrawingFormat;

I use .NET Reflector to decompilation the dll and find Read and GetStreamData methods are exists, please refer to the following link:

http://code.google.com/p/excellibrary/downloads/detail?name=ExcelLibrary.dll&can=2&q=

Hope this helps.

---

Please mark the replies as answers if they help or unmark if not. If you have any feedback about my replies, please contact [e-mail] Microsoft One Code Framework

Answer 4

I first created local storage as per the link:

http://msdn.microsoft.com/en-us/library/windowsazure/ee758708.aspx

suggested by some helpful person on stack overflow. Then I used oledb connection and it gave me an error "Microsoft.Jet.Oledb.4.0 dll is not registered". Then I logged on to the azure server and in the IIS changed app pool configuration for 32-bit. To change app pool to 32-bit refer the following link:

http://blog.nkadesign.com/2008/windows-2008-the-microsoftjetoledb40-provider-is-not-registered-on-the-local-machine/