TableTools - How to add additional information in to CSV files

kevinm2k

Hi,

I'm using table tools and have the option to export to CSV/Excel. However my client is asking for additional information to be passed to the file on export.

Exporting to PDF actually gives pMessage (I think thats what it is) which it includes at the top, is there anything I can use to put some information in to the CSV? Or any workaround or hack I can add to get it working? I don't really want have to write a custom csv wrapper.

Thanks

Kevni

allan

You could provide a custom fnClick method for your export button that basically does the same as the default button action but appends or prepends whatever text you want. I guess the only thing to watch out for is to not make the CSV file invalid.

Allan

kevinm2k

Can you give me an example on how to do this?

Thanks

allan

"fnClick": function( nButton, oConfig, flash ) {
    this.fnSetText( flash, "My text\n\n"+this.fnGetTableData(oConfig) );
}

The fnClick documentation is here.

Allan

kevinm2k

Hi Allan,

I was playing with this and managed to get it working... didn't realise how simple it was to be quite honest.

Thanks for your help.

Kevin