Datagrid as excel viewer / editor in c#
I have a requirement to display data from excel document in a C# win form datagrid. Add formula functionality of excel and apply in the datagrid value. When saving datagrid values to a excel value save same like excel file including formulaes.
Can any one help me how to do this one.
Is it can be doable through OpenXml or OleDB because I don't want to depend upon MS Office installation in client place.
Thanks in advance.
Re: Datagrid as excel viewer / editor in c#
If you don't want to depend on MS Office, it looks like there are a bunch of high quality libraries. Looks like they are reviewed pretty well here: http://stackoverflow.com/questions/4...e-best-library