How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

Published on

Below is the C# code to create a new Excel workbook based on a template file & populated by an SQL database. You need to add references to: DocumentFormat.OpenXml System.Data.Linq Windows.Base using System; using System.IO; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using DocumentFormat.OpenXml.Packaging; using DocumentFormat.OpenXml.Spreadsheet; using DocumentFormat.OpenXml; namespace ElitetoExcel { class Program { … Continue reading How to create an Excel Workbook from an SQL database using Open XML SDK 2.0

K2 deployment error: The partner transaction manager has disabled its support for remote/network transactions

Published on

When deploying a new K2 workflow / process you get an error message containing: The partner transaction manager has disabled its support for remote/network transactions First check on the application server(s): 1. Go to “Administrative Tools > Services” 2. Turn on the “Distribute Transaction Coordinator” Service if it is not running If you still get … Continue reading K2 deployment error: The partner transaction manager has disabled its support for remote/network transactions