11 lines
901 B
JavaScript
11 lines
901 B
JavaScript
import { FileBlob, SpreadsheetFile } from "@oai/artifact-tool";
|
|
|
|
const path = "/Users/lingniu/project/ai-coding/lingniu-vehicle-ingest/outputs/019fe9b9-eb60-7d22-8c0a-c70851a48083/100个真实车辆日氢耗核验资料包_V3/100个真实车辆日氢耗人工验算底稿_V3.xlsx";
|
|
const workbook = await SpreadsheetFile.importXlsx(await FileBlob.load(path));
|
|
for (const [sheetId, range] of [["100车辆日结果", "A53:AR53"], ["氢量计算明细", "A1:AF4"], ["运行周期明细", "A1:AU8"]]) {
|
|
const result = await workbook.inspect({kind:"table", sheetId, range, include:"values,formulas", tableMaxRows:10, tableMaxCols:50, maxChars:16000});
|
|
console.log(result.ndjson);
|
|
}
|
|
const errors = await workbook.inspect({kind:"match",searchTerm:"#REF!|#DIV/0!|#VALUE!|#NAME\\?|#N/A",options:{useRegex:true,maxResults:300},summary:"final formula error scan",maxChars:4000});
|
|
console.log(errors.ndjson);
|