m_objSheet.Cells[2,1] = "打印日期"+DateTime.Now.ToShortDateString();
for(int i = 1;i<=strTitle.Length;i++)
{
m_objSheet.Cells[4,i] = strTitle[i-1].ToString();
}
m_objRange = m_objSheet.get_Range("A5", m_objOpt);
m_objQryTable = m_objSheet.QueryTables.Add("OLEDB;Provider=SQLOLEDB.1;" + sqlConn.ConnectionString, m_objRange, strQuery);
m_objQryTable.RefreshStyle = Excel.XlCellInsertionMode.xlInsertEntireRows;
m_objQryTable.FieldNames = false;
m_objQryTable.Refresh(false);
}
}
}
全盘复制另存新类后，调用方法示例如下：
private void button2_Click(object sender, EventArgs e)
{
#region ExcelManager封装类导出Excel
String strConnet ="Data Source='localhost';Password = ;User ID=sa;Initial Catalog=Northwind";
System.Data.Sql << 上一页 [11] [12] [13] 下一页 |
