111,098
社区成员




Excel.Application app= new Excel.Application();
Excel.Workbook xbook=app.Workbooks._Open(@"D:\Sample.xlt",Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value);
Excel.Worksheet xsheet=(Excel.Worksheet)xbook.Sheets[1];
xsheet = (Excel.Worksheet)app.ActiveSheet;
for(inti=0;i<datagridview1.RowCount;i++)
{//导入到Excel,从第五行开始写入数据。
app.cells[5+i,1] = datagridview1["Column1", i].Value.ToSteing();
app.cells[5+i,2] = datagridview1["Column2", i].Value.ToSteing();
app.cells[5+i,3] = datagridview1["Column3", i].Value.ToSteing();
app.cells[5+i,4] = datagridview1["Column4", i].Value.ToSteing();
app.cells[5+i,5] = datagridview1["Column5", i].Value.ToSteing();
app.cells[5+i,6] = datagridview1["Column6", i].Value.ToSteing();
app.cells[5+i,7] = datagridview1["Column7", i].Value.ToSteing();
app.cells[5+i,8] = datagridview1["Column8", i].Value.ToSteing();
}
message.box.Show("导入成功);
app.Visible=true;
int[,] datas = new int[1,3];
datas[0, 0] = " ";
datas[0, 1] = "0";
datas[0, 2] = "0";
xR = CurrWorkSheet.get_Range("A1", "A2");//CurrWorkSheet是Microsoft.Office.Interop.Excel._Worksheet对象
xR = xR = xR.get_Resize(1, 3);
xR.value2 = datas;
大数据量明细数据填充如采用一个单元格单元格处理效率较低(将数据解析为二维数据进行自动填充Range.Value2将大大提高效率)
/// <summary>
/// 根据模版标签 整合要填充的数据集信息方法
/// </summary>
/// <param name="srcDataTable">源数据表</param>
/// <param name="detailsRange">标签区域</param>
/// <returns>填充的二维数组</returns>
public object[,] MergerExcelData(System.Data.DataTable srcDataTable, Range detailsRange)
{
object[,] dataArray = new object[srcDataTable.Rows.Count, detailsRange.Cells.Count];
string [] columnList = new string[detailsRange.Cells.Count];
Range range = null;
string parm = string.Empty;
for (int i = 0; i < detailsRange.Cells.Count; i++)
{
range = (Range)detailsRange.Cells[0, i];
if (range.Value2 != null)
{
parm = range.Value2.ToString();
}
parm = ReportUtils.FillterString(parm);
if (parm.IndexOf(">.") > 0)
{
parm = parm.Substring(1, parm.IndexOf(">") - 1);
}
else if (parm.IndexOf(">") >= 2)
{
parm = parm.Substring(1, parm.Length - 2);
}
else
{
parm = string.Empty;
}
columnList[i] = parm ;
}
for (int i = 0; i < srcDataTable.Rows.Count; i++)
{
for (int j = 0; j < columnList.Count; j++)
{
dataArray[i, j] = ReportUtils.GetDataTableData(srcDataTable, i, columnList[j]);
}
}
return dataArray;
}
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/xingjunli/archive/2009/07/13/4345069.aspx
#region Access 2007
Console.WriteLine("Access 2007");
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\Database1.accdb;";
strConnection += "Persist Security Info=False";
using (OleDbConnection objConnection = new OleDbConnection(strConnection))
{
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from Couse", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds, "couse");
DataTable dt = ds.Tables["couse"];
Console.WriteLine(dt.Columns[0].ToString());
Console.WriteLine(dt.Columns[1].ToString());
Console.WriteLine(dt.Columns[2].ToString());
objConnection.Close();
}
#endregion
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/LCL_data/archive/2009/05/06/4154255.aspx