Hi guys,
I'm trying to do a cart scrape from a popular e-commerce site, and the only way I can do it properly right now is through the Page Source.
I'm coming across an issue where I'm trying to copy the page source data and putting it into excel, where all the information is forced into a single cell rather than spread out into certain information in certain rows.
The cell count only has a limit of 255, and I'm copying probably a million characters and trying to put them into excel.
Is there any way for me to be able to copy page source data into excel so that it is formatted so that it uses more than one cell? I tried doing paste special but none of the options work properly. The only one that works is match destination but that forces everything into 1 cell. I also tried using word but I still have issues.
Thanks
I'm trying to do a cart scrape from a popular e-commerce site, and the only way I can do it properly right now is through the Page Source.
I'm coming across an issue where I'm trying to copy the page source data and putting it into excel, where all the information is forced into a single cell rather than spread out into certain information in certain rows.
The cell count only has a limit of 255, and I'm copying probably a million characters and trying to put them into excel.
Is there any way for me to be able to copy page source data into excel so that it is formatted so that it uses more than one cell? I tried doing paste special but none of the options work properly. The only one that works is match destination but that forces everything into 1 cell. I also tried using word but I still have issues.
Thanks