Are you running Windows?. Check that your list separator (which Excel uses) is set to a comma or change the delimiter used in the code. You can find the list separator in the Control Panel, under Regional Settings, Customize.
On May 3, 7:38 am, cyber <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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])
