cancel
Showing results for 
Search instead for 
Did you mean: 

Automating SpreadJS from GrapeCity

SOLVED
theabubakkar
New Contributor

Automating SpreadJS from GrapeCity

Hi,

 

I am automating some web apps which have embedded spreadsheets from SpreadJS. TestComplete is not picking up its elements. I am using Google Chrome.

I want to select desired spreadsheet cells with rows and columns. 

TestComplete is only picking it as a whole unit on HTML page. 

Please guide me on this and give solution.

Screenshot 2021-01-15 161949.jpg

Thanks. 

AbuBakkar

Regards,
AbuBakkar
1 ACCEPTED SOLUTION

Accepted Solutions
AlexKaras
Community Hero

Re: Automating SpreadJS from GrapeCity

Hi,

 

Thank you for the link.

It looks like that spreadsheet is rendered as canvas object:

<canvas id="ssvp_vp" gcuielement="gcWorksheetCanvas" width="735" height="724" style="width: 735px; height: 724px; cursor: default;">You need a browser which full supports HTML5 Canvas to run SpreadJS</canvas>

Canvas's content does not have any corresponding html-markup and is created as graphic, i.e. using graphical primitives and does not have any internal object structure that can be exposed outside.

With the above in mind, you seems to have just two options:

a) Either image-based operations;

b) Or talk to your developers for some API that can be used from the script injected into the tested web page so that you can get/set canvas data through this API.

https://support.smartbear.com/testcomplete/articles/embedding-scripts-into-web-pages/

https://support.smartbear.com/testcomplete/docs/app-testing/web/common-tasks/javascript.html

 

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================

View solution in original post

3 REPLIES 3
AlexKaras
Community Hero

Re: Automating SpreadJS from GrapeCity

Hi,

 

What is html markup for these spreadsheets?

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================
theabubakkar
New Contributor

Re: Automating SpreadJS from GrapeCity

Thank you for the quick response. 

Please check following demo link. Our application has same UI and html code. 

https://www.grapecity.com/spreadjs/demos/sample/showcase/aging-report/purejs/ 

 

Thanks.

 

Regards,
AbuBakkar
AlexKaras
Community Hero

Re: Automating SpreadJS from GrapeCity

Hi,

 

Thank you for the link.

It looks like that spreadsheet is rendered as canvas object:

<canvas id="ssvp_vp" gcuielement="gcWorksheetCanvas" width="735" height="724" style="width: 735px; height: 724px; cursor: default;">You need a browser which full supports HTML5 Canvas to run SpreadJS</canvas>

Canvas's content does not have any corresponding html-markup and is created as graphic, i.e. using graphical primitives and does not have any internal object structure that can be exposed outside.

With the above in mind, you seems to have just two options:

a) Either image-based operations;

b) Or talk to your developers for some API that can be used from the script injected into the tested web page so that you can get/set canvas data through this API.

https://support.smartbear.com/testcomplete/articles/embedding-scripts-into-web-pages/

https://support.smartbear.com/testcomplete/docs/app-testing/web/common-tasks/javascript.html

 

 

Regards,
  /Alex [Community Hero]
____
[Community Heroes] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Heroes]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Hero] signature is used with permission by SmartBear Software.
https://community.smartbear.com/t5/custom/page/page-id/hall-of-fame
================================

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors