Datagrid as excel viewer / editor in c#

[kuna.sharma]

Hi,

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.

Sharma

[BioPhysEngr]

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