wklee
/
HANYANG_MES
forked from HANYANG/HANYANG_MES
1
0
Fork 0
Code Pull Requests Activity
HANYANG_MES/show_dir/www/ksvc/excel/getExcel2.js

1352 lines
32 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

getSheet2 = (wbook, sheetname) => {
// 2/4 그루브
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: 15 },
});
let lfont = { size: 16, name: default_font }, //1장빼고 박스글자
lfontB = { size: 16, name: default_font, bold: true }, //1장빼고 박스글자
lifontSum2 = { size: 13, name: default_font }, //박스안 글자
lifontSum = { size: 14, name: default_font }, //박스안 글자
titleFont = { size: 55, name: default_font, bold: true },
algLeftB = { horizontal: "left", vertical: "top" };
workSheet.columns = [
{
width: 3.0,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 24.0,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 6.0,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.1,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
{
width: 12.4,
style: { alignment: { vertical: "middle", horizontal: "left" } },
},
];
nRow = workSheet.getRow(`1`);
nRow.height = 150;
nCell = nRow.getCell("A");
nCell.value = "Dimension Inspection Record";
nCell.font = titleFont;
nCell.border = myBorder.aroundMedium;
nCell.alignment = mystyle.algCenter;
workSheet.mergeCells("A1:X1");
nRow = workSheet.getRow(`1`);
nRow.height = 150;
nCell = nRow.getCell("Y");
nCell.font = lfont;
nCell.value = "Page";
nCell.border = myBorder.aroundMedium;
nCell.alignment = mystyle.algCenter;
workSheet.mergeCells("Y1:AA1");
nRow = workSheet.getRow(`1`);
nRow.height = 150;
nCell = nRow.getCell("AB");
nCell.font = lfont;
nCell.value = "2 OF 4";
nCell.border = myBorder.aroundMedium;
nCell.alignment = mystyle.algCenter;
workSheet.mergeCells("AB1:AD1");
nRow = workSheet.getRow(2);
nRow.height = 42;
nCell = nRow.getCell("A");
nCell.font = lfont;
nCell.value = " Cutomer";
nCell.border = myBorder.mediumB4;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A2:F2");
nRow = workSheet.getRow(2);
nCell = nRow.getCell("G");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " Blat Industry";
nCell.border = myBorder.mediumB;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("G2:K2");
nRow = workSheet.getRow(2);
nCell = nRow.getCell("L");
nRow.height = 42;
nCell.font = lfont;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("L2:O2");
nRow = workSheet.getRow(2);
nCell = nRow.getCell("P");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " Record No.";
nCell.border = myBorder.mediumB;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("P2:T2");
nRow = workSheet.getRow(2);
nCell = nRow.getCell("U");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " 220706-19001-549~552";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("U2:AD2");
nRow = workSheet.getRow(3);
nRow.height = 42;
nCell = nRow.getCell("A");
nCell.font = lfont;
nCell.value = " DWG No.";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB4;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A3:F3");
nRow = workSheet.getRow(3);
nCell = nRow.getCell("G");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " 293-111BW Rev.07";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB;
nCell.alignment = mystyle.mediumB2;
workSheet.mergeCells("G3:K3");
nRow = workSheet.getRow(3);
nCell = nRow.getCell("L");
nRow.height = 42;
nCell.font = lfont;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("L3:O3");
nRow = workSheet.getRow(3);
nCell = nRow.getCell("P");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " Date";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("P3:T3");
nRow = workSheet.getRow(3);
nCell = nRow.getCell("U");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " 2023.06. .";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("U3:AD3");
nRow = workSheet.getRow(4);
nRow.height = 42;
nCell = nRow.getCell("A");
nCell.font = lfont;
nCell.value = " PO No.";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB4;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A4:F4");
nRow = workSheet.getRow(4);
nCell = nRow.getCell("G");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " -";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("G4:K4");
nRow = workSheet.getRow(4);
nCell = nRow.getCell("L");
nRow.height = 42;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("L4:O4");
nRow = workSheet.getRow(4);
nCell = nRow.getCell("P");
nCell.font = lfont;
nRow.height = 42;
nCell.value = " Material";
nCell.alignment = mystyle.aroundMedium;
nCell.border = myBorder.mediumB;
workSheet.mergeCells("P4:T4");
nRow = workSheet.getRow(4);
nCell = nRow.getCell("U");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " S355NL";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("U4:AD4");
nRow = workSheet.getRow(5);
nRow.height = 42;
nCell = nRow.getCell("A");
nCell.font = lfont;
nCell.value = " Item";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB4;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A5:F5");
nRow = workSheet.getRow(5);
nCell = nRow.getCell("G");
nRow.height = 42;
nCell.border = myBorder.mediumB;
workSheet.mergeCells("G5:K5");
nRow = workSheet.getRow(5);
nCell = nRow.getCell("L");
nRow.height = 42;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("L5:O5");
nRow = workSheet.getRow(5);
nCell = nRow.getCell("P");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " Size";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("P5:T5");
nRow = workSheet.getRow(5);
nCell = nRow.getCell("U");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " 7832.00 x 6620.00 x 341.00";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("U5:AD5");
nRow = workSheet.getRow(6);
nRow.height = 42;
nCell = nRow.getCell("A");
nCell.font = lfont;
nCell.value = " Result";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB4;
workSheet.mergeCells("A6:F6");
nRow = workSheet.getRow(6);
nCell = nRow.getCell("G");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " □Satifactory □Unsatifactory";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.mediumB;
workSheet.mergeCells("G6:K6");
nRow = workSheet.getRow(6);
nCell = nRow.getCell("L");
nRow.height = 42;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("L6:O6");
nRow = workSheet.getRow(6);
nCell = nRow.getCell("P");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " Q´TY";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("P6:T6");
nRow = workSheet.getRow(6);
nCell = nRow.getCell("U");
nRow.height = 42;
nCell.font = lfont;
nCell.value = " 4EA";
nCell.alignment = mystyle.algLeft;
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("U6:AD6");
nRow = workSheet.getRow(7);
nCell = nRow.getCell("A");
nRow.height = 60;
nCell.font = lfontB;
nCell.value = "CHECKED BY ----------";
nCell.alignment = mystyle.algCenter;
nCell.border = myBorder.boxBottom;
workSheet.mergeCells("A7:H7");
nRow = workSheet.getRow(7);
nCell = nRow.getCell("I");
nRow.height = 60;
nCell.font = lfontB;
nCell.value = "REVIEWED BY ----------";
nCell.alignment = mystyle.algCenter;
nCell.border = myBorder.boxBottom;
workSheet.mergeCells("I7:S7");
nRow = workSheet.getRow(7);
nCell = nRow.getCell("T");
nRow.height = 60;
nCell.font = lfontB;
nCell.value = "APPROVED BY ----------";
nCell.alignment = mystyle.algCenter;
nCell.border = myBorder.boxBottom;
workSheet.mergeCells("T7:AD7");
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",
];
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: [
"Packing Groove Dimension",
"Groove\r\nHeight",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
E: [
"Packing Groove Dimension",
"Groove\r\nHeight",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
F: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
G: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
H: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
I: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
J: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
K: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.2\r\n-0.2",
"",
"",
"",
"millimeter",
],
L: [
"Packing Groove Dimension",
"Groove\r\nwidth",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
M: [
"Packing Groove Dimension",
"Groove\r\nHeight",
"0.90°",
"",
"+0.1\r\n-0.1",
"",
"",
"",
"millimeter",
],
N: [
"Packing Groove Dimension",
"Groove\r\nHeight",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
O: [
"Packing Groove Dimension",
"Groove\r\nHeight",
"0.90°",
"",
"+0.2\r\n-0.2",
"",
"",
"",
"millimeter",
],
P: [
"Packing Groove Dimension",
"Groove\r\nR",
"0.90°",
"",
"+0.5\r\n-0.5",
"",
"",
"",
"millimeter",
],
Q: ["", "", "", "", "", "", "", "", ""],
R: ["", "", "", "", "", "", "", "", ""],
S: ["", "", "", "", "", "", "", "", ""],
T: ["", "", "", "", "", "", "", "", ""],
U: ["", "", "", "", "", "", "", "", ""],
V: [
"R10 Groove Dimension",
"Groove\r\nR",
"0.90°",
"",
"+1.0\r\n-0.0",
"",
"",
"",
"millimeter",
],
W: [
"R10 Groove Dimension",
"Groove\r\ndeepth",
"0.90°",
"",
"+1.0\r\n-0.0",
"",
"",
"16.5",
"millimeter",
],
X: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
Y: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
Z: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
AA: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
AB: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
AC: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
AD: ["R10 Groove Dimension", "", "", "", "", "", "", "", ""],
};
for (const column of columns1) {
for (let i = 0; i < rows1.length; i++) {
const nRow = workSheet.getRow(rows1[i]);
const nCell = nRow.getCell(column);
{
nCell.font = lifontSum2;
nCell.value = columnValues1[column][i];
nCell.alignment = mystyle.algCenter;
nCell.border = myBorder.aroundMedium;
nRow.height = 40;
}
}
}
workSheet.mergeCells("A8:B10");
for (let row = 8; row <= 10; row++) {
nRow8 = workSheet.getRow(row);
nRow8.height = 52;
nCell = nRow8.getCell("A");
nCell.font = lfont;
}
workSheet.mergeCells("A11:B11");
nRow11 = workSheet.getRow(11);
nRow11.height = 27;
nCell = nRow11.getCell("A");
nCell.font = lfont;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A12:B13");
nRow12 = workSheet.getRow(12);
nCell = nRow12.getCell("A");
nRow12.height = 40;
nCell.font = lfont;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A14:B14");
nRow14 = workSheet.getRow(14);
nCell = nRow14.getCell("A");
nRow14.height = 45;
nCell.font = lfont;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A15:B15");
nRow15 = workSheet.getRow(15);
nRow15.height = 27;
nCell = nRow15.getCell("A");
nCell.font = lfont;
nCell.alignment = mystyle.algLeft;
workSheet.mergeCells("A16:B16");
nRow16 = workSheet.getRow(16);
nRow16.height = 27;
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("D8:P8");
workSheet.mergeCells("Q8:U16");
workSheet.mergeCells("V8:AD8");
workSheet.mergeCells("V12:V13");
workSheet.mergeCells("W12:W13");
workSheet.mergeCells("X9:AD16");
const mergeRanges = [
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
"N",
"O",
"P",
];
for (const range of mergeRanges) {
workSheet.mergeCells(`${range}12:${range}13`);
}
nRow = workSheet.getRow(17);
nCell = nRow.getCell("A");
nRow.height = 27;
nCell.value = "Actual value";
nCell.font = lfont;
nCell.border = { top: { style: "double" } };
nCell.alignment = mystyle.algCenter;
workSheet.mergeCells("A17:AD17");
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:A21");
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:B21");
nRow = workSheet.getRow(18);
nCell = nRow.getCell("C");
nCell.border = myBorder.aroundMedium;
workSheet.mergeCells("C18:C21");
nRow = workSheet.getRow(18);
nCell = nRow.getCell("D");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("E");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("F");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("G");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("H");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("I");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("J");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("K");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("L");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("M");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("N");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("O");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("P");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("V");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(18);
nCell = nRow.getCell("W");
nCell.value = "0°";
nCell.font = lifontSum2;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nCell.alignment = mystyle.algLeftB;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("D");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("E");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("F");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("G");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("H");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("I");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("J");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("K");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("L");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("M");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("N");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("O");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("P");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("V");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(19);
nCell = nRow.getCell("W");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("D");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("E");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("F");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("G");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("H");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("I");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("J");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("K");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("L");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("M");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("N");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("O");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("P");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("V");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(20);
nCell = nRow.getCell("W");
nCell.value = "90°";
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nCell.border = myBorder.boxTop1;
nRow.height = 23;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("D");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("E");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("F");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("G");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("H");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("I");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("J");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("K");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("L");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("M");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("N");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("O");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("P");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("V");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
nRow = workSheet.getRow(21);
nCell = nRow.getCell("W");
nCell.font = lifontSum2;
nCell.alignment = mystyle.algLeftB;
nRow.height = 50;
nCell.border = myBorder.boxBottom1;
const mergeRanges1 = [
"Q",
"R",
"S",
"T",
"U",
"X",
"Y",
"Z",
"AA",
"AB",
"AC",
"AD",
];
for (const range of mergeRanges1) {
// Assuming workSheet and myBorder are defined elsewhere in your code
workSheet.mergeCells(`${range}18:${range}19`);
workSheet.mergeCells(`${range}20:${range}21`);
// Assuming you want to set the border for each cell in the merged range
for (let i = 18; i <= 21; i++) {
const cell = workSheet.getCell(`${range}${i}`);
cell.border = myBorder.aroundThin;
}
}
const drawArchive2 = (ws, start) => {
const columns = [
"A",
"B",
"C",
"D",
"E",
"F",
"G",
"H",
"I",
"J",
"K",
"L",
"M",
];
let row = null,
cell = null;
columns.forEach((column, idx) => {
for (let a = 0; a < 0; a++) {
row = ws.getRow(start + a);
cell = row.getCell(column);
}
fnBorder(ws, idx + 1, start, idx + 3, start + 6);
});
fnBorder(ws, 1, start, columns.length, start + 1);
};
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",
];
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 + 4);
});
fnBorder(ws, 1, start, columns.length, start + 4);
};
drawArchive(workSheet, 18);
// // drawArchive( workSheet, 23, '549#2' );
drawArchive2(workSheet, 0);
nRow = workSheet.getRow(22);
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 = 93;
nCell.font = lifontSum2;
workSheet.mergeCells("A22:AD22");
return workSheet;
};
View Git Blame Copy Permalink