When exporting to MS Excel file using XLSX driver, if the data contains more than 26 columns, users will see a few columns gap between columns 26 and 27.
|Reported by:||blokeshkumar||Owned by:||warmerdam|
While Using XLSX driver there is a gap between 26th column and rest of the columns. For example After column z, Columns AA to Columns AZ are empty only BA has the next column. I use Postgres data source.
ogr2ogr -f "XLSX" Drive://ticketTest.xlsx PG:"host=localhost user=xxx dbname=xxx password=xxx" -sql "select * from f_wsystemvalve"
I even tried converting from csv to XLSX using XLSX driver.Issue is reproducible. Can you please help me in this regard. Is there any option to make this work properly or any work around ?. Kindly help me in this regard.