Axolot Data

Meanwhile I found it.

TXLSWorksheet.Visibility

Unfortunately the value of 'Visibility' is always 'x12vVisible' after calling 'Read'.
What is to be done to get the correct value of 'Visibility'?

I would like to know how I can determine whether an Excel sheet is visible or hidden.
Could not find a property or function of TXLSWorksheet which gives me this information.

Thanks in advance.

But there is no package project, only the .pas sources.

I am still interested in an answer how to re-enable 64 bit support for C++ Builder.
I remember in the past there was a separate install program.

Sorry, but I don't have the sources to recompile.
I think it is your part.

Has the 64 bit support (C++ Builder) been canceled?
I can't find any XLSRWII5_DXE7.a file.

There is not a strict prohibition for the use of qualifiers in capitals. But it is common sense.
Try to name a qualifier ASSERT or ERROR, you will get funny error messages.

On the other hand I have no problems to comment the EOF line out in every new version of XSLSReadWrite.

Markus

No, that's definitively not correct. Names that contain capitals only are reserved for macros in C++. And a macro EOF exists!

On March 13 you wrote:
"The EOF method is removed. Was not used anyway."

Markus

The current version is not able to create Excel2007 files. This error did exist a couple of versions before but then it vanished. Not it is here again: TDateTime dt(TDateTime::CurrentDate()); for(int i=0; i<Lines; i++) XLSReadWriteII51->Sheets[0]->AsDateTime[0][i] = dt + double(i+1)/96.; XLSReadWrit...

Congratulations! Now all works fine.

Hello,

It seems to be the same version (with the same problems) as before (5.10.09).

Markus

In the meantime I have found out that 'AsDateTime' fails if the double value of the TDateTime value has more than 4 digits after the decimal point.

Markus

Now it seems that 'AsDateTime' is completely broken:
In the Excel file the value is 00.01.1900 00:00

By the way, 'TXLSTokenizer.EOF' still exists, also in version 5.10.09.

Markus

No, the problem exists in version 5.10.08 too.
Also TXLSTokenizer.EOF is still present.

Markus

In version 5.10.05 it was not possible to write this to an Excel97 file: try { int Lines = 96; XLSReadWriteII51->Version = xvExcel97; XLSReadWriteII51->Sheets[0]->Columns->Items[0]->Width = 5000; TDateTime dt(TDateTime::CurrentDate()); for(int i=0; i<Lines; i++) XLSReadWriteII51->Sheets[0]->AsDateTi...