Archive for the tag 'C#'

Sep 16 2009

Access is Denied Exception when writing to Spreadsheet from ASP.Net

Published by nick under Work

I recently got the following error message whilst trying to write to an excel file using the openXML library in ASP.Net and C#: System.ApplicationException: Access is denied. (Exception from HRESULT: 0×80070005 (E_ACCESSDENIED)) at System.IO.IsolatedStorage.IsolatedStorageFile.nGetRootDir(IsolatedStorageScope scope) at System.IO.IsolatedStorage.IsolatedStorageFile.InitGlobalsNonRoamingUser(IsolatedStorageScope scope) at System.IO.IsolatedStorage.IsolatedStorageFile.GetRootDir(IsolatedStorageScope scope) at System.IO.IsolatedStorage.IsolatedStorageFile.GetGlobalFileIOPerm(IsolatedStorageScope scope) at System.IO.IsolatedStorage.IsolatedStorageFile.Init(IsolatedStorageScope scope) at System.IO.IsolatedStorage.IsolatedStorageFile.GetStore(IsolatedStorageScope scope, Type domainEvidenceType, Type assemblyEvidenceType) at [...]

Tags: , ,

One response so far

Apr 29 2009

Excel – Update formulas on Open

Published by nick under General,Work

Most of the time this is a relatively trivial exercise. In the majority of cases, simply setting ‘Workbook Calculation’ to ‘Automatic’ in the Excel options will give the desired effect. However, I recently stumbled across a situation where this doesn’t work. If you find yourself entering data into an Excel workbook through some other means [...]

Tags: , ,

No responses yet