Answers

• allan Posts: 63,696Questions: 1Answers: 10,500 Site admin

  June 2017

  Do you mean the styles identified here? If so, then yes, you can use the customize callback method of the excelHtml5 button type to modify the Excel XML. DataTables doesn't define an API for that, you'd need to modify the XML directly.

  Allan
• HPB Posts: 73Questions: 2Answers: 18

  June 2017 edited June 2017 Answer ✓

  I've made a testcase to show how to add an extra predefined style.
  This code will add a new style that defines a red background and applies it to a specific column and value.
  live.datatables.net/redorefa/1/edit

  I'd highly recommend to extract the generated .xlsx file and open xl/styles.xml to learn what possibilities there are. (the .xlsx file is nothing more than a set of files zipped together)

  @allan
  As a sidenote, the example of adding a different cell background is broken since you define numeric values as a v node now, instead of nested is and t.

  Perhaps you can add an example based on my testcase for future referece, as it is a recurring question about adding predefined styles.
• Khang Posts: 6Questions: 2Answers: 0

  June 2017

  Thanks for answer i wasnt able to reply earlier
  @allan what i meant was just like what HPB said.
  @HPB thank you so much for that answer. That is what i searched for.
• Arudian Posts: 11Questions: 5Answers: 1

  June 2017

  Hi,
  the answer provided by @HPB helps me a lot, but i am not sure how to add multiple colors...this one adds red if condition is true, how do i add green if another condition is true.

  I don't get this part : $(this).attr('s', cellXfCount);
  Could someone please help me out ?
• HPB Posts: 73Questions: 2Answers: 18

  June 2017 edited June 2017

  It is the index of the cellXf node. (zero-based)

  In the testcase I only added 1 cellXf node, so the index of it was the same as the original amount of cellXf nodes. Hence I used cellXfCount as the index.

  If you're adding more styles you should keep track of their index to reference it later in the s attribute.