Month: August 2017

Write class instance to XML File and read file contents

August 29, 2017

You have a class and you need to save values to of the class to an xml file to be consumed later on  [code source=”C#”] public class TemplateInformation { public string StoredProcedure { get; set; } public List<string> Parameters { get; set; } public string TemplatePath { get; set; } public string TemplateName { get; … More Write class instance to XML File and read file contents

Writing Data From .Net to Excel Interrupted by User Opening Excel Window

August 14, 2017

Problem I have an application that generates financial reports in excel. After installing Office 2013, if a user opens excel while the application is running, the application returns a error: System.Runtime.InteropServices.COMException with HRESULT: 0x800AC472 which interrupts the data from being written to the spreadsheet. After some research according to Microsoft this was done by design, the … More Writing Data From .Net to Excel Interrupted by User Opening Excel Window