• No : 30483
  • Open Date : 2019/08/23 16:52
  • Print
NEW

[DataSpider Servista] Due to the end condition was set in an Excel adapter; it has been read all data to the end.

Even though the end condition was set in [Specify reading end condition] in [Read from sheet] process of the Excel adapter, it has been read to the end. I have confirmed that the known issues DSS-9008 and DSS-11800 were not applicable. Please tell me the cause and workaround.
 
Category : 

Answer

■Cause
 
If there is no value in the specified end condition column, it will not be evaluated as the end condition. As a result, if the other end conditions and the logical operator was combined by AND. The data will be read to the end because all the conditions do not become true.
 
This problem only occurs with Excel files with the extension "xls".
 
■Workaround
 
Please refer to the following for the solution method.
  • In [Specify reading end condition], specifying a column that has a row with at least one value.
  • using a file saved with the extension "xlsx" in Excel.