search

dhatim / fastexcel

Generate and read big Excel files quickly
Other
675 stars 122 forks source link

Woorkbook Subject/Title #164

Closed ghost closed 1 year ago

ghost commented 3 years ago

Is it possible to set the title of an Excel file? That is, the title that can then be queried in the programme under Information.

ochedru commented 2 years ago

Do you mean the "title" attribute that appear in the "summary" tab of the "properties" dialog box in Excel?

meiMingle commented 1 year ago

@ochedru Hello, I am working on this issue, but I have encountered some problems, and I would like to ask you for advice. When setting custom attributes, the fmtid and pid attributes in the custom.xml file are both necessary. Among them, pid I guess is an index value that increases with the number of attributes. The value of fmtid looks more like it is created by some method calculated, because modifying any character in the value will report an error when open the xlsx file created. This fixed value is copied from a file created by MicrosoftExcel. Do you have any suggestions for this? The relevant code is in line 154~196 of the Properties.java file branched below https://github.com/meiMingle/fastexcel/tree/feature-support_setting_properties