<div>Hello Walter and members:</div>
<div> </div>
<div>I'm working with csv to handle excel, my other was useful to do my new cvs file. When I open the output file, it has all the information I need, but all of my lines have the filepath separate by comes, even though it's supposed to be a complete string; for example: C,:,\,i,n,d,i,c,e,.,s,h,p all the others have the same format. </div>
<div>Besides I need a row to put in each cell the column names, with:</div>
<div> c.writerow(["Archivo","x_min","x_max","y_min","y_max","geometria","num_ele","prj","estructura bd","extent","fecha_modificacion","maquina_host"]). But all tha names gather in the same row and I want my pathfile to place under the "Archivo" column, but I couldn't do it.<br>
</div>
<div><br><br> </div>
<div class="gmail_quote">2010/10/11 Walter Prins <span dir="ltr"><<a href="mailto:wprins@gmail.com">wprins@gmail.com</a>></span><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im"><br><br>
<div class="gmail_quote">On 11 October 2010 14:37, Susana Iraiis Delgado Rodriguez <span dir="ltr"><<a href="mailto:susana.delgado_s@utzmg.edu.mx" target="_blank">susana.delgado_s@utzmg.edu.mx</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>The other question is about the excel files management, if I want to manipulate this data to work it in Excel should I look for an excel library in python right?</div><br></blockquote></div><br></div>Yes. I already mentioned one (in my view good) option in my original reply to you. The xlwt module works quite well for generating Excel files (with expectable limitations) from any platform that Python's available on (e.g. including non-Windows.) and thus does not require Excel to be available on the machine you're producing the file on.<br>
<br>If however you are running on Windows and have Excel installed, you could consider driving the real Excel via COM automation, which will guarantee you get desired results including formatting, charts etc, and will ensure you have full access to all the functionality Excel exposes via its COM object model.<br>
<br>If your requirements on the other hand simple enough then Joel's suggestion to use CSV is probably preferable. (The KISS principle: "Keep It Small & Simple")<br><br>There's also the possibility to look into generating .xlsx files (e.g. XML based Office format files.) Theoretically you should be able to generate the correctly structured XML independent of Excel and have it open in Excel. I suspect that may be rather painful though (have never tried this myself) andam almost reluctant to even mention this option, so caveat emptor.<br>
<font color="#888888"><br>Walter<br></font></blockquote></div><br>