Helium Scraper

Hi all,

I have just started using this tool and my scrape works fine. I see the data in the columns and in intended format but when I try to export to Access/CSV only a part of the field is exported. I have manually copy-pasted one cell into excel and I found that there are line breaks.

For ex: the cell looks like: Pampers Sensitive Baby Wipes384ct. Refill in Helium Scraper but when export the table only Pampers Sensitive is exported.

The following is the copy-paste of the description directly from Helium Scraper:

Pampers Sensitive
Baby Wipes
384ct. Refill


Is there a way to go around this problem? Thanks!

Hi,

The other lines are probably just hidden below the first one. Try coping the cell with missing text from spreadsheet editor and pasting it into Notepad to see if you get the whole text.

If you still want to extract it as a single line you can use the SingleLineInnerText property instead of InnerText.