我在网上找到如下代码,如何改成FOXTABLE的?
function convertExcelToWord(fileList) {
var length = fileList.length
if (length == 0) {
return
}
var excelApp = new ActiveXObject("Excel.Application");
excelApp.Visible = true
excelApp.DisplayAlerts = false
var wordApp = new ActiveXObject("Word.Application");
wordApp.Visible = true;
var doc;
var docRange;
var sheetCount;
var sheet;
var curFolder = fso.GetFolder(curDir);
for (var i = 0; i < length; i ++){
var excelPath = fileList[i]
var workbook = excelApp.Workbooks.Open(excelPath)
doc = wordApp.Documents.Add()
docRange = doc.Range()
var docPath = excelPath.substr(0, excelPath.length - 4) + ".doc"
sheetCount = workbook.WorkSheets.Count
for(var j = 0; j< sheetCount; j ++) {
sheet = workbook.WorkSheets(j + 1)
sheet.UsedRange.Copy()
docRange.PasteExcelTable(false, true, false)
docRange.Collapse(0)
docRange.InsertParagraphAfter()
docRange.Collapse(0)
}
doc.SaveAs(docPath)
doc.Close()
workbook.Close()
}
excelApp.Quit()
wordApp.Quit()
}