SpreadServe Tech SpecΒΆ

Technical specification

SpreadServe is a Windows Server hosted server product with a web UI.

  • OSes: any Windows desktop OS from Windows 7, and any server OS from 2003. SpreadServe has been tested on Windows 7, Windows 8, Windows Server 2008 & 2012.
  • User interface: web UI built with Angular 1.5, <http://Bootstrap 3.3 and jQuery 2.2 enabling job control and spreadsheet interaction from a browser.
  • APIs
    • Python: the best API for Web integrations, as well as rapid, ad hoc development. SpreadServe uses Python 2.7.8, 3.x is not yet supported.
    • C++: the best API for high performance systems integration. For example, this is the right way to connect SpreadServe to a low latency pub sub messaging system like TibRV or Solace. Integrations should be built with MS Visual Studio 2008 or later.
    • REST: external processes can drive SpreadServeEngines via the RealTimeWebServer REST API.
    • Java: the best option for relational database integration with JDBC. spreadserve.jar is built with JDK 1.6.
  • Core implementation: SpreadServe’s native implementation language is C++ built as 32 bit binaries with Microsoft Visual C++ 9.
  • VBA: SpreadServe supports VBA macros, but does not support VBA GUI operations.
  • XLL: SpreadServe supports XLL addins, and has been tested with the QuantLib 1.4.0 addin.
  • RTD: SpreadServe supports RTD updates.
  • Excel file formats: Excel 97-2003 .xls as well as the default Excel .xlsx format are supported.
  • RDBMS: the dblog component enables logging of all SpreadSheet operations to an RDB. SpreadServe has been tested with MySQL 5.6, and should work with any RDB that has a JDBC driver.
  • Sockets: The SocketServer enables connections from processes based on other hosts and implementation technologies.
  • Open Source Software: SpreadServe uses several powerful OSS technologies as building blocks. They include Tornado, Python, STLport , Boost and Apache Open Office.
  • Cloud ready: SpreadServe has been deployed and tested on Amazon EC2 Windows 2008 & 2012 AMIs.