File Exchange > Data Connector >    HTML Connector

Author:
OriginLab Technical Support
Date Added:
12/20/2018
Last Update:
4/27/2023
Downloads (90 Days):
251
Total Ratings:
1
File Size:
42 KB
Average Rating:
File Name:
HTML Connector.opx
File Version:
1.79
Minimum Versions:
License:
Free
Type:
App
Summary:

Import HTML tables from an HTML file or website.

Screen Shot and Video:
Description:

Purpose
This App can be used to import HTML tables from an HTML file or a website. It can connect to the source file, when the source is changed, the imported data in Origin is also updated. Origin 2019b or later required.

Installation

  • This App is pre-installed in Origin. You can launch it from the Data menu or from the App icon on the Connector tab of the Apps Gallery, located at the right-side of the Origin workspace.
  • If you do not see the menu command or App icon, click Data: Connect to File: Add New.... The App Center opens listing only Connector Apps. Click the Download and Install button to install an App.

Operation

  1. With the worksheet active, click on the Data menu. If you are connecting to a file on your PC or network, click Connect to File: HTML. If you are connecting to a web file, choose Data: Connect to Web and enter a URL and click OK.  In the Data Connector Browser dialog, all tables in the file are listed as a tree. Double-click to select a table and click OK.
  2. Once a connector is added, click the connector icon in the upper-left corner of the workbook for a popup menu with various commands.
  3. By default, connector-imported data are NOT saved with the project file. To save a workbook's data with the project file, click the connector icon in the upper-left corner for that workbook and uncheck Exclude Imported When Saving. Note that each workbook has its own Exclude setting.

Updates:

v1.79 3/18/2023 Added post import script and partial table column import support.
v1.62 2/6/2023 Default to set sheet names and show data navigator.
v1.5 11/15/2021 Better numeric format detection, fix data row imported into unit.
v1.3 12/31/2020 Fixed localization bug.
v1.29 10/21/2020 Fixed reimport issues.
v1.27 5/15/2020 Fixed reimport bug when a worksheet has locks.
v1.26 4/20/2020 Supported data navigator.

Reviews and Comments:
07/11/2022noisseHTM WORK it's now or work !