1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| <script language="javascript">
function ExportExcel() {
var oExcel; // Open Excel
var oExcelSheet; // Sheet Excel
var oWkBooks;
// COPY THE CURRENT PAGE
textRange = document.body.createTextRange();
textRange.moveToElementText(divMain);
textRange.execCommand('Copy');
// OPEN EXCEL
oExcel = new ActiveXObject('Excel.Application');
oWkBooks = oExcel.Workbooks.Add;
oExcelSheet = oWkBooks.Worksheets(1);
oExcelSheet.Application.Visible = true;
oExcelSheet.Activate();
oExcel.ActiveSheet.Range('A1').Select;
oExcel.ActiveCell.PasteSpecial(0,false,false);
oExcel.ActiveSheet.Cells.EntireColumn.AutoFit;
oExcel.ActiveSheet.Cells.EntireRow.AutoFit.AutoFit;
oExcel.ActiveSheet.Range('A1').Select;
}
</script> |