[gdal-dev] Problem writing with ODS and XLSX drivers
stephenwoodbridge37 at gmail.com
Sat Sep 12 10:40:17 PDT 2020
I'm wondering if there are unicode characters that are not properly
formated when output to the xlsx or ods files. If the CSV export takes a
different export and import path that handles correct conversion, maybe
that is not the case for the binary files.
I would try to locate 1-2 records from the shp file that cause this
problem then submit that to a bug report.
You should be able to apply a where clause to the export to select only
a subset of the records when you export.
On 9/12/2020 1:21 PM, Hernán De Angelis wrote:
> That was a very good piece of advice. Unfortunately that is apparently
> not the problem. The CSV imports cleanly in Libreoffice, with the same
> number of rows (minus title row) as features are in the shp. No trace
> of misplaced linefeed or carriage return characters. I will have to
> keep looking for solutions. Thanks anyway!
> On 2020-09-12 18:56, Stephen Woodbridge wrote:
>> Try exporting to CSV and check the that the records do not have any
>> embeded <CR> or <LF> chars. One simple way to do this is to compare
>> the record count of the shp file to the line count of the CSV file.
>> Try importing the CSV file into EXCEL or Libreoffice and see if it
>> reports a problem. This may give you a better idea of what the
>> problem is.
>> -Steve W
>> On 9/12/2020 11:20 AM, Hernán De Angelis wrote:
>>> Hi everyone
>>> I am experiencing an odd and stubborn problem when trying to export
>>> attribute tables from both shp and spatialite to ods or xlsx.
>>> ogr2ogr finishes work silently with no reported errors but the
>>> generated output files cannot be opened with Libreoffice, which says
>>> the file is corrupted and is even unable to repair it.
>>> The input files are good from what I can see using QGIS and OGR but
>>> it is clear that something isn't right in my installation, my
>>> procedure or somewhere else. I am missing something? Have other
>>> users experienced this?
>>> I am using GDAL/OGR 3.1.2 in openSUSE Tumbleweed, compiled against
>>> expat 2.2.9-1.12 (devel packages installed too, of course).
>>> Any hint is appreciated!
>>> gdal-dev mailing list
>>> gdal-dev at lists.osgeo.org
>> gdal-dev mailing list
>> gdal-dev at lists.osgeo.org
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
More information about the gdal-dev