[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel driver for output not working as expected

From: Meketon, Marc
Subject: Re: Excel driver for output not working as expected
Date: Fri, 20 Dec 2019 20:14:02 +0000

Can’t say I did anything special to get the Sudoku_Excel.mod to work.

I did change from version 4.63 to 4.65 this morning. And this is on a different 
Windows 10 64bit computer.

I would be surprised if either of those changes mattered.

Sent from my mobile

> On Dec 20, 2019, at 2:37 PM, Heinrich Schuchardt <address@hidden> wrote:
> On 12/20/19 4:32 PM, Meketon, Marc via Bug reports for GLPK (GNU Linear
> Programming Kit) wrote:
>> 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.
> Hello Marc,
> I think this problem is not new. The Excel driver does not support
> delete as mentioned in sudoku_excel.mod. For productive use I would
> suggest to use a SQL database like MariaDB.
> How did you get ODBC finally running with Excel after all the problems
> you got into?
> Best regards
> Heinrich

reply via email to

[Prev in Thread] Current Thread [Next in Thread]