The problem is that the receiving service outputs a number of error messages about missing values.
The values are not missing, and after I open the xlsx in Excel, and then save it again from there, it is imported without problems.
I tried the following, because I had done something similar in XLSReadWrite v4:
Any tips on how to tweak the object before saving?
Code: Select all
xls.CalcDimensions; for i := 0 to xls.Count - 1 do begin xls.Sheets[i].CalcDimensionsEx; xls.Sheets[i].Protection.Clear; end;
(XLSReadWrite v6.01.10 on Delphi 2010, but the same happens in Delphi 6)