Re: ooolib, reading writing a spread sheet and keep formatting

Hi Chris, Chris Withers wrote: > News123 wrote: >> Hi Chris, >> >> >> Chris Withers wrote: >>> News123 wrote: from xlrd import open_workbook from xlutils.copy import copy rb = open_workbook('doc1.xls') >>> open_workbook('doc1.xls',formatting_info=True) >> >> I'll try, but the

Re: ooolib, reading writing a spread sheet and keep formatting

News123 wrote: Hi Chris, Chris Withers wrote: News123 wrote: from xlrd import open_workbook from xlutils.copy import copy rb = open_workbook('doc1.xls') open_workbook('doc1.xls',formatting_info=True) I'll try, but the doc mentioned explicitely, that formulas will be lost. I'll keep you u

Re: ooolib, reading writing a spread sheet and keep formatting

Hi Chris, Chris Withers wrote: > News123 wrote: >> >> from xlrd import open_workbook >> from xlutils.copy import copy >> >> rb = open_workbook('doc1.xls') > > open_workbook('doc1.xls',formatting_info=True) I'll try, but the doc mentioned explicitely, that formulas will be lost. I'll keep you u

Re: ooolib, reading writing a spread sheet and keep formatting

News123 wrote: from xlrd import open_workbook from xlutils.copy import copy rb = open_workbook('doc1.xls') open_workbook('doc1.xls',formatting_info=True) print "WB with %d sheets" % rb.nsheets wb = copy(rb) wb.save("doc2.xls") # file is created, but ALL formattng is lost and formulas are n

Re: ooolib, reading writing a spread sheet and keep formatting

On 04/30/10 05:58, News123 wrote: > cjw wrote: > However: > > I'd like to read in a spreadsheet, perform only minor modifications and > write it back with the exact formatting. this is unfortunately not working. Do you know that Python is one of OpenOffice's macro language? Python macro have the

Re: ooolib, reading writing a spread sheet and keep formatting

cjw wrote: > On 28-Apr-10 23:18 PM, Kushal Kumaran wrote: >> On Thu, Apr 29, 2010 at 5:46 AM, News123 wrote: >>> Hi, >>> >>> I'm making first attempts to modify a few cells of an openoffice >>> spreadsheet. >>> >> >> Try the xlrd and xlwt modules, and the documentation at >> http://www.python-exce

Re: ooolib, reading writing a spread sheet and keep formatting

On 28-Apr-10 23:18 PM, Kushal Kumaran wrote: On Thu, Apr 29, 2010 at 5:46 AM, News123 wrote: Hi, I'm making first attempts to modify a few cells of an openoffice spreadsheet. Try the xlrd and xlwt modules, and the documentation at http://www.python-excel.org/ The tutorial here is beautiful

Re: ooolib, reading writing a spread sheet and keep formatting

News123 wrote: > > Kushal Kumaran wrote: >> On Thu, Apr 29, 2010 at 5:46 AM, News123 wrote: >>> Hi, >>> >>> I'm making first attempts to modify a few cells of an openoffice >>> spreadsheet. >>> >> Try the xlrd and xlwt modules, and the documentation at >> http://www.python-excel.org/ > I install

Re: ooolib, reading writing a spread sheet and keep formatting

Kushal Kumaran wrote: > On Thu, Apr 29, 2010 at 5:46 AM, News123 wrote: >> Hi, >> >> I'm making first attempts to modify a few cells of an openoffice >> spreadsheet. >> > > Try the xlrd and xlwt modules, and the documentation at > http://www.python-excel.org/ Thanks Kumar, I installed xlrd, x

Re: ooolib, reading writing a spread sheet and keep formatting

On Thu, Apr 29, 2010 at 5:46 AM, News123 wrote: > Hi, > > I'm making first attempts to modify a few cells of an openoffice > spreadsheet. > Try the xlrd and xlwt modules, and the documentation at http://www.python-excel.org/ > -- regards, kushal -- http://mail.python.org/mailman/listinfo/pyt

ooolib, reading writing a spread sheet and keep formatting

Hi, I'm making first attempts to modify a few cells of an openoffice spreadsheet. I thought I'll start with ooolib as it seems rather simple. ( linux / open office 3.1 / ooolib-python-0.0.16 ) My first test was just to open a spread sheet import ooolib doc = ooolib.Calc() doc.load("doc1.ods")