I need Sikuli to change a value in an existing Excel sheet cell

Asked by Stephan Timmers on 2018-01-10

I need to adjust cell A2 from "No" to "Yes" at the end of my script.

Cant get it to work. Please show me the line of code.

Thanks in advance.

Question information

Language:
English Edit question
Status:
Answered
For:
Sikuli Edit question
Assignee:
No assignee Edit question
Last query:
2018-01-10
Last reply:
2018-01-11
masuo (masuo-ohara) said : #1

I recommend you to use EXCEL VBA to fulfill the requirements.

If you want to SikuliX to modify cell value, you have to write codes that open EXCEL sheet, and select cell, and input strings.

I don't want to use VBA it needs to be done by SikuliX. Otherwise the
script wont work.

Please just tell me the lines
Op wo 10 jan. 2018 om 22:47 schreef masuo <
<email address hidden>>

> Your question #662804 on Sikuli changed:
> https://answers.launchpad.net/sikuli/+question/662804
>
> Status: Open => Answered
>
> masuo proposed the following answer:
> I recommend you to use EXCEL VBA to fulfill the requirements.
>
> If you want to SikuliX to modify cell value, you have to write codes
> that open EXCEL sheet, and select cell, and input strings.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/sikuli/+question/662804/+confirm?answer_id=0
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/sikuli/+question/662804
>
> You received this question notification because you asked the question.
>

masuo (masuo-ohara) said : #3

Sorry I don't know module to modify EXCEL cell value.
The function of xlrd is to read the information from the EXCEL file.

So SikuliX has not a single option to Edit excel cells? Like xlwt or
something
Op wo 10 jan. 2018 om 23:09 schreef masuo <
<email address hidden>>

> Your question #662804 on Sikuli changed:
> https://answers.launchpad.net/sikuli/+question/662804
>
> Status: Open => Answered
>
> masuo proposed the following answer:
> Sorry I don't know module to modify EXCEL cell value.
> The function of xlrd is to read the information from the EXCEL file.
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/sikuli/+question/662804/+confirm?answer_id=2
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/sikuli/+question/662804
>
> You received this question notification because you asked the question.
>

masuo (masuo-ohara) said : #5

The function of xlwt is to creating Excel files.
For more information please read the document.
http://xlwt.readthedocs.io/en/latest/api.html

And what about xlutils?

So again: SikuliX has NO way to Edit existing excel files?

Can barely believe it.

Op wo 10 jan. 2018 om 23:26 schreef masuo <
<email address hidden>>

> Your question #662804 on Sikuli changed:
> https://answers.launchpad.net/sikuli/+question/662804
>
> Status: Open => Answered
>
> masuo proposed the following answer:
> The function of xlwt is to creating Excel files.
> For more information please read the document.
> http://xlwt.readthedocs.io/en/latest/api.html
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/sikuli/+question/662804/+confirm?answer_id=4
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/sikuli/+question/662804
>
> You received this question notification because you asked the question.
>

RaiMan (raimund-hocke) said : #7

@Stephan
--- you say:
And what about xlutils?
So again: SikuliX has NO way to Edit existing excel files?
Can barely believe it.

Be aware:
what you can't barely believe, has nothing to do with SikuliX.
You can use the SikuliX feature set in various Java based scripting/programming environments.
Depending on this environment there might be other features and/or other libraries targeting non-SikuliX features.
The xlXX series is a typical example for Python/Jython scripting.

So it is your own responsibility, to find and understand those other features/libraries.

... and give people in this forum, that are trying to help you, the feeling, that you appreciate their struggles and that you seriously try to evaluate their suggestions.

still not answered: https://answers.launchpad.net/sikuli/+question/662729

RaiMan (raimund-hocke) said : #8

... and comment #1 in the second sentence suggests the SikuliX way to change the cell content.

Can you help with this problem?

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

To post a message you must log in.