Working with Excel Inside Python

Try # to save dbf3 set file format = 8 excel.ActiveSheet.SaveAs(Filename = "D:\AN00GALL.dbf", FileFormat = 8) -- http://mail.python.org/mailman/listinfo/python-list

Re: Working with Excel inside Python

[EMAIL PROTECTED] a écrit : > Sorry for my little knowledge on Python. Actually my knowledge is > specific for automating geo-processing tasks within ESRI environment, > but sometimes I need to automate some other tasks (like this one) which > require more in-depth knowledge of this language. I wo

Re: Working with Excel inside Python

[EMAIL PROTECTED] a écrit : > Or, you might want to look at two packages: > > xlrd > > pyExcelerator > > The first can "read" .xls files, and the second can write them. I've had > great results with both. That's fine, but since the OP is mainly using Excel for reformating a csv file and savin

Re: Working with Excel inside Python

Sorry for my little knowledge on Python. Actually my knowledge is specific for automating geo-processing tasks within ESRI environment, but sometimes I need to automate some other tasks (like this one) which require more in-depth knowledge of this language. Lots of documentation are of no use when

Re: Working with Excel inside Python

[EMAIL PROTECTED] wrote: > Or, you might want to look at two packages: > > xlrd > > pyExcelerator > > The first can "read" .xls files, and the second can write them. I've had > great results with both. > Hi Gerry, Thanks for the testimonial for xlrd :-) However I don't understand how a reasonab

Re: Working with Excel inside Python

Or, you might want to look at two packages: xlrd pyExcelerator The first can "read" .xls files, and the second can write them. I've had great results with both. Gerry -- http://mail.python.org/mailman/listinfo/python-list

Re: Working with Excel inside Python

[EMAIL PROTECTED] a écrit : > I have a .plt file (which is a tab delimited ASCII file) and I want to > format it to get a .dbf with data in rows and columns, detele some > rows/columns and substitute decimal '.' with ','. All this using Python Then you may want to have a look here: http://docs.pyt

Working with Excel inside Python

I have a .plt file (which is a tab delimited ASCII file) and I want to format it to get a .dbf with data in rows and columns, detele some rows/columns and substitute decimal '.' with ','. All this using Python (I'm using Pythonwin). The .plt file looks like this: * ISCST3 (02035): Tersa * MODELIN