CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Angry 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

  2. #2
    Join Date
    Feb 2011
    Location
    United States
    Posts
    1,016

    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
    Best Regards,

    BioPhysEngr
    http://blog.biophysengr.net
    --
    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.

  3. #3
    Join Date
    Jul 2020
    Posts
    3

    Re: Datagrid as excel viewer / editor in c#

    I am using ZetExcel
    Try it
    It helped me a lot !
    Last edited by 2kaud; July 15th, 2020 at 04:21 AM. Reason: Removed advertising link

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Datagrid as excel viewer / editor in c#

    Quote Originally Posted by jackflint View Post
    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?
    Or, you are just spamming?
    Last edited by 2kaud; July 15th, 2020 at 04:22 AM.
    Victor Nijegorodov

  5. #5
    Join Date
    Jul 2020
    Posts
    3

    Re: Datagrid as excel viewer / editor in c#

    Just helping

  6. #6
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,396

    Re: Datagrid as excel viewer / editor in c#

    Quote Originally Posted by jackflint View Post
    Just helping
    Whom and how?
    Victor Nijegorodov

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured