Laserfiche WebLink
TSTool Documentation Spreadsheet Integration <br /> Spreadsheet Integration - 3 <br />Feature TSTool Excel <br />Processing work flow <br /> <br />Sequential, first command to last <br />(subset of commands can be <br />executed). <br />Based on cell formula dependencies. <br />(Excel contents are kept up to date as <br />per cell contents and user <br />interactions). <br />Transparency <br /> <br />Commands and data are visible as <br />text, can review sequential <br />processing. <br />Formulas can be viewed, sequence of <br />processing is determined by Excel <br />based on cell dependencies and may <br />not be obvious to user . <br />Data identifiers Time series and tables have <br />identifiers. Time series also have <br />aliases. Time series identifiers are <br />based on TSTool conventions and <br />data from the original source. <br />Named ranges can be assigned and <br />Excel allows tables to be defined <br />using column headings. <br />Data size limitations None, other than memory of <br />computer and Java virtual machine . <br />Excel row and column limits vary by <br />Excel version. <br />Scalability Built into design of data management <br />and processing, for example with <br />TSList command parameter s that <br />accept wildcards, database query <br />filters, and templates. <br />Add mor e worksheets, columns, and <br />rows. <br />Templates Used to scale processing of large <br />amounts of data. <br />Not available (have to replicate <br />worksheets, rows, columns). <br />Automation Fundamental part of TSTool design. Workbooks tend to be an <br />accumulation of data and processing, <br />although Excel can be called in a <br />process to perform specific work. <br />Command line (batch <br />mode) <br />Run with: tstool –commands … Can run excel.exe with switches. <br />Time series graphs • Built in with default properties <br />• Extensive graph properties <br />• Can automate graphs using text <br />time series product files and <br />ProcessTSProduct() <br />command. <br />• Focus on time series, not general <br />data series <br />• Can graph different data intervals <br />on same chart <br />• Built in charts <br />• Use third party tools <br />• Time series can be graphed but <br />are essentially arrays of numbers <br />• Cannot easily graph different <br />intervals on same chart due to <br />grid formatting of data <br />Database connectivity • Integrated for specific datastores <br />• Use ODBC DSN defined for <br />Excel workb ook and <br />GenericDatabaseDataStore <br />• Use ODBC DSN defined for <br />Excel workbook <br />Accessing external data Use read commands to read from <br />standard file formats, databases, and <br />web services, including delimited <br />files. <br />Use features under the Data menu, <br />including accessing from databases, <br />web services, and files. <br />Missing data Handled transparently in most cases, <br />including special data values (e.g., <br />No specific handling, typically must <br />ensure blanks in data cells so that <br />131