exporting data from excel to grid wiew
-
can we export data from excel sheet to gridview . if so please send me how it can done Thank u Uma
-
can we export data from excel sheet to gridview . if so please send me how it can done Thank u Uma
Hello Uma, GridView may or may not have something similar, but ComponentOne's FlexGrid for .NET allows you to load an Excel sheet directly into the grid via the LoadExcel Method. There are few different possibilities for parameters. For example: 'Load the first sheet in the file FlexGrid1.LoadExcel("myFile.xls") 'Load a specific sheet, sheetname1, into the grid FlexGrid1.LoadExcel("myFile.xls", "sheetname1") You can also add a FileFlags parameter, but it is difficult to explain here. If you are interested, check for FileFlags Enumeration in the FlexGrid help file. If you think that you may want to try FlexGrid, you can get more information and download an evaluation here http://www.componentone.com/products.aspx?TabTypeID=1&ItemType=1&PanelIndex=12&ItemID=53459&SubCategoryTypeID=0&TabMapID=9&TabID=11[^].
Suelinda W Customer Engagement, ComponentOne LLC