Click here to Skip to main content
13,090,519 members (52,773 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
I am taking xls or xlsx file from user and Saved it on blob. Now I want after saving i should read that file and convert excel to data Set?? How to do this??
Posted 18-May-11 1:50am
Comments
Girish Jawale 19-May-11 3:52am
   
Hi SAKryukov,
I have gone through the link which you have provided but solution mentioned there are using System.Data.OleDb.OleDbConnection for connect to Excel.Its work fine with normal .net, but Jet Engine (and Office) is not installed on the cloud machines
(See this http://social.msdn.microsoft.com/Forums/hu-HU/windowsazure/thread/8dd98575-c5c1-4f7c-bd7b-f9432efec577 )
. I have tried using
string conn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + uploadFileURI + "; Extended Properties=Excel 12.0;";
but its throws an error. Still am searching how to read the excel file which is at Azure storage. :(
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

See this: http://social.msdn.microsoft.com/Forums/en/vsto/thread/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380[^].

You will find tons of documentation if you Google for it.
You can start from here: http://msdn.microsoft.com/en-us/library/ms186213(v=VS.90).aspx[^].

—SA
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Maybe this[^] can be of some assistance as well.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web03 | 2.8.170813.1 | Last Updated 18 May 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100