Opened 6 years ago

Closed 6 years ago

Last modified 6 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, 6 years ago

Description: modified (diff)

comment:2 by TobWen, 6 years ago

Description: modified (diff)

comment:3 by Even Rouault, 6 years ago

Resolution: fixed
Status: newclosed

In 41392:

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

comment:4 by Even Rouault, 6 years ago

In 41393:

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

comment:5 by Even Rouault, 6 years ago

Milestone: 2.2.4

comment:6 by Even Rouault, 6 years ago

In 41394:

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

Note: See TracTickets for help on using tickets.