Copying from webpage
A webpage has 1,200 rows.
I do Select All or drag the cursor from the first row to the last row to highlight all of the rows.
I then do Copy.
When I do Paste (using Match Destination Formatting) to paste the copied rows into an empty Excel spreadsheet, only about 65 rows get posted.
What am I doing wrong?
All Replies (8)
Without a name or URL to the page no one is going to be able to see what is happening to begin to know the issue here?
Unfortunately, the page appears to require a login.
Is it a static page? Some sites like Twitter unload earlier content as you scroll, so it's normal to lose part of the selection on those sites. Perhaps you can get a sense of this if, after you select to the bottom, you call up the print preview (Ctrl+P) and see how much of the page can be printed at one time.
When I select the first row to the last row, print preview shows 49 pages but the only page 2 contains the only 65 rows (plus images) -- pages 1 and 3 thru 49 are blank.
Thank you for testing that. It sounds like it's not just a copying problem since printing also is affected. I don't know whether the site is using some styling that is not compatible with Firefox or is actively removing content. If it were actively removing content, normally the last part you viewed would be there rather than a section in the middle. It's very strange.
Does it work better in Microsoft Edge?
You can also try to check this in the Inspector and possible copy the content their to see whether that works. Try to locate the most outer containing element, i.e. scroll up in the DOM until more gets selected.
You can right-click and select "Inspect" to open the built-in Inspector with this element selected.
Using Edge, only 88 rows (2 pages) contain the selected rows. Pages 3 thru 34 are blank.
It sounds like the site is taking measures to avoid content scraping, or perhaps it is optimizing page weight for mobile devices, or something else is going on there.
Because you have Excel, you could try creating a blank workbook and then using the "From Web" button on the Data section of the ribbon to try to import the page. Since the site requires signing in, I'm not sure that will be an option.