Hot answers tagged

2

You can have one to three arguments in the VirtualXL() call. If you have only one, its the file name (as you have): CREATE VIRTUAL TABLE MyVirtualTable1 USING VirtualXL("C:\Users\[path-to-file]\TestExcelSheet.xls"); If you have two, the first is the file name, and the second is the worksheet index (since Excel supports multiple sheets within the file). ...


1

Couldn't find much documentation either, unless you want to dig deep into the sourcecode at the freexl page. But I think I figured it out after playing around a bit. Accessing sheets start counting from 0: create VIRTUAL TABLE mvt1 USING VirtualXL("C:\Users\[path-to-file]\TestExcelSheet.xls", 0); --Sheet1 create VIRTUAL TABLE mvt2 USING VirtualXL("C:\Users\...


1

The maintainer of ubuntugis has been rebuilding all packages related to gdal and the new geos libraries. Spatialite_gui should be available soon. Here's his message: Thanks for reporting this issue, I've rebuilt spatialite-gui for the geos transition in ubuntugis-unstable and uploaded the new revision (1.7.1-5~trusty3) to my staging PPA. I've ...



Only top voted, non community-wiki answers of a minimum length are eligible