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]

<sw**********@y ahoo.comwrote in message
news:11******** *************@j 27g2000cwj.goog legroups.com...

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/Aspos...s/Default.aspx

Don't even think of trying to use Office automation:
http://support.microsoft.com/default...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.

On Feb 23, 9:10 am, "Mark Rae" <m...@markNOSPA Mrae.comwrote:

<sweetpota...@y ahoo.comwrote in message

news:11******** *************@j 27g2000cwj.goog legroups.com...

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/Aspos...s/Default.aspx

Don't even think of trying to use Office automation:http://support.microsoft.com/default...US;q257757#kb2

[Mark Rae]

<sw**********@y ahoo.comwrote in message
news:11******** *************@8 g2000cwh.google groups.com...

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?sourc...DO%2eNET+Excel

[sweetpotatop]

On Feb 23, 12:36 pm, "Mark Rae" <m...@markNOSPA Mrae.comwrote:

<sweetpota...@y ahoo.comwrote in message

news:11******** *************@8 g2000cwh.google groups.com...

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?sourc...ie=UTF-8&rls=G...

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

System.Data.Ole Db.OleDbExcepti on: Unspecified error

Dim sConnectionStri ng As String = "Provider=Micro soft.Jet.OLEDB. 4.0;"
_
& "Data Source=C:\test. xls" _
& ";" & "Extended Properties=Exce l 11.0;"

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

' 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]

<sw**********@y ahoo.comwrote in message
news:11******** **************@ q40g2000cwq.goo glegroups.com.. .

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

System.Data.Ole Db.OleDbExcepti on: Unspecified error

Dim sConnectionStri ng As String = "Provider=Micro soft.Jet.OLEDB. 4.0;"
_
& "Data Source=C:\test. xls" _
& ";" & "Extended Properties=Exce l 11.0;"

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

' 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]

On Mar 7, 4:07 am, "Mark Rae" <m...@markNOSPA Mrae.comwrote:

<sweetpota...@y ahoo.comwrote in message

news:11******** **************@ q40g2000cwq.goo glegroups.com.. .

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

System.Data.Ole Db.OleDbExcepti on: Unspecified error

Dim sConnectionStri ng As String = "Provider=Micro soft.Jet.OLEDB. 4.0;"
_
& "Data Source=C:\test. xls" _
& ";" & "Extended Properties=Exce l11.0;"

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

' 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...?- 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 sConnectionStri ng As String =
"Provider=Micro soft.Jet.OLEDB. 4.0;" _
& "Data Source=" &
Server.MapPath( "./test.xls") _
& ";" & "Extended Properties=Exce l
11.0;"

And I try to catch the exception but I am still getting "Unspecifie d
error "
Try
objConn.Open()
Catch ex As Exception
Page.RegisterSt artupScript("Ca nnot Open",
"<script>window .alert('" & (ex.Message.ToS tring) & "' );</script>")
Exit Sub
End Try

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

[Mark Rae]

<sw**********@y ahoo.comwrote in message
news:11******** **************@ 30g2000cwc.goog legroups.com...

And I try to catch the exception but I am still getting "Unspecifie d
error "
Try
objConn.Open()
Catch ex As Exception
Page.RegisterSt artupScript("Ca nnot Open",
"<script>window .alert('" & (ex.Message.ToS tring) & "' );</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]

On Mar 7, 9:28 am, "Mark Rae" <m...@markNOSPA Mrae.comwrote:

<sweetpota...@y ahoo.comwrote in message

news:11******** **************@ 30g2000cwc.goog legroups.com...

And I try to catch the exception but I am still getting "Unspecifie d
error "
Try
objConn.Open()
Catch ex As Exception
Page.RegisterSt artupScript("Ca nnot Open",
"<script>window .alert('" & (ex.Message.ToS tring) & "' );</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...

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

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

If Not (ex.InnerExcept ion Is Nothing) Then
Page.RegisterSt artupScript("Ca nnot Open",
"<script>window .alert('" & (ex.InnerExcept ion.ToString) & "' );</
script>")
End If
Exit Sub
End Try

[Mark Rae]

<sw**********@y ahoo.comwrote in message
news:11******** **************@ n33g2000cwc.goo glegroups.com.. .

I have something like this, but "InnerExcep tion 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=en...22+Excel&meta=

Has nothing there helped...?