html怎么在表格里插入表格,excel单元格中如何插入html代码？()

如何把htm文件转换为excel文件?

直接把html拖到一个空白的Excel文件中保存为Excel文件即可。

怎么用js将excel中的数据读取后显示到网页中的表格

以前的时候绝不会想到会用客户端来实现这些功能，现在却始就要用上了，而且还觉得挺实用的。

参考《Windows脚本技术》，应该会有一点收获。

Untitled Page

function importXLS(fileName)

{

objCon = new ActiveXObject("ADODB.Connection");

objCon.Provider = "Microsoft.Jet.OLEDB.4.0";

objCon.ConnectionString = "Data Source=" fileName ";Extended Properties=Excel 8.0;";

objCon.CursorLocation = 1;

objCon.Open;

var strQuery;

//Get the SheetName

var strSheetName = "Sheet1$";

var rsTemp = new ActiveXObject("ADODB.Recordset");

rsTemp = objCon.OpenSchema(20);

if(!rsTemp.EOF)

strSheetName = rsTemp.Fields("Table_Name").Value;

rsTemp = null

rsExcel = new ActiveXObject("ADODB.Recordset");

strQuery = "SELECT * FROM [" strSheetName "]";

rsExcel.ActiveConnection = objCon;

rsExcel.Open(strQuery);

while(!rsExcel.EOF)

{

for(i = 0;i

{

alert(rsExcel.Fields(i).value);

}

rsExcel.MoveNext;

}

// Close the connection and dispose the file

objCon.Close;

objCon =null;

rsExcel = null;

}

trackback:http://hi.baidu.com/netcorner/blog/item/4c35a818788f670635fa41d3.html

通过Javascript操作Excel

function AutomateExcel()

{

// Start Excel and get Application object.

var oXL = new ActiveXObject("Excel.Application");

oXL.Visible = true;

// Get a new workbook.

var oWB = oXL.Workbooks.Add();

var oSheet = oWB.ActiveSheet;

// Add table headers going cell by cell.

oSheet.Cells(1, 1).Value = "First Name";

oSheet.Cells(1, 2).Value = "Last Name";

oSheet.Cells(1, 3).Value = "Full Name";

oSheet.Cells(1, 4).Value = "Salary";

// Format A1:D1 as bold, vertical alignment = center.

oSheet.Range("A1", "D1").Font.Bold = true;

oSheet.Range("A1", "D1").VerticalAlignment = -4108; //xlVAlignCenter

// Create an array to set multiple values at once.

// Fill A2:B6 with an array of values (from VBScript).

oSheet.Range("A2", "B6").Value = CreateNamesArray();

// Fill C2:C6 with a relative formula (=A2