export html table to csv javascript
function downloadCSV(csv, filename) {
let csvFile;
let downloadLink;
// csv file
csvFile = new Blob([csv], { type: 'text/csv' });
// Download link
downloadLink = document.createElement('a');
// File name
downloadLink.download = filename;
// Create a link to the file
downloadLink.href = URL.createObjectURL(csvFile);
// Hide download link
downloadLink.style.display = "none";
// Add the link to DOM
document.body.appendChild(downloadLink);
// Click download link
downloadLink.click();
}
function exportTableToCSV(filename, separator) {
const csv = [];
const rows = document.querySelectorAll("table tr");
for (let i = 0; i < rows.length; i++) {
let row = [];
const cols = rows[i].querySelectorAll("td, th");
for (let j = 0; j < cols.length; j++)
// Add double quote to make the value stay in the same column if is separated by comma
row.push(`"${cols[j].innerText}"`);
csv.push(row.join(separator));
}
// Download CSV file
downloadCSV(csv.join("\n"), filename);
}
document.querySelector('button').addEventListener('click', () => {
exportTableToCSV('filename.csv', ',');
});
Are there any code examples left?
New code examples in category Javascript
-
Javascript 2023-04-21 22:52:36
-
Javascript 2022-03-27 22:25:20 javascript download string as file
-
Javascript 2022-03-27 21:40:22 sort numbers in array javascript
-
Javascript 2022-03-27 21:20:04 compare two arrays and return the difference javascript
-
Javascript 2022-03-27 21:15:02 javascript regex french phone number
-
Javascript 2022-03-27 21:05:03 cypress custom error message
-
Javascript 2022-03-27 21:00:05 create element javascript with id
-
Javascript 2022-03-27 20:40:57 feather icons react
-
Javascript 2022-03-27 20:20:01 how to make graphql request in axios
-
Javascript 2022-03-27 20:15:07 bootstrap validator password and confirm password