HTML Connector Improvements


Version: 2023b

Type: Features

Category: Data Handling

Subcategory: Import

Jira: ORG-26498


  1. URL info. in Book title and left Navigation Panel.

  2. Table name will be imported as sheet name, renamed sheet name will be kept when reimporting.

  3. After import one table, list all available tables on left Navigation Panel

  4. Right click tables to easily import one or multiple tables to new sheets or active sheet.

  5. When import multiple tables into one sheet, then set table name to Table label row.

  6. Options context menu added on data connector icon to set partial column import using same syntax as CSV connector.

  7. Post Import Script. context menu added to add script when importing or reimporting data.

  8. Labtalk Improvements:

    1. wbook.dc.nav = 0 to hide left Navigation panel, wbook.dc.nav = 1 to show the panel.

    2. wbook.dc.url$ (readonly) to get url string

    3. wks.dc.add() to add table to active sheet

    4. wks.dc.optn$ to set partial import and script

//import table _2 and then append table _9 as new columns in same sheet
newbook;
wbook.dc.add("HTML");
wbook.dc.source$="https://www.extremeweatherwatch.com/cities/boston/year-1993";
wks.dc.sel$="Tables/_2";
wks.dc.import();
wks.DC.flags=0; //0: append new columns, 256: append new rows.
wks.dc.add("Tables/_9");

//import multiple tables in same sheet, for each table only import 2:3 columns. 
//table name only from 2nd char on and show as calendar 3 char month format 
newbook;
wbook.dc.add("HTML");
wbook.dc.source$="https://www.extremeweatherwatch.com/cities/boston/year-1993";
wks.dc.sel$="Tables/_2|Tables/_3|Tables/_4";
Tree tr = wks.dc.optn$;
tr.partial_col$="2 3";
tr.nameoptn$="2:0";//Keep table name from 2nd char on. Use "2" to show 2nd char only
ToString(wks.dc.optn$);
wks.dc.import();
wlabel ty:="table" fmt:="CM0"; //show calendar month Feb, Mar, Apr in Table row

//import multiple tables into same sheet by appending row after row
newbook;
wbook.dc.add("HTML");
wbook.dc.source$="https://www.extremeweatherwatch.com/cities/boston/year-1993";
wks.dc.sel$="Tables/_2|Tables/_3|Tables/_4";
wks.dc.flags=256;
Tree tr = wks.dc.optn$;
tr.partial_col$="2 3";
tr.ToString(wks.dc.optn$);
wks.dc.import();