Excel生成DataTable DataTable转Excel

split = line.Split('|');
foreach (String item in split)
{
dr[i] = item.Replace("\"", "");
i++;
}
dt.Rows.Add(dr);
}
sr.Close();
{
Excel.Range range = sheet.Cells[row, i + 1] as Excel.Range;
dr[i] = range.Text;
}
dt.Rows.Add(dr);
for (int i = 0; i < 10; i++)
{
Excel.Range range = sheet.Cells[1, i + 1] as Excel.Range;
dt.Columns.Add(range.Text);
}
int row = 2;
while (true)
using System.Data;
using System.IO;
using Model;
using System.Data.SqlClient;
using System.Windows.Forms;
using System.Data.OleDb;
namespace FileWay
foreach (String item in split)
{
dt.Columns.Add(item, System.Type.GetType("System.String"));
}
int i = 0;
while ((line=sr.ReadLine())!=null)
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;
row++;
}
return dt;
}
/// <summary>
/// 生成Excel
/// </summary>
/// <param name="datas">Table</param>
/// <param name="p">路径</param>
{
dt.Columns.Add(item, System.Type.GetType("System.String"));
}
int r.ReadLine()) != null)
{
i = 0;
dr = dt.NewRow();
/// HotelAmenities
/// </summary>
/// <param name="ExcelPath">ExcelPath路径.CSV</param>
/// <returns></returns>
{
public class ChangeExcel
{
private string strcon = "server=127.0.0.1;uid=sa;pwd=sasa;database=数据库名";
public void Changes(string Ways) {
Excel.Application app = new Excel.Application();
ha.EditedDate = DateTime.Now;
list.Add(ha);
}
return list;
}
/// <summary>
/// 通过Excel获取Table
/// </summary>
/// <returns></returns>
using (SqlBulkCopy datecopy = new SqlBulkCopy(conn))
{
datecopy.DestinationTableName = tableName;
try
{
datecopy.WriteToServer(dt);//复制DataTable数据到数据库
i++;
}
dt.Rows.Add(dr);
}
sr.Close();
CopyToService("HotelAmenities", dt);//复制表数据到数据库
}
/// <summary>
/// 将Table转换成List
/// </summary>
private void DataGridToExcel(DataTable datas, string p)
{
Excel.Application app = new Excel.Application();
app.SheetsInNewWorkbook = 1;
app.Workbooks.Add();
ha.AmenityId = Convert.ToInt32(item[2].ToString());
ha.AmenityName = item[3].ToString();
ha.Timestamp = Convert.ToDateTime(item[4].ToString());
ha.ProductStatus = item[5].ToString();
StreamReader sr = new StreamReader(@"D:HBE城市代码表.xlsx", System.Text.Encoding.UTF8);
line = sr.ReadLine();
split = line.Split('|');
foreach (String item in split)
DataTable dt = new DataTable();
app.Workbooks.Open(Ways);
Excel.Worksheet sheet = app.ActiveWorkbook.Worksheets[1];
}
/// <summary>
/// J
/// 通过Excel获取Table
}
for (int i = 0; i < datas.Rows.Count; i++)
{
for (int j = 0; j < datas.Columns.Count; j++)
{
Excel.Range ran = sheet.Cells[row, 2] as Excel.Range;
if (string.IsNullOrEmpty(ran.Text.Trim()))
{
break;
}
DataRow dr = dt.NewRow();
for (int i = 0; i < 10; i++)
{
i = 0;
dr = dt.NewRow();
split = line.Split('|');
foreach (String item in split)
{
dr[i] = item.Replace("\"", "");
MessageBox.Show("OK!");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
return "";
}
/// <summary>
/// Excel转Table
return ds;
}
/// <summary>
/// J
/// 数据操作
///
/// </summary>
/// <returns></returns>
public string CopyToServices(string tableName, DataTable dt)