npm init -y

npm install axios cheerio node-xlsx --save

import axios from "axios";
import cheerio from "cheerio";

// 目標網頁的URL，這里使用 下廚房 這個美食網站作為測試
const targetUrl = "https://www.xiachufang.com/category/40076/";

// 請求目標網頁，獲取HTML內容
const getHtml = async () => {
  const response = await axios.get(targetUrl);

  if (response.status !== 200) {
    throw new Error("請求失敗");
  }
  return response.data;
};

// 解析HTML內容，獲取菜品的標題和圖片鏈接
const getData = async (html) => {
  const $ = cheerio.load(html);
  const list = [];
  $(".normal-recipe-list li").each((i, elem) => {
    const imgUrl = $(elem).find("img").attr("src");
    const title = $(elem).find("p.name a").text();
    list.push({
      title: title.replace(/[\n\s]+/g, ""),
      imgUrl,
    });
  });
  return list;
};

import xlsx from "node-xlsx";
import fs from "fs";

// 根據 表頭數據 和 列表數據 轉換成二維數組
const transData = (columns, tableList) => {
  const data = columns.reduce(
    (acc, cur) => {
      acc.titles.push(cur.header);
      acc.keys.push(cur.key);
      return acc;
    },
    { titles: [], keys: [] }
  );

  const tableBody = tableList.map((item) => {
    return data.keys.map((key) => item[key]);
  });
  return [data.titles, ...tableBody];
};

const writeExcel = (list) => {
  // 表頭
  const columns = [
    { header: "菜名", key: "title" },
    { header: "圖片鏈接", key: "imgUrl" },
  ];

  // 構建表格數據
  const tableData = transData(columns, list);
  const workbook = xlsx.build([
    {
      name: "菜譜",
      data: tableData,
    },
  ]);

  // 寫入文件
  fs.writeFileSync("./菜譜.xlsx", workbook, "binary");
};

(async () => {
  const html = await getHtml();
  const list = await getData(html);
  await writeExcel(list);
  console.log("執(zhí)行完畢");
})();

node crawler.js