Axolot Data

OKay thanks. What about changing the author/lastModifiedBy in an already existing file?
How can I do this?

Thank you .Works now for xlsx files but unfortunately not for xls files.
Also I cannot set the author or the lastModified property (xlsx/xls) if i write into an already existing file.

thank you ! I am very sorry to bother you again, but there are also some small other issues:in XLSReadWriteII5.pas line 42 {$define AX_SHAREWARE}. I removed this line to get rid of the xlsx watermark in the excel file. I think this was accidently applied to the code since the previous versions do no...

I got an 'file not found' error when compiling the latest version 5.20.11.
{$I XLSRWII.inc} in sereval units causes this issue.
Please help.

How do i set the author?
Each time i try to set the author via ExcelFile.DocProps.Creator = 'xxx' , procedure TXc12DocProps.SetCreator restursn nil for DocPropsCore.Root.Find('dc:creator');, so the author is not set.

Hi! Thank you very much for the fix. Unfortunately old hyperlinks are not recognized correctly if you add hyperlinks to an already existing file with hyperlinks which has previously been created with XLSReadWrite. This worked in XLSReadWrite 5.20.02. I have seen that you implemented the fix in XLSRe...

Hi! The sample below creates an xls file with only one 'test' string in it. The FOR-loop simulates that a user writes to the same xls file several times adding new sheets to the file. If i use the procedure AutoWitdhCols to adjust the first column with the 'test' strings the file will become unusual...

Thank you

Thank you very much for your good support and the quick fix!

Hello.
The 'Date' and the 'Date last saved' timestamps are always set to 1/1/2000 instead of the correct value.
Please take a look at this picture:
http://www.file-upload.net/download-823 ... t.png.html.
Could you please fix this.
Thank you.

Hello.
How can I set the 'author' of a xls/xlsx file?

Thank you & Best regards

Hello.

Unfortunately it is not yet fixed in update 5.20.05. Now, I got an EIntOverflow in xpgPXML.pas
function TXpgReadXML.QNameHashB: longword; in the while loops:
->a := a * 378551;

Thanks for your help.

I got an error: 'Unknown Element "xdr: col" exception' when reading this xlsx file: http://www.file-upload.net/download-8184511/test.zip.html It seems that XLSReadWrite cannot read <xdr:oneCellAnchor> elements: see xml tag in xl\drawing\drawing1.xml. begin ExcelFile5 := TXLSReadWriteII5.Cr...

I tried to fix this on my own but only with limited success. My problem is, that I want to read a file with hyperlinks and add a new sheet in it. I do not really want to read the existing hyperlinks (i do not need the hyperlink addresses) but when reading the file, old hyperlinks will be destroyed, ...

Hi!
Any news on this?
Basic xlsm support as mentioned above would be nice.