cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Excel - Format as Table - How to check "My table has headers"?

Hi there!

 

I tried to automate actions when you want to format data as table in Excel 2016. 

I use target "Excel" action "Send value" with param like this - [^Alt+H]T[Enter] - it works fine.

And on this step I want to know how to check param "My table has headers" because time by time it checked and another time not checked. 

 

Any suggestions?

Thank you for advice!

Labels: (1)
Tags (2)
Reply
5 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Excel - Format as Table - How to check "My table has headers"?

Rekses,

Have you tried, Send Value/Key Strokes/Mode/None and Speed/Very Slow or Slowest.  Try that and let us know if that helps.

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Excel - Format as Table - How to check "My table has headers"?

@Sasan the question as I got it was about how to be sure you get predictable result. When you just send keys, you can toggle, but the results depend on unknown initial state and the task is to detect it or to make the change in a deterministic way.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Excel - Format as Table - How to check "My table has headers"?

Dear @Sasan,

 

 @akrasheninnikov is right. If I just use [^Tab]Space there can be the case when this option is already checked.... So I can just uncheck it by this command.

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Excel - Format as Table - How to check "My table has headers"?

@akrasheninnikov @Rekses 

Your best option is to use the Pixel Exists action.  To use this action, have the Format a Table window up and make sure the My Table Has Headers is Checked. Next follow the steps below:

 

1. Target the Format a Table window and choose Pixel Exists from the option of actions. 

2. After selecting Pixel Exists change the option from color to B&W. 

3. Click on the preview and select the check mark so the action will look at the spot each time to see if the check box is already checked.

4. Finally you can save the results to a variable.

 

Once the Pixel Exists action is created  you can then have an if statement afterwards to see if the results of the Pixel Exists returned a true or false.  If the results are false you can then have it enter the if statement to enable My Table Has Headers.

 

Reply
Highlighted
Nintex Newbie

Re: Excel - Format as Table - How to check "My table has headers"?

Sounds like high tech and a step towards a neural network, but should be working :)

0 Kudos
Reply