I want to keep updating the same sheet with new json. This code works to add a sheet, but it throws an error if the sheet exists
const wb = xlsx.readFile("test.xlsx")
const ws = xlsx.utils.json_to_sheet(json)
xlsx.utils.book_append_sheet(wb, ws, "test.xlsx")
xlsx.writeFile(wb, "test.xlsx")
I'd like to over write existing data as another sheet is using the cells as a reference