C# 高手的进,要详细代码,在线等
来源:百度知道 编辑:UC知道 时间:2024/06/05 19:31:55
Excel.Application ReportFile;
Excel._Workbook WorkBook;
Excel._Worksheet Sheet;
Excel.Range Range;
try
{
SqlConnection conn = new SqlConnection(IBS_HR_System.DataAccessLayer.dalDBConnection.GetConnectionString());
DataTable dt = new DataTable("ResultRecords");
SqlCommand cmd = new SqlCommand("select * from audit_log", conn);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
//Get Max Cell
String MaxRow = dt.Rows.Count.ToString();
String MaxColumn = ((String)(Convert.ToChar(dt.Columns.Count / 26 + 64).ToString() + Convert.ToChar(dt.Columns.Count % 26 + 64))).Replace('@', ' ').Trim();
String MaxCell = MaxColumn + MaxRow;
//Start Excel
ReportFile = new Excel.Application();
ReportFile.Visible = false;
//New workbook