匯出了數值，未必保到工作表功能

import assert from 'node:assert/strict';
import {spawnSync} from 'node:child_process';

const run=function run(i,corrected=true){
    if(!['xlsx','csv'].includes(i.format))return {held:true};
    const python=`import io,json,csv,sys
from openpyxl import Workbook,load_workbook
from openpyxl.comments import Comment
from openpyxl.worksheet.datavalidation import DataValidation
i=json.load(sys.stdin)
w=Workbook();s=w.active;s["A1"]="A";s["A1"].comment=Comment("Discussed","Reviewer")
v=DataValidation(type="list",formula1='"A,B"');s.add_data_validation(v);v.add(s["A1"])
if i["format"]=="xlsx":
 b=io.BytesIO();w.save(b);b.seek(0);r=load_workbook(b).active;rule=r.data_validations.dataValidation[0]
 out={"value":r["A1"].value,"commentText":r["A1"].comment.text,"validation":{"type":rule.type,"formula":rule.formula1,"range":str(rule.sqref)}}
else:
 b=io.StringIO();csv.writer(b).writerow([s["A1"].value]);b.seek(0)
 out={"value":next(csv.reader(b))[0],"commentText":None,"validation":None}
print(json.dumps(out))
`;
    const result=spawnSync(process.env.PYTHON||'python',['-c',python],{input:JSON.stringify({format:corrected?i.format:'csv'}),encoding:'utf8',windowsHide:true});if(result.status!==0)throw new Error(result.stderr);return JSON.parse(result.stdout);
  };
const cases=[{"input":{"format":"xlsx"},"corrected":false,"expected":{"value":"A","commentText":null,"validation":null}},{"input":{"format":"xlsx"},"corrected":true,"expected":{"value":"A","commentText":"Discussed","validation":{"type":"list","formula":"\"A,B\"","range":"A1"}}},{"input":{"format":"csv"},"corrected":true,"expected":{"value":"A","commentText":null,"validation":null}},{"input":{"format":null},"corrected":true,"expected":{"held":true}}];
for(const test of cases){const actual=await run(test.input,test.corrected);assert.deepEqual(actual,test.expected);console.log(actual);}