Read protect excel using aspnet

[sweetpotatop]

Hi,

I wonder if it is possible to read the content of an excel spreadsheet
through aspnet. The spreadsheet (workbook) is protected and it resides
in a network drive.

Please provide sample code if possible. Thanks in advance. Your help
is greatly appreciated.

 

[Mark Rae]

Please provide sample code if possible.

Unfortunately, the fact that the workbook has a password means that it can't
be opened via ADO.NET: http://support.microsoft.com/kb/211378/EN-US/

Therefore, your only option is to use Aspose:
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

Don't even think of trying to use Office automation:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

 

[sweetpotatop]

What if it is not password protected, is it possible to read the
sheets (more than 1) in the workbook and how can this be done?

Thanks.

 

[Mark Rae]

What if it is not password protected, is it possible to read the
sheets (more than 1) in the workbook and how can this be done?

http://www.google.co.uk/search?sour...rls=GGLG,GGLG:2006-28,GGLG:en&q=ADO.NET+Excel

 

[sweetpotatop]

http://www.google.co.uk/search?sourceid=navclient&aq=t&ie=UTF-8&rls=G...

Thanks for your advice, but I am getting the following error once
objConn.Open is executed

System.Data.OleDb.OleDbException: Unspecified error

Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
_
& "Data Source=C:\test.xls" _
& ";" & "Extended Properties=Excel 11.0;"

' Create the connection object by using the preceding
connection string.
Dim objConn As New OleDbConnection(sConnectionString)

' Open connection with the database.
objConn.Open()

Is it something to do with the Extended Properties? I have been trying
8.0 to 11.0, but none of them work. The file is created through MS
Excel 2003. Or something is missing on the machine?

Please help. Your help is greatly appreciated.

 

[Mark Rae]

Thanks for your advice, but I am getting the following error once
objConn.Open is executed

System.Data.OleDb.OleDbException: Unspecified error

Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
_
& "Data Source=C:\test.xls" _
& ";" & "Extended Properties=Excel 11.0;"

' Create the connection object by using the preceding
connection string.
Dim objConn As New OleDbConnection(sConnectionString)

' Open connection with the database.
objConn.Open()

Is it something to do with the Extended Properties?

You need to catch the exception and then inspect the inner exception to find
out what precisely is going wrong...

Also, is text.xls actually present in the root directory of your
webserver...?

 

[sweetpotatop]

You need to catch the exception and then inspect the inner exception to find
out what precisely is going wrong...

Also, is text.xls actually present in the root directory of your
webserver...?- Hide quoted text -

- Show quoted text -

No luck, unfortunately, I have moved the test.xls to the root
directory of the web application (see below)

Dim sConnectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=" &
Server.MapPath("./test.xls") _
& ";" & "Extended Properties=Excel
11.0;"

And I try to catch the exception but I am still getting "Unspecified
error "
Try
objConn.Open()
Catch ex As Exception
Page.RegisterStartupScript("Cannot Open",
"<script>window.alert('" & (ex.Message.ToString) & "' );</script>")
Exit Sub
End Try

Please help. I really need to get this resolved. Many thanks.

 

[Mark Rae]

And I try to catch the exception but I am still getting "Unspecified
error "
Try
objConn.Open()
Catch ex As Exception
Page.RegisterStartupScript("Cannot Open",
"<script>window.alert('" & (ex.Message.ToString) & "' );</script>")
Exit Sub
End Try

Please help. I really need to get this resolved. Many thanks.

Like I said, you need to interrogate the InnerException property of the
Exception object, not the Message property...

 

[sweetpotatop]

Like I said, you need to interrogate the InnerException property of the
Exception object, not the Message property...

I have something like this, but "InnerException Is Nothing", so I
can't any message at all. Please help!!!

Try
objConn.Open()
Catch ex As Exception
'lblError.Text = ex.Message.ToString

If Not (ex.InnerException Is Nothing) Then
Page.RegisterStartupScript("Cannot Open",
"<script>window.alert('" & (ex.InnerException.ToString) & "' );</
script>")
End If
Exit Sub
End Try

 

[Mark Rae]

I have something like this, but "InnerException Is Nothing", so I
can't any message at all. Please help!!!

In which case, I'm at a bit of a loss...

This error is well enough documented on Google:
http://www.google.co.uk/search?hl=e...leDbException+"Unspecified+error"+Excel&meta=

Has nothing there helped...?

 

[sweetpotatop]

In which case, I'm at a bit of a loss...

This error is well enough documented on Google:http://www.google.co.uk/search?hl=en&rls=GGLG,GGLG:2006-28,GGLG...

Has nothing there helped...?

Perfect! It is working now -- the permission to the
C:\Documents and Settings\MachineName\ASPNET\Local Settings\Temp
folder

Thanks a trillion.

 

[Mark Rae]

Perfect! It is working now -- the permission to the
C:\Documents and Settings\MachineName\ASPNET\Local Settings\Temp
folder

Thanks a trillion.

I think, in the end, all I did was tell you to do a Google search...

For virtually every problem, that's the place to start...