Previous topic  Top  Next topic  Print this Topic
 

Excel Connector

 
1.Excel connector was renamed from _spreadsheet to _excelaccess.
2.Output function F(..) was replaced with a map term.
3.Arity changed from 8 to 7: no attribute-column is now required.
4. Tuple cache added.
5.The connector now supports Excel 2010 (format xlsx).

The old connector is no longer supported. It is now possible to get a row number:

_excelaccess([_row->?R, 2->?X], "file.xls", "table1", 1, 10, 2, 4).

Example

Old connector:

_spreadsheet(F(?X,?Y), "file.xls", "table1", 1, 10, 2, 4, 2).

New connector:

_excelaccess([2->?X], "file.xls", "table1", 1, 10, 2, 4).