Opening the Excel file in Spreadsheet is not loading all columns

2 posts, 1 answers
  1. Vladimir
    Vladimir avatar
    3 posts
    Member since:
    Mar 2013

    Posted 07 Jul 2016 Link to this post

    I am trying to open the Excel file using the Open button in the spreadsheet widget. One of the file sheets contains 59 columns. After loading the file content the corresponded spreadsheet sheet shows only 50 columns.
  2. Answer
    T. Tsonev
    T. Tsonev avatar
    2834 posts

    Posted 11 Jul 2016 Link to this post


    Prior to the 2016.R1 release the sheet size was fixed via configuration. The default number of columns is 50 and the default number of rows is 200.
    If the imported file contains more than the configured rows or columns they will be cut off. This is consistent with what you describe.

    In newer versions, including the current one, the sheets will be resized to fit the content of the loaded file. 
    All columns are loaded successfully in the demo. See the updated file with 59 columns.

    To summarize, in older versions you need to increase the sheet size so it fits the anticipated data.
    No further action is needed in the current version. All columns should display regardless of configuration.

    T. Tsonev
    Telerik by Progress
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
Back to Top