JSFiddle - React, Tailwind, and code Playground

by jpeter06

HTML

<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>

JavaScript

function localGetTimezoneOffsetMS(date) {
	var time = date.getTime();
	var utcTime = Date.UTC(date.getFullYear(),
		date.getMonth(),
		date.getDate(),
		date.getHours(),
		date.getMinutes(),
		date.getSeconds(),
		date.getMilliseconds());
	return time - utcTime;
}

const importBugHotfixDiff = (function () {
		const basedate = new Date(1899, 11, 30, 0, 0, 0);
		const dnthreshAsIs = (new Date().getTimezoneOffset() - basedate.getTimezoneOffset()) * 60000;
		const dnthreshToBe = localGetTimezoneOffsetMS(new Date()) - localGetTimezoneOffsetMS(basedate);
		return (dnthreshAsIs - dnthreshToBe)/1000;
	}());

function addSec(fecha){ fecha.setSeconds(fecha.getSeconds() + importBugHotfixDiff) ; return fecha}

var ws = XLSX.utils.json_to_sheet([[addSec(new Date("2024-06-01T11:00:00.000Z")),addSec(new Date("2024-06-01T12:00:00.000Z"))],[addSec(new Date("2024-06-01T13:00:00.000Z")),addSec(new Date("2024-06-01T14:00:00.000Z"))]], {skipHeader:true, dateNF: 'DD/MM/YYYY HH:mm:ss'});
var aux = XLSX.utils.sheet_to_json(ws);
ws = XLSX.utils.json_to_sheet(aux);
if(!ws['!cols']) ws['!cols'] = [];
ws['!cols'][1] = { wch: 17 };
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "issue1052");
XLSX.writeFile(wb, "issue1052.xlsx");