Office js Custom XML

Question

I am trying to implement Custom XML parts feature in Office js.

While creating custom XML part in Excel, I am getting a GeneralException while adding the XML part in workbook.

I am fetching data from excel having 5000 rows and 4 columns.

I am encoding the data using Base64 encoding and storing the data in a XML tag in the following format -

My encoded data.

Are there any size limitation while adding a custom XML part in the workbook ?Is there any specific behind this error?

Example:

Excel.run(function (ctx) {
    var xmlObj = "<data>My encoded data.</data>";
    var xmlPart = ctx.workbook.customXmlParts.add(xmlObj);
    return ctx.sync();
});

Could you provide an example of the code you're using and the data you're encoding? — Marc LaFleur
@MarcLaFleur-MSFT - I am using the following code to add the XML object to the workbook. Excel.run(function(ctx){ var xmlObj = Here goes my XML object; var xmlPart = ctx.workbook.customXmlParts.add(xmlObj); return ctx.sync(); }); — Arupam Sengupta
@MarcLaFleur-MSFT - I have tried to add the XML object without encoding, it is failing for the same threshold. — Arupam Sengupta

Zlatko Michailov - MSFT Zlatko Michailov - MSFT · Accepted Answer · 2017-10-12T18:22:31

Thanks for bringing this issue to our attention! I was able to repro the behavior on a blank workbook against excel.exe. It is due to a bug that we will try to fix in the nearest future. Sorry for the inconvenience. Please stay tuned for Excel updates.

Office js Custom XML

2 Answers