Controlling column width in renderDataTable output

[Kevin Ushey]

Hi,

Is there an easy way to control, at the R level, the width of each column generated in the DataTable?

The DataTables documentation suggests this could be passed through in the 'aoColumnDefs' option, but I am not sure exactly how I would specify this in the 'shiny::renderDataTable' options argument. (See: http://datatables.net/usage/columns).

Thanks!

-Kevin

[y.le...@gmail.com]

Hi,

This is an example:

output$mytable <- renderDataTable({

if (nrow(subset(outputT8()))==0) invisible()

else subset(outputT8(),select=c(3,1,2,5,4,6,11))

},option=list(iDisplayLength=15,bSortClasses = TRUE,bAutoWidth=FALSE,

aoColumnDefs = list(list(sWidth=c("100px"), aTargets=c(list(0),list(1),list(2),list(3),list(4),list(5)))))

)

hope it helps

[Kevin Ushey]

Perfect. Thanks for your help!

[Stéphane Laurent]

Hi, 

For me this works well:

aoColumnDefs = list(list(sWidth=c("100px"), aTargets=list(0)))

But for more than one column the width does not change when I do:

aoColumnDefs = list(list(sWidth=c("100px"), aTargets=c(list(0),list(1))))

[Yann Le Strat]

I'm not sure but I believe that there is no change when you specify the width of all the columns

There is a change if you specify 1 or 2 or n-1 width values if your table has n columns, as in my example.

I don't know if there is another solution.