- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] When you want to read the data of header part and detailed part of Excel sheet, how can it be specified?
Search via FAQ No.
[DataSpider Servista] When you want to read the data of header part and detailed part of Excel sheet, how can it be specified?
Excel contains a sheet wherein it is formatted as header part and detailed part. When the data of respective header part and detailed part is read, how can it be specified?
- Category :
Answer
In Excel adapter, "Read from Named Range" process is available. This excel adapter can perform reading process when the header part and detailed part on the Excel is specified by adding name for data reading range. Therefore, reading process is possible even if there is different data format such as header and detail.
*For details on the range specification of the Excel sheet, check Excel Help.
If you want to read the data defined in the distinct format in Excel sheet then use "Read from Named Range" adapter.