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 – [...]
Tag Archive 'VBA'
Writing Date to Excel from ASP.NET and C#
Posted in Work on Oct 31st, 2008
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.