Xls/Xlsx file author

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Xls/Xlsx file author

Post by d3nton »

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

Thank you & Best regards
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Xls/Xlsx file author

Post by larsa »

Hello

You can't right now but it will be possible in update 5.20.07, ready by the beginning of next week. See release notes for details.
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Xls/Xlsx file author

Post by d3nton »

Thank you :-)
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Xls/Xlsx file author

Post by d3nton »

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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Xls/Xlsx file author

Post by larsa »

Hello

Fixed in update 5.20.11
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Xls/Xlsx file author

Post by d3nton »

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.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Xls/Xlsx file author

Post by larsa »

Hello

You can't set these kind of properties for xls files as they uses a completely different interface that is not supported.
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Xls/Xlsx file author

Post by d3nton »

OKay thanks. What about changing the author/lastModifiedBy in an already existing file?
How can I do this?
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Xls/Xlsx file author

Post by larsa »

Hello

I can't reproduce this. Tested with update 5.20.11
Lars Arvidsson, Axolot Data
d3nton
Posts: 137
Joined: Thu Oct 25, 2012 9:48 am

Re: Xls/Xlsx file author

Post by d3nton »

Yes, thanks. Works for me now.
qwertehok
Posts: 13
Joined: Tue Jan 28, 2014 12:45 pm

Re: Xls/Xlsx file author

Post by qwertehok »

hi
show a small example of the author\version in xlsx files
Post Reply