ASP.Net C# Excel Upload Question

[Jake]

Good Day All,

Sorry if I am posting in the wrong forum, hopefully someone will be able to
push me in the right direction. What I am trying to accomplish is allowing a
client to upload an Excel file and then I need to access the Excel file
without saving the file directly to the server. What I am eventually going to
do is save the Excel data into a database. Here is a sample of what I am
trying to do, and I may be way off track here.

if ( filMetricFile.P ostedFile != null )
{
// Get a reference to PostedFile object
HttpPostedFile _metricFile = filMetricFile.P ostedFile;

// Get size of uploaded file
int nFileLen = _metricFile.Con tentLength;

// make sure the size of the file is > 0
if( nFileLen > 0 )
{
// Allocate a buffer for reading of the file
byte[] _metricData = new byte[nFileLen];
// Read uploaded file from the Stream
_metricFile.Inp utStream.Read(_ metricData, 0, nFileLen);

OleDbConnection ExcelConnection = new OleDbConnection (
@"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source="
+ _metricFile + ";Extended Properties=Exce l 8.0;");

ExcelConnection .Open();

//Do something with the ExcelConnection
}
}

And of course I am sure you can see I am missing something. When I try the
ExcelConnection .Open() I will get a an error stating that the object is read
only.

So I’m not sure if what I am doing is even possible, but any help would be
greatly appreciated. I just want to process the Excel file while in memory
and not have to save the file directly to the server first.

Thanks,
Jake

[Scott Allen]

Jake:

I don't believe there is going to be an easy way to do this. Excel
runs as a separate process, and you can't just pass it a pointer or a
reference to a block of memory sitting in the web application.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Fri, 19 Nov 2004 11:35:20 -0800, "Jake"
<Ja**@discussio ns.microsoft.co m> wrote:

Good Day All,

Sorry if I am posting in the wrong forum, hopefully someone will be able to
push me in the right direction. What I am trying to accomplish is allowing a
client to upload an Excel file and then I need to access the Excel file
without saving the file directly to the server. What I am eventually going to
do is save the Excel data into a database. Here is a sample of what I am
trying to do, and I may be way off track here.

if ( filMetricFile.P ostedFile != null )
{
// Get a reference to PostedFile object
HttpPostedFi le _metricFile = filMetricFile.P ostedFile;

// Get size of uploaded file
int nFileLen = _metricFile.Con tentLength;

// make sure the size of the file is > 0
if( nFileLen > 0 )
{
// Allocate a buffer for reading of the file
byte[] _metricData = new byte[nFileLen];
// Read uploaded file from the Stream
_metricFile.In putStream.Read( _metricData, 0, nFileLen);

OleDbConnectio n ExcelConnection = new OleDbConnection (
@"Provider=Mic rosoft.Jet.OLED B.4.0;Data Source="
+ _metricFile + ";Extended Properties=Exce l 8.0;");

ExcelConnectio n.Open();

//Do something with the ExcelConnection
}
}

And of course I am sure you can see I am missing something. When I try the
ExcelConnectio n.Open() I will get a an error stating that the object is read
only.

So I’m not sure if what I am doing is even possible, but any help would be
greatly appreciated. I just want to process the Excel file while in memory
and not have to save the file directly to the server first.

Thanks,
Jake