如何在web中实现类似excel的表格控件

 1 
 2 
 3 
 4 
 5 
 6 
 7 
 8 
 9 
10 
11 
12 
13 
14 

1 
2 

3 

 1 

其中 =SUM(B5,E3)的公式是RuleJs提供的，return 1+2是自己实现的C#代码脚本，需要单击解析：

 1 public class CSEngine : IHttpHandler {
 2 private static int count = 0;
 3 public void ProcessRequest (HttpContext context) {
 4 context.Response.ContentType = "text/plain";
 5 
 6 try
 7 {
 8 count++;
 9 string ret = "";
10 string code = context.Request["code"].ToString();
11 if (string.IsNullOrEmpty(code))
12 {
13 ret = "参数错误";
14 }
15 else
16 {
17 ScriptOptions options = ScriptOptions.Default
18 .AddReferences(
19 Assembly.GetAssembly(typeof(DBServices.DataAccess))
20 )
21 //.AddImports("System.Data")
22 //.AddImports("System.Data.SqlClient")
23 .AddImports("DBServices");
24 var state = CSharpScript.RunAsync(code, options).Result.ReturnValue;
25 ret = state.ToString();
26 
27 state = null;
28 options = null;
29 }
30 Console.WriteLine(count);
31 context.Response.Write(ret);
32 }
33 catch(Exception ex)
34 {
35 //error
36 Console.WriteLine(count);
37 }
38 }
39 
40 public bool IsReusable {
41 get {
42 return false;
43 }
44 }
45 
46 }