Thread: Writing to protected sheet from ASP.NET
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
  
Posts: 593
Default Writing to protected sheet from ASP.NET
(Winshent) wrote ...

I need to write to a protected excel worksheet. So far i have code which can
write to an unprotected sheet

It's not possible using ADO because it's ... well, protected.

xlConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
FilePath & ";Extended Properties=""Excel 8.0;HDR=YES;MAXSCANROWS=4"""

Specifying MAXSCANROWS in the connection string has no effect. I guess
you want to override the TypeGuessRows registry key on the local
machine. I wish I was wrong but it simply isn't possible.

Jamie.

--
Reply With QuoteReply With Quote