SikuliX

How to write results in existing excel

Asked by sundar

Hello,

Could you please let me know how to write the test results on the already existing excel with multiple sheets.

I have imported the xlwt and tried it but no luck.

I have gone through the net and noticed that most of the people are giving solution for writing the results by creating new excel sheet. But i want to use already existing spread sheet.

Can anyone help me on this.

Question information

Language:
English Edit question
Status:
Answered
For:
SikuliX Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
RaiMan (raimund-hocke) said : 		#1

As far as I understand xlwt: you cannot open an existing workbook and a worksheet in it, to change its contents or add something.

You might try to use xlrd, to get the current content of your XLS, make your changes/additions to your stuff and then use xlwt to write the updated XLS back to disk.
I did not have a deeper look at xlrd/xlwt yet, so I cannot tell you about the effort to get a workbook/sheet content from xlrd over to xlwt.
Since the documentation is rather poor you have to look into the sources and do some try&error.

good look.

Can you help with this problem?

Provide an answer of your own, or ask sundar for more information if necessary.

To post a message you must log in.