1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
"use client";
import React, { FC } from "react";
import Image from "next/image";
import { useToast } from "@/hooks/use-toast";
import { toast as toastMessage } from "sonner";
import ExcelJS from "exceljs";
import { saveAs } from "file-saver";
import { Button } from "@/components/ui/button";
import { DataTableColumnJSON } from "./form-data-table-columns";
interface VarListDownloadBtnProps {
columnsJSON: DataTableColumnJSON[];
formCode: string;
}
export const VarListDownloadBtn: FC<VarListDownloadBtnProps> = ({
columnsJSON,
formCode,
}) => {
const { toast } = useToast();
const downloadReportVarList = async () => {
try {
// Create a new workbook
const workbook = new ExcelJS.Workbook();
// 데이터 시트 생성
const worksheet = workbook.addWorksheet("Data");
// 유효성 검사용 숨김 시트 생성
const validationSheet = workbook.addWorksheet("ValidationData");
validationSheet.state = "hidden"; // 시트 숨김 처리
// 1. 데이터 시트에 헤더 추가
const headers = ["Table Column Label", "Report Variable"];
worksheet.addRow(headers);
// 헤더 스타일 적용
const headerRow = worksheet.getRow(1);
headerRow.font = { bold: true };
headerRow.alignment = { horizontal: "center" };
headerRow.eachCell((cell) => {
cell.fill = {
type: "pattern",
pattern: "solid",
fgColor: { argb: "FFCCCCCC" },
};
});
// 2. 데이터 행 추가
columnsJSON.forEach((row) => {
const { displayLabel, label } = row;
const labelConvert = label.replaceAll(" ", "_");
worksheet.addRow([displayLabel, labelConvert]);
});
// 3. 컬럼 너비 자동 조정
headers.forEach((col, idx) => {
const column = worksheet.getColumn(idx + 1);
// 최적 너비 계산
let maxLength = col.length;
columnsJSON.forEach((row) => {
const valueKey = idx === 0 ? "displayLabel" : "label";
const value = row[valueKey];
if (value !== undefined && value !== null) {
const valueLength = String(value).length;
if (valueLength > maxLength) {
maxLength = valueLength;
}
}
});
// 너비 설정 (최소 10, 최대 50)
column.width = Math.min(Math.max(maxLength + 2, 10), 50);
});
const buffer = await workbook.xlsx.writeBuffer();
saveAs(new Blob([buffer]), `${formCode}_report_varible_list.xlsx`);
toastMessage.success("Report Varible List File 다운로드 완료!");
} catch (err) {
console.log(err);
toast({
title: "Error",
description: "Variable List 파일을 찾을 수가 없습니다.",
variant: "destructive",
});
}
};
return (
<Button
variant="ghost"
className="relative p-2"
aria-label="Variable List Download"
onClick={downloadReportVarList}
>
<Image
src="/icons/var_list_icon.svg"
alt="Template Sample Download Icon"
width={20}
height={20}
/>
</Button>
);
};
|
