Homepage | About EASA | Contact
Sidebar
EASA Support for Excel Functionality
EASA supports a large portion of potential uses of Excel spreadsheets, but not all. Here are the functions that an EASA application can perform on an Excel spreadsheet:
- Read values from cells
- Write values into cells
- Set the Number Format in cells
- Clear values from cells
- Extract Charts and display as images
- Screen capture ranges of cells and display as images
- Run macros
This section provides a general listing of common Excel features and whether they are currently supported within EASA. When there are cases where the feature is not supported directly but an alternative approach exists, it will be described in the Alternative column.
| Excel Feature | Supported | Alternative / Notes |
|---|---|---|
| Read Cell Value | Y | |
| Write Value to Cell | Y | |
| 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 | Note: 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 | One known limitation is List type in which Source data is defined using a formula |
| Reference Cells by Name | Y | |
| Insert Rows or Columns | - | Possible by running a macro written for this purpose |
| Create Worksheet | ||
| 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) | - | Accomplished by running simple macro that runs .Calculate method |
| Form Controls | - | Only the Button is supported currently |
| ActiveX Controls | - | Only the Button is supported currently |