[jawsscripts] Re: An Excel script
- From: "Martin Slack" <m.g.slack@xxxxxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Fri, 11 Sep 2009 17:10:19 +0100
GetCellCoordinates will return both the row and column as integers. See my
replies to Reed for a method of converting column coordinates to the
appropriate letters.
Martin
----- Original Message -----
From: "Marlon Brandão de Sousa" <splyt.lists@xxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Friday, September 11, 2009 2:17 PM
Subject: [jawsscripts] Re: An Excel script
> Hello,
> I will try it. BTW, there is a function called sayCell which takes a
> string as parameter and that will say the cell contents. The problem
> is, this parameter must be something like "a35" ... I just need to
> know a way of getting the collumn one is placed into to set the
> monitor thing.
> Any other suggestion as how to get the current collumn letter when
> pressing a keystroke?
> Marlon
>
> 2009/9/10, Martin Slack <m.g.slack@xxxxxxxxxxxx>:
>> Marlon,
>>
>> The JAWS function GetRowText can be called to produce a delimited
>> string
>> of all the text in the active row of the table. You can then specify
>> which
>> cell's contents to speak using the StringSegment function as below:
>>
>> Script testExcel ()
>> Var string sLine
>>
>> let sLine = GetRowText ("|", "c%1r%2", "nothing found", 1, 26)
>> ;let sLine = GetRowText ("|", "", "nothing found")
>> SayString (StringSegment (sLine, "|", 20))
>>
>> EndScript
>>
>>
>> You can use either form of the GetRowText function above, either
>> specifying everything (include each cell's coordinates in the string as
>> well
>> as how much of the row to read), or accept the default options of no
>> coordinates and read the whole row.
>>
>> If you need to specify the column by letter, you could compare your
>> letter
>> with a string of characters, say "a|b|c| ... |zz" using
>> StringSegmentIndex
>> until you found the match and then enter that number in the above code.
>>
>> hth
>>
>> Martin
>>
>>
>> ----- Original Message -----
>> From: "Marlon Brandão de Sousa" <splyt.lists@xxxxxxxxx>
>> To: <jawsscripts@xxxxxxxxxxxxx>
>> Sent: Thursday, September 10, 2009 9:46 PM
>> Subject: [jawsscripts] Re: An Excel script
>>
>>
>>> That's also what I would like to know.
>>> I want to implement a kind of monitor cell that is relative to the
>>> line one currently is placed, so that if they are whatching for
>>> collumn t for example they can be anywhere in line 2 and pressing a
>>> keystroke the t2 cell would be read and if they are in anywhere in
>>> line 135 and press the same command the t135 cell will be read and so
>>> on.
>>> I can code a function like numberToLetter and use it, but cinse JAWS
>>> can say the coordinates of a given cell then I also can use this
>>> information in my scripts. We just need to figure out or be helped as
>>> to how to get this information.
>>> Marlon
>>>
>>> 2009/9/10, Reed Poynter <reed.poynter@xxxxxxxxx>:
>>>> Hi Scripters,
>>>>
>>>> In Ms Excel 2003, there is a Go To dialog where you can select blocks
>>>> of
>>>> data based on a top left and a bottom right cell.
>>>> For example, in a spreadsheet, you hit F5 and specify A1:G6 and hit
>>>> enter.
>>>> The block of data is selected.
>>>>
>>>> I want to be able to do the following.
>>>> Go to the top left cell and hit a key to save its coordinates, go to
>>>> the
>>>> bottom right cell, hit a second key to save its coordinates, put the 2
>>>> saved
>>>> coordinates together in a string and put it into the go to dialog.
>>>>
>>>> I don't know of anything in Excel that will do this for me. So, I
>>>> thought
>>>> I'd write a JFW script to do it.
>>>>
>>>> I think my process would be to, with a hot key, save the coordinates of
>>>> the
>>>> top left cell to the clipboard,
>>>> With a second hot key, capture the bottom cell coordinates, and put
>>>> them
>>>> together into a string with the first coordinates once retrieved from
>>>> the
>>>> clipboard.
>>>> Save this new string to the clipboard,
>>>> Open Excel's Go To dialog and paste in my coordinates.
>>>>
>>>> My first problem is having the script determine the cell coordinates.
>>>> Looking through the functions in the Script Manager, the only guy I see
>>>> is
>>>> GetCellCoordinates.
>>>> If I am sitting on cell A5, GetCellCoordinates (x, y) returns integers
>>>> 1
>>>> and 5.
>>>> I need something that will give me a5.
>>>> Any suggestions?
>>>>
>>>>
>>>> Thanks.
>>>>
>>>> Reed
>>>>
>>>>
>>>> __________
>>>> Visit and contribute to The JAWS Script Repository
>>>> http://jawsscripts.com
>>>>
>>>> View the list's information and change your settings at
>>>> //www.freelists.org/list/jawsscripts
>>>>
>>>>
>>>
>>>
>>> --
>>> When you say "I wrote a program that crashed Windows," people just
>>> stare at you blankly and say "Hey, I got those with the system, for
>>> free."
>>> Linus Torvalds
>>> __________
>>> Visit and contribute to The JAWS Script Repository
>>> http://jawsscripts.com
>>>
>>> View the list's information and change your settings at
>>> //www.freelists.org/list/jawsscripts
>>>
>>
>>
>> --------------------------------------------------------------------------------
>>
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - www.avg.com
>> Version: 8.5.409 / Virus Database: 270.13.89/2360 - Release Date:
>> 09/10/09
>> 11:29:00
>>
>> __________
>> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>>
>
>
> --
> When you say "I wrote a program that crashed Windows," people just
> stare at you blankly and say "Hey, I got those with the system, for
> free."
> Linus Torvalds
> __________
> Visit and contribute to The JAWS Script Repository http://jawsscripts.com
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.91/2363 - Release Date: 09/11/09
09:15:00
__________
Visit and contribute to The JAWS Script Repository http://jawsscripts.com
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
