I am having problems with the Excel driver for writing results. It is not
properly clearing out old results.
Since I’m on 64-bit hardware and operating system, I need to use the newer
versions of Excel (that ones that write to .xlsx files). I am also on Windows
10.
Using the latest GLPK build (4.65), I modified the example sudoku_excel.mod
by these two changes:
In line 50:
'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
*.xlsb)};dbq=.\sudoku.xlsx'
And in line:
'DRIVER={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
*.xlsb)};READONLY=FALSE;dbq=.\sudoku.xlsx'
Also, I saved the existing sudoku.xls into the newer format and called it
sudoku.xlsx
When I run the problem **twice** from the examples\sql directory, using the
command line:
..\..\w64\glpsol.exe --model sudoku_excel.mod
I find that the solution has 81 blank rows, then the solution starts on row 83.
So while the ‘UPDATE’ statement clear out the old results, it begins to put
the new results below.
