Das deutsche Python-Forum

Code: Alles auswählen

cTH.Print('Excel Tabelle Write Zelle ' + sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell, 'INFO')


import xlwt
from xlwt import workbook

try:
   book = xlwt.workbook(sFile)
   sheet1 = book.get_sheet(sTable)
   sheet1.write(iLine, iColumn,sCell)
   book.save(sFile)
   iResult = 1

    #book = Workbook(sFile)
    #sheet = book.get_sheet(sTable)
                        
    #sheet.write(iLine, iColumn, sCell)
    #book.save("sFile")
    #iResult = 1
     
except:
    Report.createSubTest('Excel Tabelle Write Zelle' , 0 )
    Report.createCommentSubTest(' Fehler beim Schreiben von ' + sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell)
    iResult = 0
    raise

Code: Alles auswählen

2011-07-28 14:36:27 MainThread !!! exception-name: AttributeError
2011-07-28 14:36:27 MainThread !!! exception-arguments: 'module' object has no attribute 'workbook'
2011-07-28 14:36:27 MainThread !!! exception-traceback:   File "D:\EXAM\Programme\EXAM\plugins\de.exam.prunner_3.0.1.201105230923\pRunner\loop.py", line 148, in commandLoop
2011-07-28 14:36:27 MainThread                 command: exec(execFileName + '.main()')
2011-07-28 14:36:27 MainThread !!! exception-traceback:   File "<string>", line 1, in <module>
2011-07-28 14:36:27 MainThread                 command: 
2011-07-28 14:36:27 MainThread                 command: testFlow('', '00000000-0000-0000-0000-000000000000')
2011-07-28 14:36:27 MainThread                 command: iResult = _0._e.UmlClass_a29a2d3c1051729de04400144f6890e0.getInstance().Excel_Tabelle_Write_Zelle_4(sFile = 'C:/TEMP/Messwer_Test.xls', sTable =
 'Sheet4', iColumn = 0, iLine = 0, sCell = 'TEST_01')
2011-07-28 14:36:27 MainThread                 command: book = xlwt.workbook(sFile)

Code: Alles auswählen

cTH.Print('Excel Tabelle Write Zelle ' + sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell, 'INFO')


import xlwt
from MSExcel import Workbook

try:
   book = workbook(sFile)
   sheet1 = book.get_sheet(sTable)
   sheet1.write(iLine, iColumn,sCell)
   book.save(sFile)
   iResult = 1                 
      
except:
    Report.createSubTest('Excel Tabelle Write Zelle' , 0 )
    Report.createCommentSubTest(' Fehler beim Schreiben von ' + sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell)
    iResult = 0
    raise

Code: Alles auswählen

2011-07-28 14:26:19 MainThread !!! exception-name: ImportError
2011-07-28 14:26:19 MainThread !!! exception-arguments: cannot import name workbook
2011-07-28 14:26:19 MainThread !!! exception-traceback:   File "D:\EXAM\Programme\EXAM\plugins\de.exam.prunner_3.0.1.201105230923\pRunner\loop.py", line 148, in commandLoop
2011-07-28 14:26:19 MainThread                 command: exec(execFileName + '.main()')
2011-07-28 14:26:19 MainThread !!! exception-traceback:   File "<string>", line 1, in <module>
2011-07-28 14:26:19 MainThread                 command: 
2011-07-28 14:26:19 MainThread                 command: testFlow('', '00000000-0000-0000-0000-000000000000')
2011-07-28 14:26:19 MainThread                 command: iResult = _0._e.UmlClass_a29a2d3c1051729de04400144f6890e0.getInstance().Excel_Tabelle_Write_Zelle_4(sFile = 'C:/TEMP/Messwer_Test.xls', sTable =
 'Sheet4', iColumn = 0, iLine = 0, sCell = 'TEST_01')
2011-07-28 14:26:19 MainThread    command: from xlwt import workbook 

Code: Alles auswählen

ich habe das Programm angepasst,ich kann jetzt zumindest mit Python eine Wert in excel  schreiben. jedoch während der Messung wird nur den Letzten Wert in die Tabelle gespeichert. wie soll ich das Programm anpassen damit bei der Messung alle werte gespeichert werden?
die Python funktion sieht zurzeit wie folgt aus

" description: Write Excel files with Python using xlwt"

# log Messgae

cTH.Print('Excel Tabelle Write Zelle ' +sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell, 'INFO')

# initialize a Workbook object and add a Worksheet object to that Workbook
import xlwt
from xlwt import BIFFRecords
from xlwt import Formatting
from xlwt import Style
from xlwt import UnicodeUtils

try:

     book = xlwt.Workbook() 
     sheet = book.add_sheet(sTable) 
     #shett = book.get_sheet(sTable)
     
     # write Data to Worbook

     sheet.write(iLine,iColumn,sCell)
     
     # save the workbook
     
     book.save(sFile) 
     iResult = 1
except:
    Report.createSubTest('Excel Tabelle Write Zelle' , 0 )
    Report.createCommentSubTest(' Fehler beim Schreiben von ' + sFile + ' ' + sTable + ' ' + str(iColumn) + ' ' + str(iLine) + ' ' + sCell)
    iResult = 0
    raise