I'm creating a VB.net application with VS2005 which, at the moment, uses the DataGridView to emulate Excel style functionality on a very basic level. Before I go crazy with creating custom methods for the DataGridView to do some more advanced things, does anyone have a suggestion for an alternative? I plan on installing my app on machines which may not necessarily have Office installed which is why I am shying away from just using an Excel control, unless there is a way to package the core Excel files with the installer. I appreciate any suggestions. As an addendum, open source alternatives are preferable.
Unfortunately the users will need to be able to edit the data contained in the spreadsheet.
Neitherman
2009-01-05 16:06:07
No, you ARE NOT ALLOWED to distribute the Excel viewer to be used this way. Please consult its license terms, e.g. here: http://office.microsoft.com/en-us/help/HA011520851033.aspx?pid=CL100605171033
Mihai Limbășan
2009-01-05 16:38:21
+1
A:
FarPoint has a Spread control that's Excel compatible.
vbAccelerator also has a suped-up Grid control that may also work for you.
Patrick Cuff
2009-01-05 15:59:47
SGrid 2.0 looks like it may be a winner, I'll have to play around with it when I get some free time to be sure.
Neitherman
2009-01-05 16:11:01
A:
While they are not cheap or open source, Infragistics and Telerik make some of the best 3rd party tools that can perform excel like functionality.
brendan
2009-01-06 04:42:46
Thanks for the suggestion but the app is not nearly large enough scale to need something so elaborate.
Neitherman
2009-01-06 17:34:32
+1
A:
SpreadsheetGear for .NET is an Excel compatible spreadsheet component for .NET. You can download the free, fully-functional evaluation here.
Joe Erickson
2009-01-28 02:06:12
This looks pretty great, so far I've developed my app just using the plain DataGridView object but I'll check this out to see if it'd be worth making a switch. It all depends on how the evalution license works.
Neitherman
2009-02-13 18:34:27