none
How to merge header column and followed by print records from data table Using NPOI RRS feed

  • Question

  • Hi,

    How to merge header column and followed by print records from data table.

    For Example, i have data table and i want format some header columns and print.

    How to merge header column and followed by print data table records.

    Attached screenshot for your reference.


    Monday, May 21, 2018 6:13 AM

Answers

  • Hi Gani,

    This is a third party library, we cannot provide much solution on this as this is not a Microsoft product. You have to ask on their site about the issue. In the mean time you could look into the below articles for more information. Hope this will help you.

    What I can say is that first you have to import the values from datatable to excel file then you run the NPOI library to merger those cells.

    C#: Merging Excel cells with NPOI HSSFWorkbook

    Merging Excel cells with NPOI


    Thanks,
    Sabah Shariq

    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post or click Answered "Vote as helpful" button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]

    • Marked as answer by Gani tpt Friday, May 25, 2018 10:07 AM
    Monday, May 21, 2018 7:24 PM
    Moderator

All replies

  • Is this an Excel question or are you doing this in code?

    Michael Taylor http://www.michaeltaylorp3.net

    Monday, May 21, 2018 3:45 PM
    Moderator
  • Is this an Excel question or are you doing this in code?

    Michael Taylor http://www.michaeltaylorp3.net

    Hi Michael,

    For information look https://github.com/tonyqus/npoi

    I use it myself


    Greetings from Amsterdam the Netherlands

    Monday, May 21, 2018 6:38 PM
  • Hi Gani,

    This is a third party library, we cannot provide much solution on this as this is not a Microsoft product. You have to ask on their site about the issue. In the mean time you could look into the below articles for more information. Hope this will help you.

    What I can say is that first you have to import the values from datatable to excel file then you run the NPOI library to merger those cells.

    C#: Merging Excel cells with NPOI HSSFWorkbook

    Merging Excel cells with NPOI


    Thanks,
    Sabah Shariq

    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post or click Answered "Vote as helpful" button of that post. By marking a post as Answered or Helpful, you help others find the answer faster. ]

    • Marked as answer by Gani tpt Friday, May 25, 2018 10:07 AM
    Monday, May 21, 2018 7:24 PM
    Moderator