Opened 5 years ago

Closed 5 years ago

Last modified 5 years 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 by TobWen, 5 years ago

Description: modified (diff)

comment:2 by TobWen, 5 years ago

Description: modified (diff)

comment:3 by Even Rouault, 5 years ago

Resolution: → fixed
Status: new → closed

In 41392:

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

comment:4 by Even Rouault, 5 years ago

In 41393:

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

comment:5 by Even Rouault, 5 years ago

Milestone: → 2.2.4

comment:6 by Even Rouault, 5 years ago

In 41394:

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

Note: See TracTickets for help on using tickets.