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
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.
Hi Mike,
thanks for response.
Do you have an example where I can take helps?
My Excel file will have only one preimposted and preformatted sheet.
I'm afraid I do not know of any examples of this. But there's not much to it. You load the Workbook which has a Worksheets collection. Each Worksheet has a rows collection and each row has a collection of cells. Very similar to the grid, in fact.