convert base64 string to csv javascript giving blob error

Question

I am simply trying to convert a base-64 string to csv. The file is in CSV format transmitted in base-64 string.
I am implementing this in Microsoft Office Excel Addins
Code base-64-string

// getting the base-64 string
  let base_64_string = [base-64-string];

  // decode the base-64 string 
  let csvContent = atob(base_64_string);

  // convert the decoded base-64 string to csv
  var blob = new Blob([csvContent], {type: "data:application/octet-stream;base64"});

Error

Compiled with problems:

WARNING in ./src/taskpane/taskpane.js 310:17-21

export 'Blob' (imported as 'Blob') was not found in 'buffer' (possible exports: Buffer, INSPECT_MAX_BYTES, SlowBuffer, kMaxLength)

Another method here

Rocky Sims · Accepted Answer · 2022-08-13 08:05:22Z

1

The code you've posted is not the problem (as demonstrated by the code snippet below).

// generate a base-64 encoded csv string
const base_64_string = btoa("a,b,c");

// decode the base-64 string 
const csvContent = atob(base_64_string);

// convert the decoded base-64 string to csv
const blob = new Blob([csvContent], {type: "data:application/octet-stream;base64"});

console.log(blob);

edited Aug 13, 2022 at 8:05

answered Aug 13, 2022 at 7:59

Rocky Sims

3,6181 gold badge17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lav Sharma Over a year ago

This works, but while writing the csv data to excel it gives the error as Uncaught TypeError: e.match is not a function, using XLSX functions.

Collectives™ on Stack Overflow

convert base64 string to csv javascript giving blob error

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related