| layout | title | categories | parent | weight |
|---|---|---|---|---|
post |
Excel that Scales Solution |
SBP |
data-access-patterns.html |
500 |
{% tip %}
Summary: Available functionality, how to develop the integration components and how to configure, deploy and run the GigaSpaces-Excel solution.
Author: Pini Cohen, GigaSpaces
Recently tested with GigaSpaces version: XAP.NET 6.6
Contents:
{% toc minLevel=1|maxLevel=1|type=flat|separator=pipe %}
{% endtip %}
This section gets you started with the Excel integration by understanding its available functionality, how to develop the integration components and how to configure, deploy and run the solution.
Along with several examples that can be used as starting points for development, it includes supported platforms and a short description of testing that was performed to validate the proposed patterns.
There are two main problems that the GigaSpaces-Excel solution is relevant for:
{: .table .table-bordered}
| -- You are working with a very large amount of data, which causes Excel to slow down or freeze
- However, you need only a portion of your data to be displayed in Excel at a time
- You need the spreadsheet to be updated constantly | 
| Data offload |
| -- You are performing very complex calculations, or a large amount of calculations in Excel
- These calculations are costly
-- they cause Excel to slow down or freeze; or slow down other applications | | Calculation offload |