Solved

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

  • 28 July 2020
  • 5 replies
  • 10 views

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!

icon

Best answer by Anonymous 31 July 2020, 17:16

View original

5 replies

Userlevel 4
Badge +11

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.


 

Badge +6
@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.

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.

@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.


 

Badge +6

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

Reply