Ask a Question

Excel Checkpoint: File path as parameter

0 Kudos

Excel Checkpoint: File path as parameter

Excel Checkpoints: It should be possible to pass the file path as a paramer similar to File Checkpoints.

7 Comments
ebarbera
Staff

Hi @MLoetscher - 

 

This is already possible.

 

ebarbera_0-1638799937351.png

Let me know if you have questions. 

Emma

MLoetscher
Senior Member

MLoetscher_0-1638802621272.png

@ebarbera It does not work for me. Can you tell me the hyperlink to the documentation?

ebarbera
Staff

Hi @MLoetscher - 

 

You will have to change it after you create the checkpoint - it will not allow you to do it from the wizard. 

MLoetscher
Senior Member

Hi @ebarbera,

 

If I change the checkpoint after creation, the wizard opens again. I have this behavior with the latest version 15.10. Which version do you have?

ebarbera
Staff

Hi @MLoetscher -

 

The clicks are a little tricky - if a step is highlighted in the list of steps it actually is important under which column you click, you will have to perform two slow clicks in value column. 

 

You should see an ellipsis like this:

ebarbera_0-1638885386252.png

From the ellipsis you will be able to edit without going through the menu. 

 

Let me know if that helps!

 

Emma

MLoetscher
Senior Member

Hi @ebarbera,

 

Now I have figured out what we do differently. I chose the 'Compare a specific sheet in the workbook' option, in which case the FileName parameter is not available. You chose the 'Compare the entire workbook' option. In your case a file comparison is done, but I want to compare the entries of the sheet.

2021-12-07_15h10_00.png

ebarbera
Staff

Hi @MLoetscher - 

 

I see - after converting to script I think its more clear what the issue is - ill try to come up with a solution in this case. The second line is where I specified a specific sheet - it seems like in that case its referred to as a table instead of the file and thats why its it is different.

 

ebarbera_0-1638888477763.png

I will keep you posted. 

 

Emma

Announcements
Welcome to the TestComplete Feature Requests board!

Here you can review submitted feature requests and vote up the ones you like! If you can't find the feature you want - go ahead and suggest your own idea. Ideas with the highest rating can be implemented in the product.

Check out the Create a Feature Request guide for more information.
New Here?
Join us and watch the welcome video:
Announcements