TTC
Theo's Typesafe Cultalbatroz

Can i send a file from trcp router?

I want to send a xlxs/csv file to FE (expo). Can i do this like expressJs? or do i need to first uplaod to s3 then give it's uploaded URL?
albatroz
albatroz•352d ago
const workbook = XLSX.utils.book_new();

for (const tableName in data) {
  if (Array.isArray(data[tableName])) {
    const sheetName = tableName;
    const sheetData = data[tableName];

    if (sheetData && sheetData.length > 0) {
      const worksheet = XLSX.utils.json_to_sheet(sheetData);

      const headers = Object.keys(sheetData[0]);
      XLSX.utils.sheet_add_aoa(worksheet, [headers], { origin: "A1" });

      for (let i = 0; i < sheetData.length; i++) {
        const createdAt = sheetData[i].createdAt;
        if (createdAt) {
          sheetData[i].createdAt = new Date(createdAt).toLocaleString();
        }
      }

      XLSX.utils.sheet_add_json(worksheet, sheetData, { skipHeader: true, origin: "A2" });

      XLSX.utils.book_append_sheet(workbook, worksheet, sheetName);
    }
  }
}

const excelFilePath = "output.xlsx";
XLSX.writeFile(workbook, excelFilePath);
const workbook = XLSX.utils.book_new();

for (const tableName in data) {
  if (Array.isArray(data[tableName])) {
    const sheetName = tableName;
    const sheetData = data[tableName];

    if (sheetData && sheetData.length > 0) {
      const worksheet = XLSX.utils.json_to_sheet(sheetData);

      const headers = Object.keys(sheetData[0]);
      XLSX.utils.sheet_add_aoa(worksheet, [headers], { origin: "A1" });

      for (let i = 0; i < sheetData.length; i++) {
        const createdAt = sheetData[i].createdAt;
        if (createdAt) {
          sheetData[i].createdAt = new Date(createdAt).toLocaleString();
        }
      }

      XLSX.utils.sheet_add_json(worksheet, sheetData, { skipHeader: true, origin: "A2" });

      XLSX.utils.book_append_sheet(workbook, worksheet, sheetName);
    }
  }
}

const excelFilePath = "output.xlsx";
XLSX.writeFile(workbook, excelFilePath);
Want results from more Discord servers?
Add your server
More Posts
useSession has an empty user object {}When using the useSession hook, session.data contains `{ user: {}, expires: '2023-06-30T20:30:42.181TypeSafe external API ?I am currently communicating with an external API and after falling in love with TRPC, I would like Want to request only half of the audio file but not workingi request an audio file from my server and stream it to the browser .. on the browser i make a requeHow is realtime DB syncing accomplished without Firestore/Supabase?Hi! I've been working with Firestore for a long time now and gotten very used to the realtime db syn