User Tools

Site Tools


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 FeatureSupportedAlternative / Notes
Read Cell ValueY
Write Value to CellY
Read Formula in CellY
Write Formula to Cell-Possible by running a macro written for this purpose
Clear Value in CellY
Apply Number Format to CellN
Run MacrosYNote: 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 ValidationYOne known limitation is List type in which Source data is defined using a formula
Reference Cells by NameY
Insert Rows or Columns-Possible by running a macro written for this purpose
Create Worksheet
Insert PictureN
Apply Data FilterN
Pivot Tables Control-Possible by running a macro written for this purpose
Linked FilesYNote: Linked files will need to be manually placed in correct locations on Excel Server
Data SourcesY
View ZoomN
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