- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] I want to execute recalculation according to the formula which is set in the cell by Excel adapter.
Search via FAQ No.
NEW
[DataSpider Servista] I want to execute recalculation according to the formula which is set in the cell by Excel adapter.
After writing a value to Excel by the Excel Adapter, I want to recalculate according to the formula which is set in the cell. Is it possible?
- Category :
Answer
■In the case of xlsx format
Starting with DataSpider Servista 4.0, formula recalculation is performed when opening an Excel book that has been written using the Excel adapter write process and cell specification write process.
■In the case of xls format
If recalculation processing is required, call and execute another application from [External application start].
As an example, it is possible by creating a VBScript that expands, recalculates, and saves Excel files and calling from External Application Launch.
Please refer to the online help for reference information for details on [External application start].
*Customers need to create external applications for Excel file expansion, recalculation and storage. Also, please be aware that we can not guide you on how to make it.
Reference information
- Launch External Application