I have installed .Cells and put the license with the .dll in the .net 2.0 folder and I can’t get the control to show up in Visual Studio 2010.
I am also trying to find a way to put a datagridview into excel using .Cells.
Thanks for your help
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
You need to set a license. Please see the following document how to set license of Aspose.Cells for .NET.
http://www.aspose.com/docs/display/cellsnet/Licensing
Also you can import data to worksheets from data grid, please see the following document for your reference.
http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets
Thank you for the reply,
I have followed the license and data grid links.
1. I still cannot see the grid control in the toolbox
a. I have Apose.Cells and Apose.Cells.GridDesktop in my references
and
2. in VS 2010 we use a DataGridView and not a DataGrid.
a. Do I need to convert my DGV to a DG? This is more work on my end since DGV replaces DG in VS 2010
http://msdn.microsoft.com/en-us/library/ms171628(v=vs.100).aspx3. The ImportDataGrid method is expecting a System.Web.UI.WebControls.DataGrid. This is NOT a web app. Please advise.
Thanks Again,
Stephen
Hi,
1) If you need to use Aspose.Cells.GridDesktop control in
VS.NET 2010 WinForm application, please follow the instructions below:i) In your WinForm application, right-click on “All Windows Forms” toolbox, click “Choose items”.
ii) Select “.NET Framework Components” tab, now check the checkbox for “GridDesktop” control and click “OK”.
iii) Select the GridDesktop icon from the toolbox and double click it or you may draw the control on the windows by the mouse handle.
iv) GridDesktop control appears on the form now.
For reference, please see the documentation browsing different sections:
2) Aspose.Cells component provides different options method and by using them you may import data from GridView and DataGrid .NET controls to fill or export to an Excel worksheet for your needs, even you may import the underlying datatable for the controls, see the document on what options are available on importing data options:
Thank you.