Custom or default provider saves a broken Blank Excel XLSX Document
There are no issues when the user makes changes to the imported Blank XLSX document.
Posted on:24 Apr 2020 10:02
Based on the discussion in the support thread, this issue seems to be sporadical and we cannot replicate it locally.
Nevertheless, using the following SaveWorkbook method for the custom provider is a confirmed way to resolve the issue:
var dplWorkbook = workbook.ToDocument();
Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();
using (Stream output = new FileStream(_path, FileMode.Create))
Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic. Our thoughts here at Progress are with those affected by the outbreak.