D
D
danykeep2014-03-05 19:07:32
PHP
danykeep, 2014-03-05 19:07:32

How to correctly enter information from an html page into an Excel spreadsheet?

Here is the page itself , you need to scroll a little to the table Food additives for food production , this table needs to be entered into an Excel spreadsheet, only you need it normally so that column to column, line to line, otherwise there will be a lot of redoing, but there will still be such documents .
Maybe the script needs to be thrown? Only now I don’t know how, not a programmer.
But if anything, it is possible for Linux, and it doesn’t matter what language, just the result is needed.
Thank you.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
rosperitus, 2014-03-05
@danykeep

Insert the selected table into Excel
If we want to get rid of the garbage, then next .. if not, then go to step 3
1 Replace (Ctrl-H) the "+" signs with the "|" signs
2 If you need to get rid of the "-" sign, but not kill the necessary minuses, then replace the "--" sign (two minuses) with any not used, for example "#", then replace the "#" sign with "" (empty)
3 Select the first column, menu (panel) Data - Text by columns, select with delimiters
Select the separator character "|", line terminator - NO, click
Finish highlighting all visible columns and clicking Remove Duplicates

A
Alexey, 2014-03-06
@HaJIuBauKa

reg_exp will help you, although if "not a programmer" .... then look for a programmer

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question