Problem description & analysis:
There are multiple csv files of same structure in a certain directory:
Task: Take the first line of each file (without column headers) and write them to an Excel file.
Solution:
Write the following code in SPL IDE:
=T("result.xlsx": directory@p("D:\\data\\*.csv").(T(~)(1)))
Explanation:
directory@p lists file names with full paths according to the wild character. T()function reads files or writes data to a file as a specified format according to the file extension; ~ is the current member, and (1) represents the first line.