Copy paste issue
Closed
Prince
-
11 Aug 2010 à 03:52
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Aug 2010 à 22:58
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Aug 2010 à 22:58
Related:
- Free fire name copy
- Pi copy paste - Guide
- E with accent copy paste - Guide
- How to copy paste youtube link on android - Guide
- Ff id blacklist description copy and paste ✓ - Free Fire
- At sign copy and paste - Guide
3 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
11 Aug 2010 à 05:02
11 Aug 2010 à 05:02
open empty excel sheet-use data-import external data-new web query
in the resulting window copy web page url and hit enter key
choose the particualr table in the wbe page by clicking hroizontal arrow and click import
in the resulting window copy web page url and hit enter key
choose the particualr table in the wbe page by clicking hroizontal arrow and click import
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
11 Aug 2010 à 21:57
11 Aug 2010 à 21:57
when you open the query you get the full web page on the window. but there will be a horizontal arrows (mostly in yellow) for each of the tables. when you click the arrow of the table you want the arrow becomes a tick mark. now you can click "import" at the bottom you get the table only in excel.
If there is problem is it possible for you to post the webpage address.
If there is problem is it possible for you to post the webpage address.
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
12 Aug 2010 à 22:58
12 Aug 2010 à 22:58
I think the problem is with the web page. It is not configured for downloading.
see whether you can highlight the whole web page or a table and copy it to excel
another way is to open the webpage in Inerent Explorer where there is provision to copy the table into excel
see whether you can highlight the whole web page or a table and copy it to excel
another way is to open the webpage in Inerent Explorer where there is provision to copy the table into excel
11 Aug 2010 à 09:27
First of all I would like to thank you for reply.
I tried to collect the information, but whole page is imported, but i need only few data, like copying contact details, is there any easiest method apart from this.
Awaitng for response.
Regards,
Prince.