Opened 11 months ago

Closed 11 months ago

Last modified 11 months ago

#7225 closed defect (fixed)

problems with updating XLSX

Reported by: TobWen Owned by: warmerdam
Priority: normal Milestone: 2.2.4
Component: default Version: svn-trunk
Severity: normal Keywords:
Cc:

Description (last modified by TobWen)

There seem to be some problems with updating XLSX files in trunk:

This works great: ogr2ogr myfile.xlsx demo.dbf -nln first

According to the documentation, it should be possible to update XLSX files. But these variants create a file that Excel can no longer read (tested using the "clean" myfile.xls from the first command):

ogr2ogr -overwrite myfile.xlsx demo.dbf -nln second
ogr2ogr -append myfile.xlsx demo.dbf -nln second
ogr2ogr -update myfile.xlsx demo.dbf -nln second

Edit: Download demo.dbf from here: https://transfer.sh/HsA7c/demo.dbf

Change History (6)

comment:1 Changed 11 months ago by TobWen

Description: modified (diff)

comment:2 Changed 11 months ago by TobWen

Description: modified (diff)

comment:3 Changed 11 months ago by Even Rouault

Resolution: fixed
Status: newclosed

In 41392:

XLSX: fix updating multi layer document where existing layers where dropped (fixes #7225)

comment:4 Changed 11 months ago by Even Rouault

In 41393:

XLSX: fix updating multi layer document where existing layers where dropped (fixes #7225)

comment:5 Changed 11 months ago by Even Rouault

Milestone: 2.2.4

comment:6 Changed 11 months ago by Even Rouault

In 41394:

ogr_xlsx.py: test updating an existing document (refs #7225)

Note: See TracTickets for help on using tickets.