I mean that after export each row is located into one cell (if I open *.csv file in ms excel). For example, if result returns two rows all values from first row are located into A1 cell and the second one - into A2 cell. So, I need to divide each row by columns. Current divider is ",". Is there a way to use another tabular separator if i want each value to be placed into each cell? *****************************************************************************
On 3 май, 00:04, DenesL <denes1...@yahoo.ca> wrote: > Sorry, I don't understand what you mean by divide search results. > > As for headers, you could do: > > ... > return 'A1,B1,C1\n' + '\n'.join([','.join(map(str,[r.id, r.num, r.ves, > r.dt, r.usr])) for r in rr]) > > On May 2, 2:42 pm, cyber <vlad.mul...@gmail.com> wrote: > > > > > > > > > Denes, it works. Thanks! > > But how to divide search results? > > Finaly I want each table field to be into personal column in the row > > in csv file. > > For example, r.id should be into A1, r.num should be into B1 etc. > > Is it possible? > > > ********************************************************************* > > > On 2 май, 00:27, DenesL <denes1...@yahoo.ca> wrote: > > > > You can provide a link to the controller below, instructing the user > > > to right click on it and then select 'save link as...', he can store > > > the response in any selected directory using his choice of filename (a > > > name ending in .csv): > > > > def tocsv(): > > > response.headers['content-type']='text/csv' > > > rr=db((db.autos.dt>=t1) & > > > (db.autos.dt<=t2)).select(orderby=~db.autos.dt) > > > return '\n'.join([','.join(map(str,[r.id, r.num, r.ves, r.dt, > > > r.usr])) for r in rr])
