npm init -y

npm install axios cheerio node-xlsx --save

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

// 目標(biāo)網(wǎng)頁(yè)的URL，這里使用 下廚房 這個(gè)美食網(wǎng)站作為測(cè)試
const targetUrl = "https://www.xiachufang.com/category/40076/";

// 請(qǐng)求目標(biāo)網(wǎng)頁(yè)，獲取HTML內(nèi)容
const getHtml = async () => {
  const response = await axios.get(targetUrl);

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

// 解析HTML內(nèi)容，獲取菜品的標(biāo)題和圖片鏈接
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";

// 根據(jù) 表頭數(shù)據(jù) 和 列表數(shù)據(jù) 轉(zhuǎn)換成二維數(shù)組
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" },
  ];

  // 構(gòu)建表格數(shù)據(jù)
  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