Author Topic: Excell Cell Address Syntax - help!  (Read 1686 times)

Tags:
  • All members
  • Posts: 154
  • Gender: Male
Excell Cell Address Syntax - help!
« on: 17 Nov 2015, 21:59 »
Hi,

I'm struggling with the syntax for the "write to excel" action.
I want to write a series of values to a series of incrementing cells.

e.g.

value 1 goes to cell A20
value 2 goes to cell A21
value 3 goes to cell A22

I can produce the incrementing row number (row_index) variable, but I can't get the trigger to work with anything I have tried other than fixed cell references such as querymarket_id!A20.  querymarket_id!Arow_index or querymarket_id!A_row_index don't do anything.  What is the correct syntax if my user var is called row_index?

Also, I'm at a complete loss as to what the example in the manual does - querymarket_id!Dsel_index.

regards

Wez




  • Administrator
  • Posts: 8818
  • Gender: Female
*
Re: Excell Cell Address Syntax - help!
« Reply #1 on: 18 Nov 2015, 09:26 »
Wez,

You need to take trigger variables and expressions in parentheses when dealing with Excel cell addresses:

querymarket_id!D(sel_index)

querymarket_id!A(row_index)

That's how it is in the manual by the way. See chapter "Excel-Bound Variables".
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

  • All members
  • Posts: 154
  • Gender: Male
Re: Excell Cell Address Syntax - help!
« Reply #2 on: 20 Nov 2015, 00:04 »
Hi Oxa,

Well I can say I 'm truly embarressed by not picking that up and for not even trying parenthesis!

I bet you were thinking what we say at work in those situations - "RTFM"
(Read the 'kin manual!)

Thanks as always,

Wez

  • Administrator
  • Posts: 8818
  • Gender: Female
*
Re: Excell Cell Address Syntax - help!
« Reply #3 on: 20 Nov 2015, 07:23 »
Don't worry Wez, reading manuals is not my thing either (although I have to write them - big yawn!).
Always try your triggers in Test Mode before switching to real money!

Follow us on Twitter.

Join our WhatsApp chat!

Присоединяйтесь к официальному Telegram-каналу!

 

Please note, BetFair is seems to be currently OFFLINE