title: Inserting hyperlink in the DataTable C#
body: <p>I would like to add the hyperlink in export the dataTable into excel</p>
  
  <p>But the excel cannot show the hyperlink property, only strings.</p>
  
  <p>Is there any limitation for the dataTable input field ? </p>
  
  <p>below is my code for formatting the DATATABLE</p>
  
  <pre><code>       int dt_current_row = 0;
          string[] Days = testDays.ToArray();
  
          for (int i = 0; i &lt; tableOriginal.Rows.Count; i++)
          {
              string wo_number = handle(tableOriginal.Rows[i]["WO_NUMBER"].ToString());
              string date = handle(tableOriginal.Rows[i]["CREATE_DATE"].ToString());
  
              if (i == 0)
              {
  
                  // Insert New
                  DataRow dr = dt.NewRow();
                  dt.Rows.Add(dr);
                  dr["WO_NUMBER"] = wo_number;
  
                  for (int x = 1; x &lt; dt.Columns.Count; x++)
                  {
                      int z = Convert.ToInt32(Math.Floor(0.5 * (x - 1)));
                      //search Date
                      if (tableOriginal.Rows[i]["CREATE_DATE"].ToString() == Days[z])
                      {
                          //if equal , insert num and ID 
                          object xx = tableOriginal.Rows[i]["NUM"];
                          int num = Convert.ToInt32(xx);
                          dr["PHOTO_" + z.ToString()] = num;
  
                          object yy = tableOriginal.Rows[i]["PHOTO_ID"];
                          string photo = Convert.ToString(yy);
                          dr["ID_" + z.ToString()] = HttpContext.Current.Server.HtmlEncode(httpLink + photo);
  
                          break;
                      }
                  }
              }
  </code></pre>
  
  <p>....and the part to export cells in DataTable into cells in excel Document xls
  I have tried to set the formula but it doesn't work</p>
  
  <pre><code>foreach (DataRow r in result.Rows)
      {
          currentCol = 1;
          foreach (DataColumn c in result.Columns)
          {
              string temp = c.ColumnName.ToString().Substring(0,2);
              if (temp.Equals("ID")) 
              {
                  httpLinkForPhoto = r[currentCol - 1].ToString();
                  if (!httpLinkForPhoto.Equals(null))
                  {
                      string formula = "=HYPERLINK(" + httpLinkForPhoto + "," + httpLinkForPhoto + ")";
                      excelDoc2.SetFormula(1, 1, currentRow, currentCol, currentRow, currentCol, formula);
                  }
              }
              else
              { 
                  excelDoc2.setCell(1, 1, currentRow, currentCol, r[currentCol - 1].ToString()); 
              }            
              currentCol++;
          }
          currentRow++;
      }
  </code></pre>