xlsgen 4.0 makes it possible to import web pages.

Many web pages include HTML-based table data that a business application may be interested in importing in a regular spreadsheet.

An arbitrary URL can be passed to the Open() method. It is also possible to customize the import (column styles including number formats, header style). And to import a web page stored in a memory buffer.

The internal xlsgen algorithm parses the HTML markup, finds tables, aggregates data in it, and imports the most consistent set.

Here is an example.

The URL is http://www.insee.fr/fr/themes/info-rapide.asp?id=10&date=20150807

A screenshot of which is :


xlsgen can import a web page

And the resulting data in the spreadsheet is :


xlsgen can import a web page in a spreadsheet