sqlform.grid csv export set delimiter

[Yebach]

Hello

Is it possible to set the delimiter (tab delimited) for csv export from SQLform.grid?

also if I want to export some rows but do not want to show them in grid, what is the syntax to use (I want to hide a column db.workers.id, but i want to export it)?

thank you

[Anthony]

I think you want the tsv_with_hidden_cols option:

http://web2py.com/books/default/chapter/29/07/forms-and-validators?search=tsv_with_hidden_cols

See the surrounding documentation for details on how to control/customize the download options (if you don't see an option that suits your needs, you can create your own export class, using the existing ones as examples).

Anthony