기타 excelio Export 후 파일 다운로드 오류 질문
페이지 정보
작성자 Shin 작성일 2022-01-18 13:40 조회 1,308회 댓글 1건본문
첨부파일
관련링크
안녕하세요.
spreadJs, spreadIo 사용 중 오류가 있어서 이렇게 질문 드립니다.
excelIo의 export 기능 중 excelIo.save 메소드 사용 후 다운로드된 파일을 열어보면 다음과 같이 뜹니다.
'filename.xlsx'의 내용에 문제가 있습니다. 이 통합 문서의 내용을 최대한 복구하시겠습니까? 이 통합 문서의 원본을 신뢰하는 경우 [예]를 클릭하세요.
해당 경고문이 뜬 후 복구를 해보면 스타일이 적용이 되다 만 상태로 되어있고, 데이터는 문제없이 정상적으로 들어가 있었습니다.
이에 스타일 적용을 문제로 삼고, 해당 sheet 객체의 toJson 메소드에서 옵션 파라미터의 ignoreSytle 요소를 true를 주고 다시 다운로드를 해보았더니, 문제 없이 정상 작동 하는 것을 볼 수 있었습니다.
이에 스타일 적용에 문제가 있다고 판단 되나, stringfy된 json문장을 어디를 어떻게 고쳐야할지 감이 잡히지 않아 이렇게 문의 드립니다.
샘플 코드 입니다.
function pf_ExcelReportExport_test(fileName, pobjSheet){
var excelIo = new GC.Spread.Excel.IO();
var fileName = name+".xlsx";
var serializationOption = {
includeBindingSource : true,
ignoreStyle : false,
ignoreFormula : true,
rowHeadersAsFrozenColumns : false,
columnHeadersAsFrozenRows : true,
includeAutoMergedCells : true
}
var tempJson = pobjSheet.toJSON(serializationOption);
var tempDataTable = tempJson.sheets.Sheet1.data.dataTable;
var json = JSON.stringify(tempJson);
excelIo.save(json,function(blob){
saveAs(blob,fileName);
}, function(e){
console.log(e);
});
}
stringfy 된 해당 sheet 입니다.
{"version":"12.2.4","allowUserDragDrop":false,"allowUserDragFill":false,"allowUserZoom":false,"allowSheetReorder":false,"scrollbarMaxAlign":true,"tabStripVisible":false,"tabEditable":false,"newTabVisible":false,"tabNavigationVisible":false,"scrollIgnoreHidden":true,"customList":[],"sheets":{"Sheet1":{"name":"Sheet1","rowCount":2,"columnCount":38,"frozenRowCount":1,"theme":"Office","data":{"dataTable":{"0":{"0":{"value":" "},"1":{"value":" "},"2":{"value":"작업상태"},"3":{"value":"작업상태"},"4":{"value":"주문번호"},"5":{"value":"주문SEQ"},"6":{"value":"LOT_NO."},"7":{"value":"출고예정일"},"8":{"value":"출고일자"},"9":{"value":"상품코드"},"10":{"value":"상품명"},"11":{"value":"주문량"},"12":{"value":"UOM"},"13":{"value":"주문중량"},"14":{"value":"출고량"},"15":{"value":"UOM"},"16":{"value":"출고중량"},"17":{"value":"화주"},"18":{"value":"배송처"},"19":{"value":"송장번호"},"20":{"value":"현재고"},"21":{"value":"불량재고"},"22":{"value":"PLT 수량"},"23":{"value":"BOX수량"},"24":{"value":"창고"},"25":{"value":"비고#1"},"26":{"value":"비고#2"},"27":{"value":"원주문번호"},"28":{"value":"ASN_YN"},"29":{"value":"CNTR_NO"},"30":{"value":"주문구분"},"31":{"value":"등록일"},"32":{"value":"등록자"},"33":{"value":"수정일"},"34":{"value":"수정자"},"35":{"value":"알림명"},"36":{"value":"발송여부"},"37":{"value":"사진"}},"1":{"0":{"value":"합계","style":{"backColor":"#D4D4D4","vAlign":0,"cellType":{"allowOverflow":true,"typeName":"1","editorType":1}}},"1":{"style":{"backColor":"#D4D4D4","cellType":{"allowOverflow":true,"typeName":"1","editorType":1}}},"2":{"style":{"backColor":"#D4D4D4"}},"3":{"style":{"backColor":"#D4D4D4"}},"4":{"style":{"backColor":"#D4D4D4","vAlign":0}},"5":{"style":{"backColor":"#D4D4D4"}},"6":{"style":{"backColor":"#D4D4D4"}},"7":{"style":{"backColor":"#D4D4D4"}},"8":{"style":{"backColor":"#D4D4D4"}},"9":{"style":{"backColor":"#D4D4D4"}},"10":{"style":{"backColor":"#D4D4D4"}},"11":{"value":0,"style":{"backColor":"#D4D4D4"}},"12":{"style":{"backColor":"#D4D4D4"}},"13":{"style":{"backColor":"#D4D4D4"}},"14":{"value":0,"style":{"backColor":"#D4D4D4"}},"15":{"style":{"backColor":"#D4D4D4"}},"16":{"style":{"backColor":"#D4D4D4"}},"17":{"style":{"backColor":"#D4D4D4"}},"18":{"style":{"backColor":"#D4D4D4"}},"19":{"style":{"backColor":"#D4D4D4"}},"20":{"style":{"backColor":"#D4D4D4"}},"21":{"style":{"backColor":"#D4D4D4"}},"22":{"value":0,"style":{"backColor":"#D4D4D4"}},"23":{"value":0,"style":{"backColor":"#D4D4D4"}},"24":{"style":{"backColor":"#D4D4D4"}},"25":{"style":{"backColor":"#D4D4D4"}},"26":{"style":{"backColor":"#D4D4D4"}},"27":{"value":"COUNT : 0","style":{"backColor":"#D4D4D4","vAlign":0}},"28":{"style":{"backColor":"#D4D4D4"}},"29":{"style":{"backColor":"#D4D4D4"}},"30":{"style":{"backColor":"#D4D4D4"}},"31":{"style":{"backColor":"#D4D4D4"}},"32":{"style":{"backColor":"#D4D4D4"}},"33":{"style":{"backColor":"#D4D4D4"}},"34":{"style":{"backColor":"#D4D4D4"}},"35":{"style":{"backColor":"#D4D4D4"}},"36":{"style":{"backColor":"#D4D4D4"}},"37":{"style":{"backColor":"#D4D4D4"}}}},"rowDataArray":[{"style":{"backColor":"#d5dce6","foreColor":"#4e5661","font":"bold 13px Arial"}},{"style":{"font":"bold 14px arial"}}],"columnDataArray":[{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":false,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":false,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}},{"style":{"hAlign":1,"vAlign":1,"formatter":8,"borderLeft":{"color":"#D4D4D4","style":1},"borderTop":{"color":"#D4D4D4","style":1},"borderRight":{"color":"#D4D4D4","style":1},"borderBottom":{"color":"#D4D4D4","style":1},"locked":true,"wordWrap":false}}],"defaultDataNode":{"style":{"hAlign":1,"vAlign":1,"font":"13px Arial"}}},"rowHeaderData":{"defaultDataNode":{"style":{"font":"13px Arial"}}},"colHeaderData":{},"rows":[{"size":35}],"columns":[{"size":35,"visible":true},{"size":35,"visible":true},{"size":120,"visible":false},{"size":120,"visible":true},{"size":100,"visible":true},{"size":75,"visible":true},{"size":75,"visible":true},{"size":95,"visible":true},{"size":85,"visible":true},{"size":150,"visible":true},{"size":250,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":180,"visible":true},{"size":270,"visible":true},{"size":80,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":70,"visible":true},{"size":95,"visible":true},{"size":110,"visible":true},{"size":110,"visible":true},{"size":150,"visible":true},{"size":70,"visible":true},{"size":150,"visible":true},{"size":100,"visible":true},{"size":150,"visible":true},{"size":100,"visible":true},{"size":150,"visible":true},{"size":100,"visible":true},{"size":100,"visible":true},{"size":100,"visible":true},{"size":100,"visible":true},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false},{"size":0,"visible":false}],"colHeaderRowInfos":[{"size":35}],"spans":[{"row":1,"rowCount":1,"col":0,"colCount":2},{"row":1,"col":0,"colCount":1},{"row":1,"col":27,"colCount":1},{"row":1,"col":4,"colCount":1}],"selections":{"0":{"row":0,"rowCount":1,"col":0,"colCount":2},"length":1},"defaults":{"colHeaderRowHeight":"22","colWidth":62,"rowHeaderColWidth":40,"rowHeight":"25"},"outlineColumnOptions":{},"allowCellOverflow":false,"isProtected":true,"protectionOptions":{"allowResizeRows":false,"allowResizeColumns":true,"allowFilter":true,"allowSort":true},"index":0}}}