Xlite: Query Excel and Open Document spreadsheets as SQLite virtual tables

The main purpose of this library is to allow working with spreadsheets from SQLite exposing them as virtual tables. Load libxlite This will load xlite module, now it can be used to create virtual tables. Xlsx', WORKSHEET 'Class Data', RANGE 'A2:F' ); Explanation: this statement will create a virtual table based on the. Optional RANGE parameter is used here to skip the first row in the table because in the sample spreadsheet it is used as a header. Class data; Columns are named according to their name in the spreadsheet. SELECT COUNT(*), D FROM class data GROUP BY D ORDER BY COUNT(*); Theoretically any operation supported by SQLite can be executed on the spreadsheet as long as it is supported by the virtual table mechanism. DROP TABLE class data; This statement will drop only the virtual table.