我如何从asp.net检查Excel工作表中的特殊字符 [英] how can i check specialcharacters in excel sheet from asp.net

问题描述

我有一张Excel工作表，我将我的Excel工作表绑定到gridview.no iam检查特殊字符.我得到了，但它显示了最后一个单元格两次.我还要显示单元格号也是一件事.我的代码是

Hi,

I have one excel sheet and i am binding my excelsheet to gridview.no iam checking specialcharacters .i am getting but it displays last cell two times.And one more thing i want to display cell number also.my code is

SqlConnection cn = new SqlConnection("server=LakshmiNarayana;uid=sa;pwd=cybage@123;database=narayana");
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                bind();
            }

        }
        public void bind()
        {
            string cnstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\\Book2.xls;" + "Extended Properties=Excel 8.0";
            OleDbConnection oledbConn = new OleDbConnection(cnstr);
            string strSQL = "SELECT * FROM [Sheet1$]";
            OleDbCommand cmd = new OleDbCommand(strSQL, oledbConn);
            DataTable dt = new DataTable();
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            da.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }

protected void Button1_Click(object sender, EventArgs e)
       {

           string cnstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\\Book2.xls;" + "Extended Properties=Excel 8.0";
           OleDbConnection oledbConn = new OleDbConnection(cnstr);
           string strSQL = "SELECT * FROM [Sheet1$]";
           OleDbCommand cmd = new OleDbCommand(strSQL, oledbConn);
           DataTable dt = new DataTable();
           OleDbDataAdapter da = new OleDbDataAdapter(cmd);

           da.Fill(dt);
           for (int i = 0; i < dt.Rows.Count; i++)
           {
               for (int j = 0; j < dt.Columns.Count; j++)
               {

                   string str = dt.Rows[i][j].ToString();
                   string str1 = "#$%^@";
                   for (int k = 0; k < str1.Length; k++)
                   {
                       for (int l = 0; l < str.Length; l++)
                       {
                           if (str1[k] == str[l])
                           {
                               switch (j)
                               {
                                   case 1:
                                       s = "B";
                                       break;
                                   case 2:
                                       s = "C";
                                       break;
                                   case 3:
                                       s = "D";
                                       break;
                                   case 4:
                                       s = "E";
                                       break;
                                   default:
                                       s = "Z";
                                       break;


                               }
                               Page.RegisterStartupScript("<script>", "<script>alert('" + s + (i+1).ToString() + "')</script>");
                               Response.Write(dt.Rows[i][j].ToString());
                           }
                       }

                   }
               }
               Response.Write("<br>");
           }

推荐答案

"; OleDbCommand cmd = 新 OleDbCommand(strSQL，oledbConn); DataTable dt = 新 DataTable(); OleDbDataAdapter da = 新 OleDbDataAdapter(cmd); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }

"; OleDbCommand cmd = new OleDbCommand(strSQL, oledbConn); DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }

protected void Button1_Click(object sender, EventArgs e)
       {

           string cnstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\\Book2.xls;" + "Extended Properties=Excel 8.0";
           OleDbConnection oledbConn = new OleDbConnection(cnstr);
           string strSQL = "SELECT * FROM [Sheet1

" ; OleDbCommand cmd = 新 OleDbCommand(strSQL，oledbConn); DataTable dt = 新 DataTable(); OleDbDataAdapter da = 新 OleDbDataAdapter(cmd); da.Fill(dt); for ( int i = 0 ; i < dt.Rows.Count; i ++) { for ( int j = 0 ; j < dt.Columns.Count; j ++) { 字符串str = dt.Rows [i] [j] .ToString(); 字符串str1 = "

"; OleDbCommand cmd = new OleDbCommand(strSQL, oledbConn); DataTable dt = new DataTable(); OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { string str = dt.Rows[i][j].ToString(); string str1 = "#

％^ @" ; for ( int k = 0 ; k < str1.Length; k ++) { for ( int l = 0 ; l < str.Length; l ++) { 如果(str1 [k] == str [l]) { 开关(j) { 案例 1 : s = " ; break ; 案例 2 : s = " ; break ; 案例 3 : s = " ; break ; 案例 4 : s = " ; break ; 默认: s = " ; break ; } Page.RegisterStartupScript(" ，" < script>警报('" + s +(i + 1).ToString()+ ')</script>"); Response.Write(dt.Rows [i] [j] .ToString()); } } } } Response.Write(" ); }

%^@"; for (int k = 0; k < str1.Length; k++) { for (int l = 0; l < str.Length; l++) { if (str1[k] == str[l]) { switch (j) { case 1: s = "B"; break; case 2: s = "C"; break; case 3: s = "D"; break; case 4: s = "E"; break; default: s = "Z"; break; } Page.RegisterStartupScript("<script>", "<script>alert('" + s + (i+1).ToString() + "')</script>"); Response.Write(dt.Rows[i][j].ToString()); } } } } Response.Write("<br>"); }

这篇关于我如何从asp.net检查Excel工作表中的特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！