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.144 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!
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
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.
Happy to report that some of the functionalities are already in the product (all the basics for creating Pivots!) and some in preview (i.e. advanced filtering, calculated fields) .
please see the details here.
Add User Defined function support to the Apps for Office Excel APIs so that users can enter formulas in excel. User Defined Functions are one of the most powerful features of Excel (and some competitor spreadsheets products now available in the web). They are critical for us to make our Apps for Office product as powerful as our legacy on premise product.328 votes
Custom functions are officially in Preview! Try them! more info in https://aka.ms/customfunctions
- Don't see your idea?