Laserfiche WebLink
Spreadsheet Integration TSTool Doc umentation <br />Spreadsheet Integration - 4 <br />Feature TSTool Excel <br />NaN , -999 ). missing values will not generate <br />errors . <br />Data units Handled transparently in most cases, <br />based on units in time series <br />metadata , with c hecks in place to <br />prevent incompatible manipulation. <br />No specific handling. User must <br />guard against incompatible <br />manipulation. <br />Data validation Commands are available to check and <br />compare data. <br />Formulas can be used , can enable <br />data validation for input controls . <br />Software/logic testing Built in framework and commands <br />available to automate testing . <br />Not sure. <br />Logging Built in, with text log file. Not sure. <br /> <br />10 .2 R unning TSTool f rom Excel <br /> <br />Reasons for running TSTool from Excel include: <br /> <br />• TSTool is used to acquire and/or process data as input to Excel <br />• TSTool performs an analysis/visualization function <br /> <br />To run TSTool from Excel, run it like any other external system call, using a VBA macro in Excel (see: <br />“How to Launch a Win32 Application from Visual Basic http://support.microsoft.com/kb/129797 ). <br />TSTool can be run in batch mode using a command line: <br /> <br />TSTool –commands CommandFile.TSTool <br /> <br />See the Getting Started chapter for more information about running TSTool in batch mode. In the <br />future, a TSTool server mode may be implemented t o allow Excel to “drive” TSTool, for example using <br />REST web services. <br /> <br />10.3 Running Excel from TSTool <br /> <br />TSTool can run Excel by using its RunProgram() command, and appropriate Excel command -line <br />switches (see : http://office.microsoft.com/en -us/excel -help/command -line -switches -for -excel - <br />HA010158030.aspx ) (is there a better reference, for example to explain how to run in headless mode and <br />exit?). <br /> <br />It also is possible to run an d control Excel. However, this is not integrated into TSTool. One option is to <br />use the TSTool RunPython() or RunProgram() command to run an IronPython script, which then <br />interacts with Excel. For example, see: <br /> <br />http://www.ironpython.info/index.php/Inter acting_with_Excel <br /> <br />10.4 Manipulating Excel Files from TSTool <br /> <br />Excel files (*.xls , *.xlsx ) contain the definition of a workbook, worksheets, data, formulas, formatting, <br />charts, and other information. Excel files are complicated and can be difficult to man ipulate, especially <br />when trying to ensur e that different versions of Excel files are properly handled. Although it may be <br />possible to modify the files directly (e.g., search and replace strings in the *.xlsx XML), this can lead to <br />file corruption. <br />132