nickhowell.co.uk

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: ASP.NET, C#, Excel

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: C#, Excel, VBA

If like me you learnt SQL using MySQL, and then gone into a job and found yourself using Microsoft’s SQL Server, you’ll probably be as irritated as me to find that Transact-SQL does not feature the ‘AUTO INCREMENT’ keyword that MySQL provides. Fortunately, the solution is far easier here than it is in PostgreSQL. All [...]

Tags: Microsoft, SQL Server, Transact-SQL

Page Refresh Animations This refers to the way in which we can display some form of feedback to the user that the page is being updated, without the need for an ugly page flash or the page seemingly doing nothing.  As always there are several ways to achieve this – a quick google will probably [...]

Tags: ASP.NET, Javascript

Right, I recently discovered some nice looking colour themes for Visual Studio 2008. So, i’ve decided to share. I can’t be bothered to put a screen shot up, so if you want to see it you’ll just have to try it. Basically, it’s a dark colour scheme. Dark blue background, and brightly coloured text (but [...]

Tags: Programming, Visual Studio

The ViewState in ASP.Net is one of those weird and wonderful things that Microsoft obviously thought was a good idea at the time. Granted, it is quite useful but as with all things like that, it comes with a price – and a fairly hefty one at that if not used sensibly.

Tags: ASP.NET, C#, Programming

Ok, so i’ve just been working on outputting data from an ASP.NET based web app into an Excel Spreadsheet. I’m not going to go into the details of how to do that, but only how to avoid one little problem i encountered.

Tags: ASP.NET, C#, Excel, Programming, VBA