jQWidgets Forums

jQuery UI Widgets › Forums › Grid › Binding to Excel?

Tagged: , ,

This topic contains 1 reply, has 2 voices, and was last updated by  Peter Stoev 12 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Binding to Excel? Posts
  • October 17, 2012 at 4:32 am Binding to Excel? #9575

    fgaonet
    Member

    My original data is an Excel file (.xls). I am trying to bind it to jqxGrid. Is it possible?

    I have tried to use datatype: “tab”, but there is no data to show up in jqxGrid.

    I tried to save my Excel file to .csv and use datatype: “csv”. It shows data but two issues I met:

    1. It shows header row as data.
    2. My data contains comma in some columns.

    What is the best way to bind Excel data source?

    Thanks

    October 17, 2012 at 5:33 am Binding to Excel? #9580

    Peter Stoev
    Keymaster

    Hi fgaonet,

    Grid does not support importing data from Excel i.e loading from (.xls) file. For binding to .csv format, see this sample: bindingtocsv.htm.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.