In Excel API, I can't choose cells based if they have formulas or values.
In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.
Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64
We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.
With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.164 votes
Hello! the API is in preview now! Make sure to have the latest insiders fast and use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec
Here is a sample code snippet using the API
key line of code context.workbook.worksheets.addFromBase64(mybase64)
send an xlsx (base64 encoded)
please use it and send us feedback!
Please add the ability to create, delete, and modify Excel Comments on specific cells using Office.js153 votes
The comments API is in BETA now! please give a try! install insiders fast, use our beta CDN and try it!
let us know your feedback!
I would like to be able to access the page layout properties of the document so that I can set the print area.13 votes
pagelayout object is in preview! pelase try it and send us feedback.
Check out https://aka.ms/excelapiopenspec
- Don't see your idea?