CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6
  1. January 18th, 2013, 03:46 AM #1
    kuna.sharma
    kuna.sharma is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. January 23rd, 2013, 02:18 AM #2
    BioPhysEngr's Avatar
    BioPhysEngr
    BioPhysEngr is offline Moderator
    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.
    Reply With Quote Reply With Quote
  3. July 15th, 2020, 01:17 AM #3
    jackflint
    jackflint is offline Junior Member
    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
    Reply With Quote Reply With Quote
  4. July 15th, 2020, 01:25 AM #4
    VictorN's Avatar
    VictorN
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,338

    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
    Reply With Quote Reply With Quote
  5. July 15th, 2020, 01:52 AM #5
    jackflint
    jackflint is offline Junior Member
    Join Date
    Jul 2020
    Posts
    3

    Re: Datagrid as excel viewer / editor in c#

    Just helping
    Reply With Quote Reply With Quote
  6. July 15th, 2020, 02:14 AM #6
    VictorN's Avatar
    VictorN
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,338

    Re: Datagrid as excel viewer / editor in c#

    Quote Originally Posted by jackflint View Post
    Just helping
    Whom and how?
    Victor Nijegorodov
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured