floorplan-quotation/debug_excel_export.js

const { chromium }=require('playwright');
const fs=require('fs');
(async()=>{
  const browser=await chromium.launch({headless:true,executablePath:'C:/Program Files (x86)/Microsoft/Edge/Application/msedge.exe'});
  const page=await browser.newPage({viewport:{width:1200,height:900},acceptDownloads:true});
  page.on('pageerror',e=>console.log('pageerror',e.message));page.on('dialog',d=>d.dismiss());
  await page.goto('http://127.0.0.1:8931/AI%E5%BF%AB%E9%80%9F%E6%8A%A5%E4%BB%B7_Demo2.html?v=excel-test',{waitUntil:'load'});
  const data=fs.readFileSync('C:/Users/miao/Downloads/494f54100a93c5a6e0c90f404c597514.jpeg').toString('base64');
  await page.evaluate(d=>{qUploadedDrawing={name:'test.jpeg',type:'image/jpeg'};qUploadedDrawingUrl='data:image/jpeg;base64,'+d;qUploadedDrawingDataUrl=qUploadedDrawingUrl;qStartAnalysis();},data);
  await page.waitForTimeout(400);await page.locator('.q-furniture-tool').first().click();await page.evaluate(()=>qProceedFurnitureToDimensions());await page.waitForTimeout(400);await page.evaluate(()=>qFinishAnalysisNew());await page.waitForTimeout(400);
  const downloadPromise=page.waitForEvent('download');await page.getByText('导出Excel各柜体明细表（含基础与增值项）').click();const download=await downloadPromise;const path=await download.path();
  console.log({excelLoaded:await page.evaluate(()=>typeof ExcelJS!=='undefined'),suggested:download.suggestedFilename(),bytes:fs.statSync(path).size,step:await page.evaluate(()=>state.currentStep)});
  await browser.close();
})().catch(e=>{console.error(e);process.exit(1)});