Code
function openExcel()
{
wApp = new ActiveXObject("Excel.Application.11");
wApp.Visible = true ;
wApp.Workbooks.Open( "http://127.0.0.1/1.xls" );
<%= jsString %>
}
function openExcel()
{
wApp = new ActiveXObject("Excel.Application.11");
wApp.Visible = true ;
wApp.Workbooks.Open( "http://127.0.0.1/1.xls" );
<%= jsString %>
}
Code
public string jsString = "";
/// <summary>
/// 拼字符串
/// </summary>
/// <param name="Position"></param>
/// <param name="Value"></param>
public void SetJsValue(string Position, string Value)
{
string jsString = @"wApp.ActiveSheet.Range('" + Position + "').Select;wApp.ActiveCell.FormulaR1C1='" + Value.Replace("'", "") + "';";
this.jsString += jsString;
}
public string jsString = "";
/// <summary>
/// 拼字符串
/// </summary>
/// <param name="Position"></param>
/// <param name="Value"></param>
public void SetJsValue(string Position, string Value)
{
string jsString = @"wApp.ActiveSheet.Range('" + Position + "').Select;wApp.ActiveCell.FormulaR1C1='" + Value.Replace("'", "") + "';";
this.jsString += jsString;
}
调用:SetJsValue("B8:E8", "123123123");