Datagrid as excel viewer / editor in c#
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
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
Re: Datagrid as excel viewer / editor in c#
I am using ZetExcel
Try it
It helped me a lot !
Re: Datagrid as excel viewer / editor in c#
Quote:
Originally Posted by
jackflint
I am using ZetExcel
Try it
It helped me a lot !
Are you sure the OP is still waiting (more than seven years!) for your assistance? :confused:
Or, you are just spamming? :thumbd:
Re: Datagrid as excel viewer / editor in c#
Re: Datagrid as excel viewer / editor in c#
Quote:
Originally Posted by
jackflint
Just helping
Whom and how?