Sidebar
Supported Excel functionality for an in-browser EASAP
An in-browser EASAP supports many features found within an Excel spreadsheet.
In general an in-browser EASAP may,
- Read a value from a spreadsheet cell
- Write a value into a cell
- Set the Number Format for a cell
- Clear a value from a cell
- Extract a charts and display it as an image in a browser
- Screen capture a range of cells and display it as an image
- Run a macros
Below is a list of supported Excel features for an in-browser EASAP.
To enable features that are not supported for an in-browser EASAP, an Excel Desktop Client EASAP allows a temporary, locally running Excel spreadsheet instance offering full Excel functionality to a User (See Excel Desktop Client EASAP vs. in-browser EASAP)
| Excel Feature | Supported | Alternative / Notes |
|---|---|---|
| Read Cell Value | Y | |
| Write Value to Cell | Y | WRITE EXCEL ACTION will use the first value in a range to define a cell type for the whole range |
| Read Formula in Cell | Y | |
| Write Formula to Cell | - | Possible by running a macro written for this purpose |
| Clear Value in Cell | Y | |
| Apply Number Format to Cell | N | |
| Run Macros | Y | See Macro-Related Issues for compatibility notes |
| Display Conditional Formatting | - | Similar behavior can be added manually into EASA application if used for highlighting or visibility |
| Modify Charts | - | Possible by running a macro written for this purpose |
| Replicate Data Validation | Y | |
| Reference Cells by Name | Y | |
| Insert Rows or Columns | - | Possible by running a macro written for this purpose |
| Create Worksheet | - | Possible by running a macro written for this purpose |
| Insert Picture | N | |
| Apply Data Filter | N | |
| Pivot Tables Control | - | Possible by running a macro written for this purpose |
| Linked Files | Y | Note: Linked files will need to be manually placed in correct locations on Excel Server |
| Data Sources | Y | |
| View Zoom | N | |
| Calculate Sheet Now (F9) | Y | |
| Forms | Y | Must be re-implemented using a FORM |
| Form Controls | Y | Button's are supported by the Excel Range Wizard other controls may be implemented in the Builder |
| ActiveX Controls | Y | Button's are supported by the Excel Range Wizard other controls may be implemented in the Builder |
| Add-ins | Y |