Hi all, I was able to copy the web table in IE 7 and paste it into Excel 2007, retaining the table layout on XP Pro with the instructions you provided. - Thank you.
I still can't get it to work with JAWS 12 and Jaws 11, IE 8, Excel 2007 and Window 7 64 Bit Pro. My original problem still exists. When I select the table with F8 and copy into Excel 2007 with the configuration above, all data goes into column A. I can use my XP system with IE 7 to complete what I need to accomplish for now. Thank you for your help. Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Flor Lynch Sent: Saturday, May 21, 2011 5:16 AM To: [email protected] Subject: Re: [JAWS-Users] Converting Web Page Content to Excel Would "Paste special" into Excel not work? ----- Original Message ----- From: "Brian Lee" <[email protected]> To: <[email protected]> Sent: Saturday, May 21, 2011 3:17 AM Subject: Re: [JAWS-Users] Converting Web Page Content to Excel > Hello Bill, > > Try changing your virtual cursor options for copying text in the > Adjust JAWS > options. After selecting the table with f8, use JAWS key V, press the > letter V, and use down arrow to the "select and copy" choice. Press > spacebar until the option for full content using on screen highlight > is > selected. Press enter key to save the change. Copy the table and > then > paste it in Excel. The column headings should be maintained and JAWS > will > speak all content of each cell as you navigate to it, but column > widths and > row heights will have to be adjusted. > > I hope this works for you. , > > Take care. > > Brian Lee > [email protected] > > > -----Original Message----- >>From: [email protected] > [mailto:[email protected]] On Behalf Of Bill > Tipton > Sent: Friday, May 20, 2011 6:10 PM > To: [email protected] > Subject: [JAWS-Users] Converting Web Page Content to Excel > > Hi Brian, > > When I pasted the table into Excel all content went into column A. > > Is there a way to have multiple columns filled with data, and maintain > the > column headings? > > For example, One web page table I am trying to convert to Excel has 4 > columns and 80 rows. > > The column headings are in row 1. > > Is it possible to maintain the table structure after it is copied to > Excel? > > Thank you for your assistance. > > Bill > -----Original Message----- >>From: [email protected] > [mailto:[email protected]] On Behalf Of Brian Lee > Sent: Friday, May 20, 2011 7:14 AM > To: [email protected] > Subject: Re: [JAWS-Users] Converting Web Page Content to Excel > > Hi Ann, > > I thought that would be the case and so I included that step in my > message > to Bill. However, I just tried it without changing the document > presentation to screen layout, and after pasting, the result when > using the > simple layout was the same as when using screen layout. > > Take care. > > Brian Lee > [email protected] > > -----Original Message----- >>From: [email protected] > [mailto:[email protected]] On Behalf Of Ann Marie > Medlar > Sent: Friday, May 20, 2011 6:56 AM > To: [email protected] > Subject: Re: [JAWS-Users] Converting Web Page Content to Excel > > Good morning Brian, > If you don't change the verbosity to screen layout does all table info > go in > column A on spreadsheet? > I usually change verbosity when I encounter a table on web because I > find it > easier to read. > Thanks, > Ann > > ----- Original Message ----- >>From: "Brian Lee" <[email protected]> > To: <[email protected]> > Sent: Friday, May 20, 2011 12:57 AM > Subject: Re: [JAWS-Users] Converting Web Page Content to Excel > > >> Hello Bill, >> >> I am using JAWS 12 with IE 9 and Excel 2010. The following works for >> me, but you will have to try it with Excel 2007 and IE 8 to see if it >> works for you. >> >> 1. Go to the line of text above the HTML data table where JAWS tells >> you how many rows and columns are in the table. >> 2. Press JAWS key with V. >> 3. Press D until you hear the document presentation menu item. >> 4. Press spacebar until you hear screen layout. >> 5. Press enter key. >> 6. Press f8 to select the table. >> 7. Press CTRL C to copy the selected data to the clipboard. >> 8. Open Excel. >> 9. Paste the data. >> >> JAWS will read the content of each cell, but you will need to adjust >> such things as column widths and row heights. >> >> Take care. >> >> Brian Lee >> [email protected] >> >> -----Original Message----- >> From: [email protected] >> [mailto:[email protected]] On Behalf Of Bill >> Tipton >> Sent: Thursday, May 19, 2011 6:58 PM >> To: [email protected] >> Subject: [JAWS-Users] Converting Web Page Content to Excel >> >> Hello, >> >> How can I convert web page content with tables to an Excel file with >> JAWS 12? >> >> I am using IE 8 and Excel 2007. >> >> Thank you, >> >> Bill >> >> >> >> For answers to frequently asked questions about this list visit: >> http://www.jaws-users.com/help/ >> >> >> For answers to frequently asked questions about this list visit: >> http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ > For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
