导出到excel wholeColumn Autofit无法在Javascript中工作 [英] Export to excel entireColumn Autofit not working in Javascript

问题描述

大家好，



我正在使用JavaScript在Shrepoint中使用export to excel功能。但是Auto Fit不能同样工作。

是否有人有任何想法。

下面是代码片段。

Hi All,

I am using export to excel functionality in Shrepoint using JavaScript. But Auto Fit is not working for the same.
Is anyone is having anyidea.
Below is the code snippet.

function ExportHTMLTableToExcel() { 
    //var thisTable = document.getElementById("ExcelData").innerHTML; 
    var thisTable = $("div.ExcelData").html(); 
    window.clipboardData.setData("Text", thisTable); 
    var objExcel = new ActiveXObject("Excel.Application"); 
    objExcel.visible = true; 
    var objWorkbook = objExcel.Workbooks.Add; 
    var objWorksheet = objWorkbook.Worksheets(1); 
    objWorksheet.Paste; 
    ExcelSheet.Range("A1", "B1", "C1").EntireColumn.AutoFit(); 
    objWorksheet.Range("A1", "Z1").EntireColumn.AutoFit(); 
    
    objWorksheet.Range("C1", "C1").ColumnWidth = 2000; 
}

先谢谢

Thanks in Advance

推荐答案

（ div.ExcelData）。html（）;
window .clipboardData.setData（ Text ，thisTable）;
var objExcel = new ActiveXObject（ Excel.Application）;
objExcel.visible = true ;
var objWorkbook = objExcel.Workbooks.Add;
var objWorksheet = objWorkbook.Worksheets（ 1 ）;
objWorksheet.Paste;
ExcelSheet.Range（ A1， B1， C1< /跨度>）EntireColumn.AutoFit（）;
objWorksheet.Range（ A1， Z1）。EntireColumn.AutoFit（）;

objWorksheet.Range（ C1， C1）。ColumnWidth = 2000 ;
}

("div.ExcelData").html(); window.clipboardData.setData("Text", thisTable); var objExcel = new ActiveXObject("Excel.Application"); objExcel.visible = true; var objWorkbook = objExcel.Workbooks.Add; var objWorksheet = objWorkbook.Worksheets(1); objWorksheet.Paste; ExcelSheet.Range("A1", "B1", "C1").EntireColumn.AutoFit(); objWorksheet.Range("A1", "Z1").EntireColumn.AutoFit(); objWorksheet.Range("C1", "C1").ColumnWidth = 2000; }

先谢谢

Thanks in Advance

这篇关于导出到excel wholeColumn Autofit无法在Javascript中工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！