Adding custom properties rebuilds the excel file

Hi Aspose support,

I added support for adding custom properties to an excel file.
I open the excel file, write custom properties and close it.
When looking at the excel file, I see that it looks like aspose is re-writing the whole file. If the file is large, it can take sometime, and in that time you can’t re-open the file as excel gives you a warning it can’t read the file.

Can I do something to bypass this behavior?

Regards,
T.

Hi,

Thanks for your good question and considering Aspose.Cells.

You can use the WorkbookMetadata class for this purpose. It will not resave or rebuild entire workbook and only change the custom properties.

Please check the following article for your more help regarding the sample code. Let us know your feedback.

( Using WorkbookMetadata|Documentation )

Hey,


Well, now it doesn’t rebuild the whole file, but deletes all the content and leaves only the custom properties.

My code:

Excel.WorkbookMetadata doc = new Excel.WorkbookMetadata(filename, new Excel.MetadataOptions(Excel.MetadataType.DocumentProperties));

doc.CustomDocumentProperties.Add(“text1”, “text2”);
doc.CustomDocumentProperties.Add(“num1”, 1);

doc.save(filename);


Thanks!

Hi Tzach,


Thank you for writing back.

We have evaluated the presented scenario while using the latest version of Aspose.Cells for .NET 8.6.2.6, and we are able to notice the said problem, that is; worksheet contents are getting removed after adding custom properties. We have logged this incident as CELLSNET-44144 for further investigation. Please spare us little time for proper analysis. In the meanwhile, we will keep you posted with updates in this regard.

Hello Aspose,

This is a major issue for us.
We found out that the new metadata is only supported on cells and only on xlsx. Using other Aspose products, the re-build of the file occurs without and this is bad as it takes time + the file loses data like Alternate Data Streams.
Please advice on the date in which all of our issues can be addressed.

Regards.
T.

Hi,

Thanks for your posting and using Aspose.Cells.

We have logged your comment in our database against this issue. We might not meet your requirements because it is not easy to work with the excel files without loading them fully. However, we will investigate it and see if something could be done about it. Once there is some news or other update for you, we will let you know asap.

Hi,

Please regard that we purchased priority support.
Please also advice other teams at Aspose on the requirement for having to write custom properties to a file without rebuilding it and losing data.

Hi,

Thanks for your posting and considering Aspose.Cells.

You have posted this issue in the Normal or Standard forum, you should post it in the Priority Support forum to increase the priority of your issue. Do you want to move this thread to Priority Support forum. If you will do so, then we will raise the priority of your issues to Priority support. Whenever user post an issue in the Normal or Standard forum, their issues are logged with normal priority.

Please note, when your thread will be moved to priority forum, we will decrease your Priority Quota by 1 which is allotted to you because you have one issue in this thread.

Please let us know your decision so that we could take necessary steps for these issues. You can also tell us that which of your issues you want to log with priority.

Also, if you want to log a request for all Aspose APIs, then please either create a thread in Aspose.Total forum or Aspose.Priority forum.

Let us know if you have any questions, we will look into it and help you asap.

Hi,

Thanks for your using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET v8.6.3.2 and let us know your feedback.

It contains the fixes of the issues CELLSNET-44144 and CELLSNET-44145.

The issues you have found earlier (filed as CELLSNET-44144;CELLSNET-44145) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.