JavaScript UI Libraries & Blazor Components Suite – Smart UI Forums Data Grid Import Data from .xlsx file to Grid error

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #101186
    LC
    Member
    Up
    0
    Down

    Hi,
    There have been some problems recently with importing data from the outside using Grid components.
    In the following examples: Smart Grid for Angular | Grid | Smart UI for Angular (htmlelements.com),
    The data should be able to be imported and displayed from a.xlsx file. I’m sure the file path is correct, but “No Rows” is always displayed. Could you please tell me the reason, or should I make some changes somewhere?
    In addition,
    If I change the.xlsx file to .json file, can it work normally? Or what else needs to be modified?
    Thank you for your help and looking forward to your early reply.
    BR,
    LC

    #101187
    admin
    Keymaster
    Up
    0
    Down

    Hi LC,
    The demo is for importing data from excel, not from json. If the local path to the data.xlsx file is correct, it will work, otherwise it will not be able to load data.
    Best regards,
    Peter Stoev
    Smart UI Team
    https://www.htmlelements.com/

    #101188
    LC
    Member
    Up
    0
    Down

    Hi,
    I’m sure the path about the.xlsx file is correct because I placed it in the same folder as data.ts.
    import { GetData } from ‘../common/data’;
    the “GetData” function can be used. But the page cannot display the data in the.xlsx file.
    BTW, If want to read data from a.json file, is there any examples to refer?
    Thank you.
    BR,
    LC

    #101191
    admin
    Keymaster
    Up
    0
    Down

    Hi,
    The demo is available here online: https://www.htmlelements.com/angular/demos/grid/data-import/. It can be found also in the download package.
    For data binding to JSON, please refer to https://www.htmlelements.com/angular/demos/grid/server-side-mysql-php/.
    Best regards,
    Peter Stoev
    Smart UI Team
    https://www.htmlelements.com/

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.