Sikuli data entry automation from Excel to SharePoint

Asked by Zi Huang

Here is our case,

We are working on a QA project. Initially, there will have lots of data entry works to do.

Firstly, we need to enter 3000 records through SharePoint UI. Then, we will do all kinds of other tests.

I have done a few simple Sikuli scripts to open IE, login username, enter password, and then do data entry for one record.

How could I do it in bulk?

Let's say, I put 3000 test records in Excel. Then, I write a Sikuli script to automatically do the data entry works through SharePoint UI. Sikuli is supposed to read the records line by line and finish the data entry works for 3000 records. How am I supposed to do that?

Or, if I import these 3000 test records in SQL Server database as a Test Data table. I also want Sikuli to read the database table line by line and column by column to deal with the data entry works. How could I do that through Sikuli?

Please let me know. Thanks.

Zi.

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
masuo (masuo-ohara) said :
#1

If you are writting codes in Python, you can use "Excel access modules xlrd".
I think There are many examples of usage in the net.

Revision history for this message
RaiMan (raimund-hocke) said :
#2

see related faq 2208

Can you help with this problem?

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

To post a message you must log in.