none
Change Cell Back/Fore color using OpenXMLSDK 2.0 RRS feed

  • Question

  • Can anyone please let me know with example how to change BoldYN/backColor/forecolor of Excel Cell using OpenXMLSDK? I just need to change three attributes (Bold/backColor/forecolor) of a cell of an existing template. Because some numeric cells are custom formatted (Currency/DateTime) and I dont want to change this format. Just need to change Bold property, backcolor, forecolor...

    Thanks in advance...

    -Jahedur Rahman


    Tuesday, August 16, 2011 8:46 AM

All replies

  • hello Jahedur

    plz refere following two links. It might be useful. because I've already done with back color, fore color n bold text.

     

    http://lateral8.com/articles/2010/3/5/openxml-sdk-20-export-a-datatable-to-excel.aspx

    http://www.lateral8.com/articles/2010/6/11/openxml-sdk-20-formatting-excel-values.aspx


    Mohit
    Tuesday, August 16, 2011 11:50 AM
  • Thanks Mohit for providing the links though it didn't help me out of the issues since the articles found at the links mostly deals with formatting cells in a new file and not with existing templates.

    -Jahedur Rahman

    Friday, August 26, 2011 4:59 AM