How can I read the data stored in the particular cell of the Excel spreadsheet?
Since version 6.5 AnyLogic provides Excel File – connectivity tool enabling easy platform-independent access to MS Excel 1997-2007 (.xls) files within AnyLogic models. Using that object you can: • Read Excel files and explore their content • Read individual cell values and formulas of different types • Read Anylogic table function contents • Read AnyLogic 1D and 2D [hyper]arrays • Create new cells • Write to individual cells and change their type • Write AnyLogic datasets to Excel spreadsheets • Save modified spreadsheets Please have a look at the following demo model. It includes detailed instructions on how to use Excel File in your projects.
