exportoptions result body column parameter and header column different value

irwanto

i trying to export using button copy, and in body format exportoption, i want to checking population column, population column index is 3
with one column -> 'island ' is hidden,
when i trying debug header vs body in exportoption, value parameter of column is different.
here result in debug console :

"header column :0"
"header column :2" --> column island is hidden
"header column : 3"
"body 0:0"
"body 0:1" --> in header is 2 and then 3
"body 0:2"
"body 1:0"
"body 1:1"
"body 1:2"
"body 2:0"
"body 2:1"
"body 2:2"
"body 3:0"
"body 3:1"
"body 3:2"

with that body column 0:0, 0:1, 0:2, i cant compare population column (in header 3) but body column is 2
and its dynamic column
if i change visibility column, result console.log is different again in 'body'

link test
https://jsfiddle.net/irwanto82/g17jru54/23/

colin

You can still use the API to get the row and therefore the data, use row().data(), see your example updated here. That would allow you to access the columns not being printed,

Colin