forked from HANYANG/HANYANG_MES
2488 lines
60 KiB
JavaScript
2488 lines
60 KiB
JavaScript
let default_font = "맑은 고딕";
|
||
let myBorder = {
|
||
aroundThin: {
|
||
top: { style: "thin" },
|
||
left: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
thin1: { left: { style: "thin" }, bottom: { style: "thin" } },
|
||
thin2: { bottom: { style: "thin" } },
|
||
thin3: { bottom: { style: "thin" }, right: { style: "thin" } },
|
||
thin4: { left: { style: "thin" } },
|
||
thin6: { right: { style: "thin" } },
|
||
thin7: { top: { style: "thin" }, left: { style: "thin" } },
|
||
thin8: { top: { style: "thin" } },
|
||
thin9: { top: { style: "thin" }, right: { style: "thin" } },
|
||
thin123: {
|
||
left: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
thin789: {
|
||
top: { style: "thin" },
|
||
left: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
aroundThick: {
|
||
top: { style: "thick" },
|
||
left: { style: "thick" },
|
||
bottom: { style: "thick" },
|
||
right: { style: "thick" },
|
||
},
|
||
thick1: { left: { style: "thick" }, bottom: { style: "thick" } },
|
||
thick2: { bottom: { style: "thick" } },
|
||
thick3: { bottom: { style: "thick" }, right: { style: "thick" } },
|
||
thick4: { left: { style: "thick" } },
|
||
thick6: { right: { style: "thick" } },
|
||
thick7: { top: { style: "thick" }, left: { style: "thick" } },
|
||
thick8: { top: { style: "thick" } },
|
||
thick9: { top: { style: "thick" }, right: { style: "thick" } },
|
||
aroundMedium: {
|
||
top: { style: "medium" },
|
||
left: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
right: { style: "medium" },
|
||
},
|
||
medium1: { left: { style: "medium" }, bottom: { style: "medium" } },
|
||
medium2: { bottom: { style: "medium" } },
|
||
medium3: { bottom: { style: "medium" }, right: { style: "medium" } },
|
||
medium4: { left: { style: "medium" } },
|
||
medium6: { right: { style: "medium" } },
|
||
medium7: { top: { style: "medium" }, left: { style: "medium" } },
|
||
medium8: { top: { style: "medium" } },
|
||
|
||
//윗박스
|
||
mediumB: {
|
||
top: { style: "thin" },
|
||
right: { style: "thin" },
|
||
left: { style: "thin" },
|
||
bottom: { style: "medium" },
|
||
},
|
||
mediumB2: {
|
||
top: { style: "thin" },
|
||
right: { style: "thin" },
|
||
left: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
},
|
||
|
||
//1장 윗박스 맨 오른쪽
|
||
mediumB3: {
|
||
top: { style: "medium" },
|
||
right: { style: "medium" },
|
||
left: { style: "thin" },
|
||
bottom: { style: "medium" },
|
||
},
|
||
//1장 윗박스 맨 왼쪽
|
||
mediumB4: {
|
||
top: { style: "medium" },
|
||
right: { style: "thin" },
|
||
left: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
},
|
||
|
||
medium123: {
|
||
left: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
right: { style: "medium" },
|
||
},
|
||
medium789: {
|
||
top: { style: "medium" },
|
||
left: { style: "medium" },
|
||
right: { style: "medium" },
|
||
},
|
||
sumRow: {
|
||
top: { style: "medium" },
|
||
left: { style: "thin" },
|
||
bottom: { style: "medium" },
|
||
right: { style: "thin" },
|
||
},
|
||
boxTop: {
|
||
top: { style: "double" },
|
||
left: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
right: { style: "medium" },
|
||
},
|
||
boxBottom: {
|
||
top: { style: "medium" },
|
||
left: { style: "medium" },
|
||
bottom: { style: "double" },
|
||
right: { style: "medium" },
|
||
},
|
||
|
||
boxTop1A: {
|
||
top: { style: "thin" },
|
||
left: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
|
||
boxBottom1A: {
|
||
left: { style: "thin" },
|
||
right: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
},
|
||
|
||
///박스안에
|
||
|
||
boxTop1: {
|
||
top: { style: "thin" },
|
||
left: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
|
||
boxTop2: {
|
||
top: { style: "thin" },
|
||
left: { style: "thin" },
|
||
},
|
||
|
||
boxTop3: {
|
||
top: { style: "thin" },
|
||
right: { style: "thin" },
|
||
},
|
||
boxBottom1: {
|
||
left: { style: "thin" },
|
||
right: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
},
|
||
|
||
boxBottom2: {
|
||
left: { style: "thin" },
|
||
|
||
bottom: { style: "thin" },
|
||
},
|
||
boxBottom3: {
|
||
right: { style: "thin" },
|
||
bottom: { style: "thin" },
|
||
},
|
||
|
||
tl_border: {
|
||
top: { style: "medium" },
|
||
left: { style: "medium" },
|
||
},
|
||
t_border: {
|
||
top: { style: "medium" },
|
||
},
|
||
tr_border: {
|
||
top: { style: "medium" },
|
||
right: { style: "medium" },
|
||
},
|
||
bl_border: {
|
||
left: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
},
|
||
b_border: {
|
||
bottom: { style: "medium" },
|
||
},
|
||
br_border: {
|
||
right: { style: "medium" },
|
||
bottom: { style: "medium" },
|
||
},
|
||
l_border: {
|
||
left: { style: "medium" },
|
||
},
|
||
r_border: {
|
||
right: { style: "medium" },
|
||
},
|
||
};
|
||
|
||
let mystyle = {
|
||
algCenter: { horizontal: "center", vertical: "middle", wrapText: true },
|
||
algCenter_wtf: { horizontal: "center", vertical: "middle", wrapText: false },
|
||
algLeft: { horizontal: "left", vertical: "middle", wrapText: true },
|
||
algLeft_wrf: { horizontal: "left", vertical: "middle", wrapText: false },
|
||
algLeftB: { horizontal: "left", vertical: "top", wrapText: true },
|
||
algRight: { horizontal: "right", vertical: "middle", wrapText: true },
|
||
};
|
||
let myFill = {
|
||
fillInput: { type: "pattern", pattern: "solid", fgColor: { argb: "FCD5B4" } },
|
||
fillInput2: {
|
||
type: "pattern",
|
||
pattern: "solid",
|
||
fgColor: { argb: "FDE9D9" },
|
||
},
|
||
fillBlue: { type: "pattern", pattern: "solid", fgColor: { argb: "C5D9F1" } },
|
||
fillYellow: {
|
||
type: "pattern",
|
||
pattern: "solid",
|
||
fgColor: { argb: "FFFF00" },
|
||
},
|
||
};
|
||
let dfont = { size: 11, name: default_font, bold: true },
|
||
tfont1 = { size: 9, name: default_font },
|
||
tfont2 = { size: 10, name: default_font },
|
||
tfont3 = { size: 11, name: default_font, bold: true },
|
||
tfont4 = { size: 11, name: default_font },
|
||
lfont = { size: 16, name: default_font }, //1장빼고 박스글자
|
||
lfontB = { size: 16, name: default_font, bold: true }, //1장빼고 박스글자
|
||
lfont3 = { size: 12, name: default_font }, //3장 박스글자
|
||
lfontB3 = { size: 12, name: default_font, bold: true }, //3장 박스글자
|
||
lifont = { size: 17, name: default_font }, //윗박스글자
|
||
lifontB = { size: 17, name: default_font, bold: true }, //윗박스글자
|
||
lifontSum = { size: 11, name: default_font }, //박스안 글자
|
||
lifontSum1 = { size: 10, name: default_font }, //1박스안 글자
|
||
lifontSum2 = { size: 11, name: default_font }, // 아래 박스안 글자
|
||
lifont4 = { size: 14, name: default_font }, //아래박스글자
|
||
bFont9 = { size: 9, name: default_font },
|
||
bFont10 = { size: 10, name: default_font },
|
||
bFont11 = { size: 11, name: default_font },
|
||
sfont = { size: 20, name: default_font, underline: true };
|
||
titleFont = { size: 55, name: default_font, bold: true };
|
||
|
||
let nRow = null,
|
||
nCell = null;
|
||
|
||
const getEstiExcel = async (filename, title) => {
|
||
if (typeof ExcelJS == "undefined") return false;
|
||
|
||
filename = filename || "noname.xlsx";
|
||
title = title || "제목을 입력하지 않았습니다.";
|
||
filename = filename.replace(/[\*\?\:\\\/\[\]]/, "");
|
||
|
||
const workBook = new ExcelJS.Workbook();
|
||
workBook.creator = "스틸코리아 MES (http://mes.steelkorea.kr)";
|
||
workBook.subject = "스틸코리아 MES - " + title;
|
||
workBook.title = "스틸코리아 MES - " + title;
|
||
workBook.description = "STEELKOREA MES - " + title;
|
||
workBook.keywords = "http://mes.steelkorea.kr - " + title;
|
||
workBook.catetory = "스틸코리아 MES";
|
||
workBook.company = "스틸코리아 MES (mes.steelkorea.kr)";
|
||
|
||
getSheet1(workBook, "1-4");
|
||
getSheet2(workBook, "2-4");
|
||
getSheet3(workBook, "3-4");
|
||
getSheet4(workBook, "4-4");
|
||
|
||
workBook.xlsx.writeBuffer().then((data) => {
|
||
let blob = new Blob([data], {
|
||
type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
||
}),
|
||
url = window.URL.createObjectURL(blob),
|
||
anchor = document.createElement("a");
|
||
anchor.href = url;
|
||
anchor.download = filename;
|
||
anchor.click();
|
||
window.URL.revokeObjectURL(url);
|
||
});
|
||
};
|
||
|
||
const getApplyRow = (row) => {
|
||
let aCellArr = [];
|
||
for (let i = 0; i < 9; i++) {
|
||
aCellArr.push(row.getCell(i + 1));
|
||
}
|
||
return aCellArr;
|
||
};
|
||
|
||
let num2XlsColumn1 = function (num) {
|
||
let str = "",
|
||
temp;
|
||
|
||
while (num > 0) {
|
||
temp = (num - 1) % 26;
|
||
str = String.fromCharCode(65 + temp) + str;
|
||
num = ((num - temp) / 26) | 0;
|
||
}
|
||
return str || undefined;
|
||
};
|
||
|
||
const fnBorder = (ws, col1, row1, col2, row2) => {
|
||
let _this = this;
|
||
for (let a = row1; a <= row2; a++) {
|
||
if (a === row1) {
|
||
for (let b = col1; b <= col2; b++) {
|
||
let cell = ws.getCell(num2XlsColumn1(b) + a);
|
||
if (b == col1) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.tl_border },
|
||
};
|
||
} else if (b == col2) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.tr_border },
|
||
};
|
||
} else {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.t_border },
|
||
};
|
||
}
|
||
}
|
||
} else if (a === row2) {
|
||
for (let b = col1; b <= col2; b++) {
|
||
let cell = ws.getCell(num2XlsColumn1(b) + a);
|
||
if (b == col1) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.bl_border },
|
||
};
|
||
} else if (b == col2) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.br_border },
|
||
};
|
||
} else {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.b_border },
|
||
};
|
||
}
|
||
}
|
||
} else {
|
||
for (let b = col1; b <= col2; b++) {
|
||
let cell = ws.getCell(num2XlsColumn1(b) + a);
|
||
if (b == col1) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.l_border },
|
||
};
|
||
} else if (b == col2) {
|
||
cell.style = {
|
||
...cell.style,
|
||
border: { ...cell.style.border, ...myBorder.r_border },
|
||
};
|
||
}
|
||
}
|
||
}
|
||
}
|
||
};
|
||
|
||
const getSheet1 = (wbook, sheetname) => {
|
||
sheetname = sheetname;
|
||
let tSumRow = 35;
|
||
let workSheet = wbook.addWorksheet(sheetname, {
|
||
pageSetup: {
|
||
paperSize: 8,
|
||
fitToPage: true,
|
||
horizontalCentered: true,
|
||
orientation: "landscape",
|
||
margins: {
|
||
left: 0.28,
|
||
right: 0.28,
|
||
top: 0.88,
|
||
bottom: 0.64,
|
||
header: 0.48,
|
||
footer: 0.52,
|
||
},
|
||
},
|
||
properties: { defaultRowHeight: 16 },
|
||
});
|
||
|
||
workSheet.columns = [
|
||
//전체 컬럼 속성
|
||
|
||
{
|
||
width: 3.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 20.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 4.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 12.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.6,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.6,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 12.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.6,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.3,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 10.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 12.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 10.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 12.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 10.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 11.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 10.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 10.0,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.5,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 8.4,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 9.2,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
{
|
||
width: 6.8,
|
||
style: { alignment: { vertical: "middle", horizontal: "left" } },
|
||
},
|
||
];
|
||
|
||
nRow = workSheet.getRow(1);
|
||
nCell = nRow.getCell("A");
|
||
nCell.value = "Dimension Inspection Record";
|
||
nRow.height = 150;
|
||
nCell.font = titleFont;
|
||
nCell.alignment = mystyle.algCenter;
|
||
nCell.border = myBorder.aroundMedium;
|
||
workSheet.mergeCells("A1:AE1");
|
||
|
||
nRow = workSheet.getRow(1);
|
||
nCell = nRow.getCell("AF");
|
||
nRow.height = 150;
|
||
nCell.value = "Page";
|
||
nCell.font = lifont;
|
||
nCell.border = myBorder.aroundMedium;
|
||
nCell.alignment = mystyle.algCenter;
|
||
workSheet.mergeCells("AF1:AI1");
|
||
|
||
nRow = workSheet.getRow(1);
|
||
nCell = nRow.getCell("AJ");
|
||
nRow.height = 150;
|
||
nCell.value = "1 OF 4";
|
||
nCell.border = myBorder.aroundMedium;
|
||
nCell.font = lifont;
|
||
nCell.alignment = mystyle.algCenter;
|
||
workSheet.mergeCells("AJ1:AN1");
|
||
|
||
nRow = workSheet.getRow(2);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 40;
|
||
nCell.value = " Customer";
|
||
nCell.font = lifont;
|
||
nCell.border = myBorder.mediumB4;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("A2:I2");
|
||
|
||
nRow = workSheet.getRow(2);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Blat Industry";
|
||
nCell.border = myBorder.mediumB3;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("J2:T2");
|
||
|
||
nRow = workSheet.getRow(2);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Record No.";
|
||
nCell.border = myBorder.mediumB4;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("U2:AC2");
|
||
|
||
nRow = workSheet.getRow(2);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " 220706-19001-549~552";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("AD2:AN2");
|
||
|
||
nRow = workSheet.getRow(3);
|
||
|
||
nCell = nRow.getCell("A");
|
||
nCell.value = " DWG No.";
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.border = myBorder.mediumB4;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("A3:I3");
|
||
|
||
nRow = workSheet.getRow(3);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " 293-111BW Rev.07";
|
||
nCell.border = myBorder.mediumB3;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("J3:T3");
|
||
|
||
nRow = workSheet.getRow(3);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Date";
|
||
nCell.alignment = mystyle.mediumB4;
|
||
nCell.border = myBorder.aroundThin;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("U3:AC3");
|
||
|
||
nRow = workSheet.getRow(3);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " 2023.06. .";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("AD3:AN3");
|
||
|
||
nRow = workSheet.getRow(4);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 32;
|
||
nCell.font = lifont;
|
||
nCell.value = " PO No.";
|
||
nCell.border = myBorder.mediumB4;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("A4:I4");
|
||
|
||
nRow = workSheet.getRow(4);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " -";
|
||
nCell.border = myBorder.mediumB3;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("J4:T4");
|
||
|
||
nRow = workSheet.getRow(4);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Material";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB4;
|
||
workSheet.mergeCells("U4:AC4");
|
||
|
||
nRow = workSheet.getRow(4);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " S355NL";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("AD4:AN4");
|
||
|
||
nRow = workSheet.getRow(5);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Item";
|
||
|
||
nCell.border = myBorder.mediumB4;
|
||
nCell.alignment = mystyle.algLeft;
|
||
workSheet.mergeCells("A5:I5");
|
||
|
||
nRow = workSheet.getRow(5);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " WIND FLANGE";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("J5:T5");
|
||
|
||
nRow = workSheet.getRow(5);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 326;
|
||
nCell.font = lifont;
|
||
nCell.value = " Size";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB4;
|
||
workSheet.mergeCells("U5:AC5");
|
||
|
||
nRow = workSheet.getRow(5);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " 7832.00 x 6620.00 x 341.00";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("AD5:AN5");
|
||
|
||
nRow = workSheet.getRow(6);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Result";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB4;
|
||
workSheet.mergeCells("A6:I6");
|
||
|
||
nRow = workSheet.getRow(6);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " □Satifactory □Unsatifactory";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("J6:T6");
|
||
|
||
nRow = workSheet.getRow(6);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " Q´TY";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB4;
|
||
workSheet.mergeCells("U6:AC6");
|
||
|
||
nRow = workSheet.getRow(6);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 40;
|
||
nCell.font = lifont;
|
||
nCell.value = " 4EA";
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.mediumB3;
|
||
workSheet.mergeCells("AD6:AN6");
|
||
|
||
nRow = workSheet.getRow(7);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 60;
|
||
nCell.font = lifontB;
|
||
nCell.value = "CHECKED BY ----------";
|
||
nCell.alignment = mystyle.algCenter;
|
||
nCell.border = myBorder.boxBottom;
|
||
workSheet.mergeCells("A7:M7");
|
||
|
||
nRow = workSheet.getRow(7);
|
||
nCell = nRow.getCell("N");
|
||
nRow.height = 60;
|
||
nCell.font = lifontB;
|
||
nCell.value = "REVIEWED BY ----------";
|
||
nCell.alignment = mystyle.algCenter;
|
||
nCell.border = myBorder.boxBottom;
|
||
workSheet.mergeCells("N7:Y7");
|
||
|
||
nRow = workSheet.getRow(7);
|
||
nCell = nRow.getCell("Z");
|
||
nRow.height = 60;
|
||
nCell.font = lifontB;
|
||
nCell.value = "APPROVED BY ----------";
|
||
nCell.alignment = mystyle.algCenter;
|
||
nCell.border = myBorder.boxBottom;
|
||
workSheet.mergeCells("Z7:AN7");
|
||
|
||
const columns1 = [
|
||
"A",
|
||
"B",
|
||
"C",
|
||
"D",
|
||
"E",
|
||
"F",
|
||
"G",
|
||
"H",
|
||
"I",
|
||
"J",
|
||
"K",
|
||
"L",
|
||
"M",
|
||
"N",
|
||
"O",
|
||
"P",
|
||
"Q",
|
||
"R",
|
||
"S",
|
||
"T",
|
||
"U",
|
||
"V",
|
||
"W",
|
||
"X",
|
||
"Y",
|
||
"Z",
|
||
"AA",
|
||
"AB",
|
||
"AC",
|
||
"AD",
|
||
"AE",
|
||
"AF",
|
||
"AG",
|
||
"AH",
|
||
"AI",
|
||
"AJ",
|
||
"AK",
|
||
"AL",
|
||
"AM",
|
||
"AN",
|
||
];
|
||
const rows1 = [8, 9, 10, 11, 12, 13, 14, 15, 16];
|
||
const columnValues1 = {
|
||
A: [
|
||
"Position",
|
||
"Position",
|
||
"Position",
|
||
"Norminal",
|
||
"Tolerance",
|
||
"Tolerance",
|
||
"⋇1 Measuring\r\n Instrument",
|
||
"Offset",
|
||
"Unit of measure",
|
||
],
|
||
B: [
|
||
"Position",
|
||
"Position",
|
||
"Position",
|
||
"Norminal",
|
||
"Tolerance",
|
||
"Tolerance",
|
||
"Measuring\r\nInstrument",
|
||
"Offset",
|
||
"Unit of measure",
|
||
],
|
||
C: ["선\r\n행\r\n공\r\n정\r\n확\r\n인", "", "", "", "", "", "", "", ""],
|
||
D: [
|
||
"내경\r\n Inside diameter",
|
||
"",
|
||
"0°/45°/90°/135°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
E: [
|
||
"내,외경폭\r\n Width of between\nOD and ID",
|
||
"",
|
||
"0°/45°/90°/135°/185°\n/225°/270°/315°",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
F: [
|
||
"내,외경폭\r\n width of between\nOD and ID",
|
||
"",
|
||
"0°/45°/90°/135°/185°\n/225°/270°/315°",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
G: [
|
||
"외경\r\n Outside diameter",
|
||
"",
|
||
"0°/45°/90°/135°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
H: [
|
||
"평행도\r\nParallelism",
|
||
"",
|
||
"0°/180°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
I: ["평탄도\r\nFlatness", "", "0°", "", "", "", "", "", "millimeter"],
|
||
J: ["평탄도\r\nFlatness", "", "0°", "", "", "", "", "", "millimeter"],
|
||
K: ["평탄도\r\nFlatness", "", "0°", "", "", "", "", "", "millimeter"],
|
||
L: ["원통도\r\nCylindricty", "", "0°", "", "", "", "", "", "millimeter"],
|
||
M: ["", "", "", "", "", "", "", "", ""],
|
||
N: ["", "", "", "", "", "", "", "", ""],
|
||
O: [
|
||
"내측두께\r\nThickness\r\ninside",
|
||
"",
|
||
"0°/45°/90°/135°/185°\n/225°/270°/315°",
|
||
"",
|
||
"+0.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
P: [
|
||
"내측두께\r\nThickness\r\ninside",
|
||
"",
|
||
"0°/45°/90°/135°/185°\n/225°/270°/315°",
|
||
"",
|
||
"+0.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
Q: ["총두께\r\nHeight", "", "0°/180°", "", "", "", "", "", "millimeter"],
|
||
R: [
|
||
"개선부(Welding Groove)",
|
||
"상면개선\r\n외경\r\nNeck width",
|
||
"0°/45°/90°/135°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
S: [
|
||
"개선부(Welding Groove)",
|
||
"상면개선부 \r\n높이\r\nNeck Height",
|
||
"0°/180°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
T: [
|
||
"개선부(Welding Groove)",
|
||
"상면개선\r\n두께\r\nNeck width ",
|
||
"0°/45°/90°/135°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
U: [
|
||
"개선부(Welding Groove)",
|
||
"상투르폭\r\nAngle\r\nneck width ",
|
||
"0°/180°",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
V: [
|
||
"개선부(Welding Groove)",
|
||
"상부내측\r\n 개선각\r\nAngle",
|
||
"0°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
W: [
|
||
"개선부(Welding Groove)",
|
||
"상부외측\r\n 개선각\r\nAngle",
|
||
"0°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
X: [
|
||
"개선부(Welding Groove)",
|
||
"상면개선부 \r\n내측R\r\nRadius",
|
||
"0°/180°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
Y: [
|
||
"개선부(Welding Groove)",
|
||
"상면개선부\r\n 외측R\r\nRadius",
|
||
"0°",
|
||
"",
|
||
"+0.5\r\n-0.5",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
Z: [
|
||
"개선부(Welding Groove)",
|
||
"하면개선부 \r\n높이\r\nNeck Height",
|
||
"0°/180°",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AA: [
|
||
"개선부(Welding Groove)",
|
||
"하면개선\r\n 두께\r\nNeck width",
|
||
"0°/180°",
|
||
"",
|
||
"+1.0\r\n-0.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AB: [
|
||
"개선부(Welding Groove)",
|
||
"하부루트 폭\r\nAngle\r\nneck width",
|
||
"0°/180°",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AC: [
|
||
"개선부(Welding Groove)",
|
||
"하부내측 \r\n개선각\r\nAngle",
|
||
"0°/180°",
|
||
"",
|
||
"+1.0\r\n-1.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AD: [
|
||
"개선부(Welding Groove)",
|
||
"하부외측 개선각\r\nAngle",
|
||
"0°",
|
||
"",
|
||
"+2.0\r\n-2.0",
|
||
"",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AE: ["⋇\r\n Gauge1", "Gauge1", "0°", "", "", "", "", "", "millimeter"],
|
||
AF: [
|
||
"모따기\r\nEdge",
|
||
"R,C\r\nRadius\r\nChamfer",
|
||
"0°/180°",
|
||
"",
|
||
"",
|
||
"+2.0\r\n-2.0",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AG: [
|
||
"모따기\r\nEdge",
|
||
"R,C\r\nRadius\r\nChamfer",
|
||
"/180°",
|
||
"",
|
||
"",
|
||
"+2.0\r\n-2.0",
|
||
"",
|
||
"",
|
||
"millimeter",
|
||
],
|
||
AH: ["조도\r\n Roughness", "", "0°", "", "", "", "", "", "millimeter"],
|
||
AI: ["", "", "", "", "", "", "", "", ""],
|
||
AJ: ["", "", "", "", "", "", "", "", ""],
|
||
AK: ["", "", "", "", "", "", "", "", ""],
|
||
AL: ["", "", "", "", "", "", "", "", ""],
|
||
AM: ["", "", "", "", "", "", "", "", ""],
|
||
AN: ["", "", "", "", "", "", "", "", ""],
|
||
};
|
||
|
||
for (const column of columns1) {
|
||
for (let i = 0; i < rows1.length; i++) {
|
||
nRow = workSheet.getRow(rows1[i]);
|
||
nCell = nRow.getCell(column);
|
||
|
||
if (i === 12) {
|
||
nRow12 = workSheet.getRow(rows1[i]);
|
||
nRow12.font = lifont;
|
||
} else {
|
||
nCell.font = lifontSum1;
|
||
nCell.value = columnValues1[column][i];
|
||
nCell.alignment = mystyle.algCenter;
|
||
nRow.height = 42;
|
||
nCell.border = myBorder.aroundMedium;
|
||
}
|
||
}
|
||
}
|
||
|
||
workSheet.mergeCells("A8:B10");
|
||
for (let row = 8; row <= 110; row++) {
|
||
nRow = workSheet.getRow(row);
|
||
nRow.height = 60;
|
||
nCell = nRow.getCell("A");
|
||
nCell.font = lfont;
|
||
}
|
||
|
||
workSheet.mergeCells("A11:B11");
|
||
nRow11 = workSheet.getRow(11);
|
||
nRow11.height = 30;
|
||
nCell = nRow11.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
nRow = workSheet.getRow(12);
|
||
nCell = nRow.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
workSheet.mergeCells("A12:B13");
|
||
nRow13 = workSheet.getRow(13);
|
||
nRow13.height = 25;
|
||
nCell = nRow13.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
workSheet.mergeCells("A14:B14");
|
||
nRow14 = workSheet.getRow(14);
|
||
nRow14.height = 42;
|
||
nCell = nRow14.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
workSheet.mergeCells("A15:B15");
|
||
|
||
nRow15 = workSheet.getRow(15);
|
||
nRow15.height = 30;
|
||
nCell = nRow15.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
workSheet.mergeCells("A16:B16");
|
||
nRow16 = workSheet.getRow(16);
|
||
nRow16.height = 30;
|
||
nCell = nRow16.getCell("A");
|
||
nCell.font = lfont;
|
||
nCell.alignment = mystyle.algLeft;
|
||
|
||
workSheet.mergeCells("C8:C16");
|
||
|
||
nRow8 = workSheet.getRow(8);
|
||
nCell = nRow8.getCell("C");
|
||
nCell.font = lfont;
|
||
|
||
workSheet.mergeCells("E8:F9");
|
||
workSheet.mergeCells("O8:P9");
|
||
workSheet.mergeCells("R8:AD8");
|
||
|
||
workSheet.mergeCells("E10:F10");
|
||
workSheet.mergeCells("O10:P10");
|
||
|
||
const mergeRanges = [
|
||
"D",
|
||
"G",
|
||
"H",
|
||
"I",
|
||
"J",
|
||
"K",
|
||
"L",
|
||
"M",
|
||
"N",
|
||
"Q",
|
||
"AE",
|
||
"AH",
|
||
"AI",
|
||
"AJ",
|
||
"AK",
|
||
"AL",
|
||
"AM",
|
||
"AN",
|
||
];
|
||
|
||
for (const range of mergeRanges) {
|
||
workSheet.mergeCells(`${range}8:${range}9`);
|
||
}
|
||
|
||
const mergeRanges2 = [
|
||
"D",
|
||
"E",
|
||
"F",
|
||
"G",
|
||
"H",
|
||
"I",
|
||
"J",
|
||
"K",
|
||
"L",
|
||
"M",
|
||
"N",
|
||
"O",
|
||
"P",
|
||
"Q",
|
||
"R",
|
||
"S",
|
||
"T",
|
||
"U",
|
||
"V",
|
||
"W",
|
||
"X",
|
||
"Y",
|
||
"Z",
|
||
"AA",
|
||
"AB",
|
||
"AC",
|
||
"AD",
|
||
"AE",
|
||
"AF",
|
||
"AG",
|
||
"AH",
|
||
"AI",
|
||
"AJ",
|
||
"AK",
|
||
"AL",
|
||
"AM",
|
||
"AN",
|
||
];
|
||
|
||
for (const range of mergeRanges2) {
|
||
workSheet.mergeCells(`${range}12:${range}13`);
|
||
}
|
||
|
||
nRow = workSheet.getRow(17);
|
||
nCell = nRow.getCell("A");
|
||
nRow.height = 30;
|
||
nCell.value = "Actual value";
|
||
nCell.border = { top: { style: "double" } };
|
||
nCell.alignment = mystyle.algCenter;
|
||
workSheet.mergeCells("A17:AN17");
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("A");
|
||
nCell.value = "I\r\nT\r\nE\r\nM\r\n\r\nN\r\nO";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.aroundMedium;
|
||
nCell.alignment = mystyle.algCenter;
|
||
workSheet.mergeCells("A18:A25");
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("B");
|
||
nCell.value = "549#1";
|
||
nCell.font = lifontB;
|
||
nCell.border = myBorder.aroundMedium;
|
||
nCell.alignment = mystyle.algCenter;
|
||
workSheet.mergeCells("B18:B25");
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("C");
|
||
nCell.border = myBorder.aroundMedium;
|
||
workSheet.mergeCells("C18:C25");
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("D");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("E");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("F");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("G");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("H");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.value = "0°";
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("I");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("J");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("K");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("L");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("M");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("N");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("O");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("P");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("Q");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("R");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("S");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("T");
|
||
nCell.value = "0°";
|
||
nCell.font = lifontSum2;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("U");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("V");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("W");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("X");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("Y");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("Z");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AA");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AB");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AC");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AD");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AE");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AF");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AG");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AH");
|
||
nCell.value = "0°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AI");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AJ");
|
||
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AK");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AL");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AM");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(18);
|
||
nCell = nRow.getCell("AN");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("D");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("E");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("F");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("G");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("H");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("H19:H21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("I");
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("I19:I25");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("J19:J21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("K");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("K19:K21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("L");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("L19:L25");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("M");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("M19:M21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("N");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("N19:N21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("O");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("P");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("Q");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Q19:Q21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("S");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("S19:S21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("T");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("T19:T21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("U19:U21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("V");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("V19:V21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("W");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("W19:W21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("X");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("X19:X21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("Y");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Y19:Y21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("Z");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Z19:Z21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AA");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AA19:AA21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AB");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AB19:AB21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AC");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AC19:AC21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AD19:AD21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AE");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AE19:AE21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AF");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AF19:AF21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AG");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AG19:AG21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AH");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AH19:AH21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AI");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AI19:AI21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AJ");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AJ19:AJ21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AK");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AK19:AK21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AL");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AL19:AL21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AM");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AM19:AM21");
|
||
|
||
nRow = workSheet.getRow(19);
|
||
nCell = nRow.getCell("AN");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AN19:AN21");
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("D");
|
||
nCell.value = "45°";
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("E");
|
||
nCell.value = "45°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("F");
|
||
nCell.value = "225°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("G");
|
||
nCell.value = "45°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("O");
|
||
nCell.value = "45°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("P");
|
||
nCell.value = "45°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("Q");
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(20);
|
||
nCell = nRow.getCell("R");
|
||
nCell.value = "45°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("D");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("E");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("F");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("G");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("O");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(21);
|
||
nCell = nRow.getCell("P");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("D");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("E");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("F");
|
||
nCell.value = "270°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("G");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("H");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("J");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("K");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("M");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("N");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("O");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("P");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("Q");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("R");
|
||
nCell.value = "90°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("S");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("T");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("U");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("V");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("W");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("X");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("Y");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("Z");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AA");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AB");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AC");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AD");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AE");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AF");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AG");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AH");
|
||
nCell.value = "180°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AI");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AJ");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AK");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AL");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AM");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(22);
|
||
nCell = nRow.getCell("AN");
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("D");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("E");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("F");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("G");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("H");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("H23:H25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("J");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("J23:J25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("K");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("K23:K25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("M");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("M23:M25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("N");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("N23:N25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("O");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("P");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("Q");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Q23:Q25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("S");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("S23:S25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("T");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("T23:T25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("U");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("U23:U25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("V");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("V23:V25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("W");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("W23:W25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("X");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("X23:X25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("Y");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Y23:Y25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("Z");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("Z23:Z25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AA");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AA23:AA25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AB");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AB23:AB25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AC");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AC23:AC25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AD");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AD23:AD25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AE");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AE23:AE25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AF");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AF23:AF25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AG");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AG23:AG25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AH");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AH23:AH25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AI");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AI23:AI25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AJ");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AJ23:AJ25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AK");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AK23:AK25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AL");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AL23:AL25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AM");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AM23:AM25");
|
||
|
||
nRow = workSheet.getRow(23);
|
||
nCell = nRow.getCell("AN");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
workSheet.mergeCells("AN23:AN25");
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("D");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("E");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("F");
|
||
nCell.value = "315°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("G");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("O");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("P");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeftB;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(24);
|
||
nCell = nRow.getCell("R");
|
||
nCell.value = "135°";
|
||
nCell.font = lifontSum2;
|
||
nCell.alignment = mystyle.algLeft;
|
||
nCell.border = myBorder.boxTop1A;
|
||
nRow.height = 15;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("D");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("E");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("F");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("G");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("O");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("P");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
nRow = workSheet.getRow(25);
|
||
nCell = nRow.getCell("R");
|
||
nRow.height = 23;
|
||
nCell.border = myBorder.boxBottom1A;
|
||
|
||
const drawArchive = (ws, start) => {
|
||
const columns = [
|
||
"A",
|
||
"B",
|
||
"C",
|
||
"D",
|
||
"E",
|
||
"F",
|
||
"G",
|
||
"H",
|
||
"I",
|
||
"J",
|
||
"K",
|
||
"L",
|
||
"M",
|
||
"N",
|
||
"O",
|
||
"P",
|
||
"Q",
|
||
"R",
|
||
"S",
|
||
"T",
|
||
"U",
|
||
"V",
|
||
"W",
|
||
"X",
|
||
"Y",
|
||
"Z",
|
||
"AA",
|
||
"AB",
|
||
"AC",
|
||
"AD",
|
||
"AE",
|
||
"AF",
|
||
"AG",
|
||
"AH",
|
||
"AI",
|
||
"AJ",
|
||
"AK",
|
||
"AL",
|
||
"AM",
|
||
"AN",
|
||
];
|
||
|
||
let row = null,
|
||
cell = null;
|
||
columns.forEach((column, idx) => {
|
||
for (let a = 0; a < 4; a++) {
|
||
row = ws.getRow(start + a);
|
||
|
||
cell = row.getCell(column);
|
||
}
|
||
|
||
fnBorder(ws, idx + 1, start, idx + 1, start + 7);
|
||
});
|
||
|
||
fnBorder(ws, 1, start, columns.length, start + 7);
|
||
};
|
||
|
||
drawArchive(workSheet, 18);
|
||
//drawArchive( workSheet, 23, '549#2' );
|
||
|
||
nRow = workSheet.getRow(26);
|
||
nCell = nRow.getCell("A");
|
||
nCell.value =
|
||
"note: \r\n⋇1:VC:Vernier Calipers MT:Measuring Tape OM: Outside Micrometer G: Goniometer TI:Tubular Inside micrometer MC:Machining Check TP:Template CY:CYlider gauge\r\n R:Radius gauge RO:ROughness gauge P:Perpher gauge DM:Depth Micrometer D:Dial gauge T:Tap bolt TP:Tb bolt RG:RouGhness tester \r\n ⋇2:Gauge1 :개선부 형상 측정용 gauge (Gauge for checking shape of welding) Gauge2 :Alignment marking 측정용 gauge(Gauge for checking the location of alignment marking ) \r\n ⋇3 The geometrical tolerances and the surpace roughness are fulfilled in accordance with EN 1090-2 (Para 6.6.2,6.6.3 and table 9.)";
|
||
nCell.border = myBorder.aroundMedium;
|
||
nCell.alignment = mystyle.algCenter;
|
||
nRow.height = 90;
|
||
nCell.font = lifontSum;
|
||
workSheet.mergeCells("A26:AN26");
|
||
|
||
return workSheet;
|
||
};
|
||
|
||
document.getElementById("btnDownExcel1").addEventListener("click", function () {
|
||
getEstiExcel("getExcel1.xlsx", "타이틀");
|
||
});
|