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
130
How to import data from Excel file to grid
posted

Hi,

I want to import data from Excel file to grid and also should be able to Copy -Paste data from Excel sheet.

While Pasting Records from the excel, required rows should be added to the grid automatically.

I am using 2010.1 xamlDataPresenter control.

Thanks

Mukesh

  • 9694
    posted

    Hello Mukesh,

    NetAdvantage for WPF support exporting data to Excel. We do not currently support importing Excel data. If you wish to write this yourself, you would have to read in information from Excel and put it into some IEnumerable/IList (e.g. DataTable, etc.) and bind the grid to that. And you can use our Excel object model to implement reading the data from an excel file.

    Concerning copy and paste, setting the FieldLayoutSettings->AllowClipboardOperations property will enable that feature.

    Concerning inserting records, I refer you to the following post:
    http://community.infragistics.com/forums/p/38451/229427.aspx#229427

    Thank you!