January 18th, 2013, 03:46 AM
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.
January 23rd, 2013, 02:18 AM
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
All advice is offered in good faith only. You are ultimately responsible for effects of your programs and the integrity of the machines they run on.
Tags for this Thread
Click Here to Expand Forum to Full Width