Spreadsheet Export to Excel

2 posts, 0 answers
  1. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 26 Apr 2017 Link to this post

    When exporting to Excel, if the spreadsheet has any validation (using range.validation(string here)) then the Export fails to open in Excel 365. Error message is below:

    <?xml version="1.0" encoding="UTF-8"
    standalone="true"?>
    -<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <logFileName>error113640_02.xml</logFileName>
    <summary>Errors were detected in file
    'C:\Users\freemand\Downloads\CurrentStageSkuLine.xlsx'</summary>
    -<removedFeatures summary="Following is a list of
    removed features:">
    <removedFeature>Removed Feature: Data validatin from
    /xl/worksheets/sheet1.xml part</removedFeature>
    </removedFeatures>
    </recoveryLog>

    Currently we get around this, by removing all the range.validation before we export and then add it back afterwards. However this is incredibly slow (over 15 seconds, when the spreadsheet has only 3 rows populated).

    Thanks

    Marc

  2. Nencho
    Admin
    Nencho avatar
    1871 posts

    Posted 27 Apr 2017 Link to this post

    Hello Marc,

    I am afraid that I was unable to replicate such an issue with the exported Excel file. I have used the following example to test the described issue:

    http://dojo.telerik.com/@nenchef/IJiMo/3


    Could you modify it with your implementation and send it back to us, so we would replicate the described issue and pin down the reason for it.

    Regards,
    Nencho
    Telerik by Progress
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top