Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
465
Loading Excel file
posted

Hi all,

how can I load an Excel file (with a predefinited template fields) in a UltraGrid for a WinForm application?

Thanks in advance.

Luigi

Parents
No Data
Reply
  • 469350
    Suggested Answer
    Offline posted

    Hi Luigi,

    There's no way to do this directly. You can load an Excel file into a Workbook object, but the grid can only bind to an IBindingList or IList and the Workbook doesn't qualify. There's really no way the grid can interpret an Excel file, since the file is not necessarily homogeneous - it could contain multiple worksheet and doesn't have data type information for each column, nor column headers, etc.

    So you would have to copy the data from the Excel Workbook into something the grid can deal with like an UltraDataSource, DataTable, BindingList<T>, etc.

Children