How do I load an Excel file in an ASP page from System.Web.HttpInputStream? File uploaded by Telerik: RadUpload.
Appreciate any help. Thanks
2
-
Is your question about getting a file from the stream OR somehow rendering Excel file on ASP.Net page?Alexei Levenkov– Alexei Levenkov2011-02-03 19:05:39 +00:00Commented Feb 3, 2011 at 19:05
-
Only need to read the stream that comes into the property of InputStream, transforming it into an Excel file and read the columns. I know how to read the data but does not know how I can create an Excel object that is valid from the Stream. @Alexei Levenkovpauloh– pauloh2011-02-03 19:13:08 +00:00Commented Feb 3, 2011 at 19:13
Add a comment
|
1 Answer
I had to do this recently from a file that a user would upload. I got it to work by saving the file temporarily then doing the following
string fileTempPath = Path.Combine(Server.MapPath("~/temp"), fileUploader.FileName);
fileUploader.SaveAs(fileTempPath);
fileTempPathHiddenField.Value = fileTempPath;
System.Data.DataTable excelDataTable = LoadData();
Later in the code:
protected System.Data.DataTable LoadData()
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + fileTempPathHiddenField.Value + ";" +
"Extended Properties=Excel 8.0;";
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(string.Format("Select * from [{0}$]", sheetNameTextBox.Text), connectionString);
DataSet excellDataSet = new DataSet();
dataAdapter.Fill(excellDataSet, "ExcelInfo");
return excellDataSet.Tables["ExcelInfo"];
}
Then once you are done with the temp file, go ahead and delete it if you want to.
