Script Scraper

Pull Data from the Internet into Excel Spreadsheets.

ExcelWorkSheet

Constructor: ExcelWorkSheet(sheetname, labels)

sheetname

The name of the sheet that can be seen at the bottom of the Excel sheet. Each new sheet must have a unique name

labels

An array of labels that are applied into the sheet in the $result.label[0].

addRows(excelDataRows, columnNames)

excelDataRows

An array of hashtables, the hashtables have keys that corrospond to the column names provided in the second argument.

columnNames

An array of labels that are used as the column names.