Office Js - Excel Set a Cell with Base64 Content

Question

We are using Excel Add-in side loaded for our application. I am trying to Set a Cell Value in Excel with Base64 Encoded content (that has formatted content). I see example of how set base64 encoded image but not the text content with formatting. I am able to insert simple text with below code but could not find a way to set base64 content into a cell.

I am looking at Office Js Excel https://learn.microsoft.com/en-us/javascript/api/excel/excel.range?view=excel-js-preview

Excel.run(async (context) => {
var activeCell = context.workbook.getActiveCell(); // get current active cell
activeCell.load(['address', 'values']);
await context.sync();

let newRange = activeCell.getOffsetRange(0,1); // right of the current cell where base64 content must be inserted
newRange.load(['values']);
await context.sync();
 
newRange.values = insert base 64 content??

I greatly appreciate any pointers you may have

Office JS do not support at this moment, would you please share a bit more on your scenario? therefore we can discuss what we can do to support you with existing API. thanks. — Raymond Lu
– Raymond Lu, Commented Jun 16, 2021 at 2:16
Thanks for your response. We have several docx contents (with bullets, bold, color text, tables, etc) stored as base64 encoded string in database. I am trying to programmatically insert these base64 strings into the cell. I am able to successfully insert docx base 64 into word via side loaded Add-in but cannot in excel so far. Thanks in advance — user2596892
– user2596892, Commented Jun 16, 2021 at 2:26

Raymond Lu · Accepted Answer · 2021-06-20 01:46:56Z

0

Office Js current do not support set cell value from base 64 string, I have created a backlog (5193490) for this feature internally, would you please submt your request on this site and upvote your request? thanks.

https://techcommunity.microsoft.com/t5/microsoft-365-developer-platform/idb-p/Microsoft365DeveloperPlatform

answered Jun 20, 2021 at 1:46

Raymond Lu

2,2561 gold badge8 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2596892 Over a year ago

I just did techcommunity.microsoft.com/t5/microsoft-365-developer-platform/…

user2596892 Over a year ago

Is there a timeline of when this may be available?

Collectives™ on Stack Overflow

Office Js - Excel Set a Cell with Base64 Content

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related