JS宏解析csv

function tt()

{

const ret = []

for (const f of FileSystem.readdirSync(ThisWorkbook.Path)) {

if (!f.match(/\.csv$/i)) continue

const a = csv_parse_sync.parse(FileSystem.ReadFile(`${ThisWorkbook.Path}\\${f}`))

ret.push(...a)

}

Range('A1').Resize(ret.length, ret[0].length).Value2 = ret

}