since when exporting it the pdf page width is not enough, is there any way to show all the columns or split the table with the remaining columns to another page?
No, I think the best you can do is to change the page margins, see here.
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.