Unplanned
Last Updated: 24 Apr 2020 10:02 by ADMIN
Jim
Created on: 16 Mar 2020 07:43
Category: Spreadsheet
Type: Bug Report
1
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.
1 comment
ADMIN
Peter Milchev
Posted on: 24 Apr 2020 10:02

Hello,

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:

public void SaveWorkbook(Workbook workbook)
{
    var dplWorkbook = workbook.ToDocument();

   // https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/formats-and-conversion/xlsx/xlsxformatprovider#export
    Telerik.Windows.Documents.Spreadsheet.FormatProviders.IWorkbookFormatProvider formatProvider = new Telerik.Windows.Documents.Spreadsheet.FormatProviders.OpenXml.Xlsx.XlsxFormatProvider();

    using (Stream output = new FileStream(_path, FileMode.Create))
    {
        formatProvider.Export(dplWorkbook, output);
    }
}

Regards,
Peter Milchev
Progress Telerik

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.