js指定打开excel路径

<a href="path_to_your_excel_file.xlsx" download>下载Excel文件</a>

function downloadExcelFile(url, filename) {
    const link = document.createElement('a');
    link.href = url;
    link.download = filename || 'file.xlsx';
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
}

// 使用示例
downloadExcelFile('path_to_your_excel_file.xlsx', 'my_excel_file.xlsx');

function generateAndDownloadExcel() {
    const data = [
        ['Name', 'Age', 'Email'],
        ['John Doe', 30, 'john@example.com'],
        ['Jane Smith', 25, 'jane@example.com']
    ];

    const csvContent = data.map(row => row.join(',')).join('\n');
    const blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' });
    const link = document.createElement('a');
    if (link.download !== undefined) { // feature detection
        const url = URL.createObjectURL(blob);
        link.setAttribute('href', url);
        link.setAttribute('download', 'data.csv');
        link.style.visibility = 'hidden';
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    }
}

// 使用示例
generateAndDownloadExcel();

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.17.5/xlsx.full.min.js"></script>
<script>
function generateExcel() {
    const data = [
        { Name: "John Doe", Age: 30, Email: "john@example.com" },
        { Name: "Jane Smith", Age: 25, Email: "jane@example.com" }
    ];

    const worksheet = XLSX.utils.json_to_sheet(data);
    const workbook = XLSX.utils.book_new();
    XLSX.utils.book_append_sheet(workbook, worksheet, "Sheet1");
    XLSX.writeFile(workbook, "data.xlsx");
}

// 使用示例
generateExcel();
</script>