3 Replies - 225 Views - Last Post: 19 June 2019 - 09:25 AM

#1 RushabhVerma   User is offline

  • New D.I.C Head

Reputation: -2
  • View blog
  • Posts: 13
  • Joined: 23-April 19

how to color the exported data table in Excel Sheet.

Posted 19 June 2019 - 12:30 AM

Basically the DATA TABLE is exporting in Excel, But need to change the format of the table, like adding additional cell color or border in the cell. And the Data table is in class and its dynamic

I have already with all the functionalities like ,

$js .= '"createdRow": function( row, data, dataIndex){
$(row).addClass(\'redClass\');
}';
$js.='customize: function(xlsx){
var sheet = xlsx.xl.worksheets["sheet1.xml"];
$("row c[r*="10"]",sheet).attr("s","25");
},';

NO Change in the exported excel sheet

Is This A Good Question/Topic? 0
  • +

Replies To: how to color the exported data table in Excel Sheet.

#2 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6967
  • View blog
  • Posts: 23,677
  • Joined: 05-May 12

Re: how to color the exported data table in Excel Sheet.

Posted 19 June 2019 - 03:46 AM

Moving to Javascript...
Was This Post Helpful? 0
  • +
  • -

#3 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6967
  • View blog
  • Posts: 23,677
  • Joined: 05-May 12

Re: how to color the exported data table in Excel Sheet.

Posted 19 June 2019 - 04:05 AM

Also cross-posted in SO.
Was This Post Helpful? 1
  • +
  • -

#4 ArtificialSoldier   User is online

  • D.I.C Lover
  • member icon

Reputation: 2334
  • View blog
  • Posts: 7,111
  • Joined: 15-January 14

Re: how to color the exported data table in Excel Sheet.

Posted 19 June 2019 - 09:25 AM

There's a lot of missing information here that makes this question pretty difficult to try to answer. The only thing I see is a string of Javascript code that uses jQuery being built.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1