HTML&CSS | html3 .csv .xls(엑셀) 다운로드
페이지 정보
작성자 전소현 작성일20-11-09 11:37 조회792회 댓글0건관련링크
본문
/* csv 다운로드 */
function fnCsvReport(title) {
let load_data = "<table><tr><td>엑셀다운로드</td></tr></table>";
var data_type = 'data:text/csv;charset=utf8';
var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");
var fileName = title + '.csv';
var blob2 = new Blob(["\ufeff"+load_data ], {
type: data_type
});
var filename = fileName;
var elem = window.document.createElement('a');
elem.href = window.URL.createObjectURL(blob2);
elem.download = filename;
document.body.appendChild(elem);
elem.click();
document.body.removeChild(elem);
}
/*xls*/
var tab_text = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">';
tab_text = tab_text + '<head><meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
tab_text = tab_text + '<xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>'
tab_text = tab_text + '<x:Name>'+title+'</x:Name>';
tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';
tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';
tab_text = tab_text + '<div class="main-content">';
tab_text = tab_text + '<div class="main-content-inner">';
tab_text = tab_text + '<div class="page-content">';
tab_text = tab_text + '<table id="table">';
// tab_text = tab_text + '<caption>Excel Download Total
tab_text = tab_text + '<thead>';
tab_text = tab_text + '<tr>';
tab_text = tab_text + '</tr>';
tab_text = tab_text + '</thead>';
tab_text = tab_text + '<tbody>';
tab_text = tab_text + '<tr><td>내용<td></tr>';
tab_text = tab_text + '</tbody>';
tab_text = tab_text + '</table>';
tab_text = tab_text + '</div>';
tab_text = tab_text + ' </div>';
tab_text = tab_text + '</div>';
tab_text = tab_text + '<style>';
tab_text = tab_text + 'table {';
tab_text = tab_text + 'width: 100%;';
tab_text = tab_text + '}';
tab_text = tab_text + 'table, th, td {';
tab_text = tab_text + 'border: 1px solid;';
tab_text = tab_text + '}';
tab_text = tab_text + 'thead td { text-align: center; background-color: #f6f6f6; }';
tab_text = tab_text + '</style>';
tab_text = tab_text + '</table></body></html>';
var blob2 = new Blob([tab_text], {
type: 'data:application/vnd.ms-excel;charset=utf-8;base64,'
});
function fnCsvReport(title) {
let load_data = "<table><tr><td>엑셀다운로드</td></tr></table>";
var data_type = 'data:text/csv;charset=utf8';
var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");
var fileName = title + '.csv';
var blob2 = new Blob(["\ufeff"+load_data ], {
type: data_type
});
var filename = fileName;
var elem = window.document.createElement('a');
elem.href = window.URL.createObjectURL(blob2);
elem.download = filename;
document.body.appendChild(elem);
elem.click();
document.body.removeChild(elem);
}
/*xls*/
var tab_text = '<html xmlns:x="urn:schemas-microsoft-com:office:excel">';
tab_text = tab_text + '<head><meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
tab_text = tab_text + '<xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet>'
tab_text = tab_text + '<x:Name>'+title+'</x:Name>';
tab_text = tab_text + '<x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet>';
tab_text = tab_text + '</x:ExcelWorksheets></x:ExcelWorkbook></xml></head><body>';
tab_text = tab_text + '<div class="main-content">';
tab_text = tab_text + '<div class="main-content-inner">';
tab_text = tab_text + '<div class="page-content">';
tab_text = tab_text + '<table id="table">';
// tab_text = tab_text + '<caption>Excel Download Total
tab_text = tab_text + '<thead>';
tab_text = tab_text + '<tr>';
tab_text = tab_text + '</tr>';
tab_text = tab_text + '</thead>';
tab_text = tab_text + '<tbody>';
tab_text = tab_text + '<tr><td>내용<td></tr>';
tab_text = tab_text + '</tbody>';
tab_text = tab_text + '</table>';
tab_text = tab_text + '</div>';
tab_text = tab_text + ' </div>';
tab_text = tab_text + '</div>';
tab_text = tab_text + '<style>';
tab_text = tab_text + 'table {';
tab_text = tab_text + 'width: 100%;';
tab_text = tab_text + '}';
tab_text = tab_text + 'table, th, td {';
tab_text = tab_text + 'border: 1px solid;';
tab_text = tab_text + '}';
tab_text = tab_text + 'thead td { text-align: center; background-color: #f6f6f6; }';
tab_text = tab_text + '</style>';
tab_text = tab_text + '</table></body></html>';
var blob2 = new Blob([tab_text], {
type: 'data:application/vnd.ms-excel;charset=utf-8;base64,'
});
[주소복사] https://www.goodsweb.kr/?u=D41B3VC0
SNS 알리기
핀터레스트
텔레그램로
블로그로
페이스북
트위터
카카오스토리
카톡 공유
관련 블로그
로딩중