JAVA EXCEL A
Excel 鲜为人知的秘
May
10
[转载]
protected void ButtonExport_Click(object sender, EventArgs e)
{
string strFileName = "../excel/template.xls";//"D:\\template\\template.xls";
string strSaveFileName = "../excel/" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + ".xls";
Excel.Application ThisApplication = new Excel.ApplicationClass();
Excel.Workbook ThisWorkBook;
object missing = System.Reflection.Missing.Value;
//加载Excel模板文件
ThisWorkBook = ThisApplication.Workbooks.Open(OK(strFileName), missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
//Response.Write("<script>alert('!');</script>");
Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
string account = LabelAccount.Text;
DataTable dt = oh.GetLaborone(account).Tables[0];
DataTable dtamout = new DataTable();
dtamout.Columns.Add("人员编号");
dtamout.Columns.Add("姓名");
dtamout.Columns.Add("部门");
dtamout.Columns.Add("应发额");
dtamout.Columns.Add("代扣税");
dtamout.Columns.Add("本次实发");
dtamout.Columns.Add("项目");
dtamout.Columns.Add("备注");
for (int i = 0; i < dt.Rows.Count; i++)
{
string username = dt.Rows[i][1].ToString();
string realname = dt.Rows[i][2].ToString();
string yingfae = dt.Rows[i][4].ToString();
string Remarks = dt.Rows[i][5].ToString();
string part = uh.getpart(username);
DataTable dtrate = oh.GetRateTable(username, account);
string amount = dtrate.Rows[0][3].ToString();
double daikoushui = Convert.ToDouble(yingfae) - Convert.ToDouble(amount);
ThisSheet.Cells[1, 1] = "人员编号";
ThisSheet.Cells[1, 2] = "姓名";
ThisSheet.Cells[1, 3] = "部门";
ThisSheet.Cells[1, 4] = "应发额";
ThisSheet.Cells[1, 5] = "代扣税";
ThisSheet.Cells[1, 6] = "本次实发";
ThisSheet.Cells[1, 7] = "项目";
ThisSheet.Cells[1, 8] = "备注";
ThisSheet.Cells[i + 2, 1] = username;
ThisSheet.Cells[i + 2, 2] = realname;
ThisSheet.Cells[i + 2, 3] = part;
ThisSheet.Cells[i + 2, 4] = yingfae;
ThisSheet.Cells[i + 2, 5] = daikoushui.ToString();
ThisSheet.Cells[i + 2, 6] = amount;
ThisSheet.Cells[i + 2, 7] = Remarks;
ThisSheet.Cells[i + 2, 8] = "";
}
ThisApplication.Visible = false;
ThisSheet.SaveAs(OK(strSaveFileName), missing, missing, missing, missing, missing, missing, missing, missing, missing);
//打开刚才生成的Excel文件
//Excel.Workbook NewWorkBook;
//NewWorkBook = ThisApplication.Workbooks.Open(strSaveFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
//Excel.Worksheet NewSheet = (Excel.Worksheet)NewWorkBook.Sheets[1];
//ThisApplication.Visible = true;
// System.Diagnostics.Process.Start(strSaveFileName);
//也可以使用System.Diagnostics.Process.Start(strSaveFileName);来打开新文件
Response.Redirect(strSaveFileName);
}
一直没弄好怎么在本地打开，最后还是找了老朱。
看老朱弄好时挺郁闷了，本来挺简单的一个方法，自己就是没想到。
[转载]原文链接: http://www.cnblogs.com/gengxiaochao/archive/2008/05/09/1190253.html
protected void ButtonExport_Click(object sender, EventArgs e) { string strFileName = "../excel/template.xls";//"D:\\template\\template.xls"; string strSaveFileName = "../excel/" + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + ".xls"; Excel.Application ThisApplication = new Excel.ApplicationClass(); Excel.Workbook ThisWorkBook; object missing = System.Reflection.Missing.Value; //加载Excel模板文件 ThisWorkBook = ThisApplication.Workbooks.Open(OK(strFileName), missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); //Response.Write("<script>alert('!');</script>"); Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1]; string account = LabelAccount.Text; DataTable dt = oh.GetLaborone(account).Tables[0]; DataTable dtamout = new DataTable(); dtamout.Columns.Add("人员编号"); dtamout.Columns.Add("姓名"); dtamout.Columns.Add("部门"); dtamout.Columns.Add("应发额"); dtamout.Columns.Add("代扣税"); dtamout.Columns.Add("本次实发"); dtamout.Columns.Add("项目"); dtamout.Columns.Add("备注"); for (int i = 0; i < dt.Rows.Count; i++) { string username = dt.Rows[i][1].ToString(); string realname = dt.Rows[i][2].ToString(); string yingfae = dt.Rows[i][4].ToString(); string Remarks = dt.Rows[i][5].ToString(); string part = uh.getpart(username); DataTable dtrate = oh.GetRateTable(username, account); string amount = dtrate.Rows[0][3].ToString(); double daikoushui = Convert.ToDouble(yingfae) - Convert.ToDouble(amount); ThisSheet.Cells[1, 1] = "人员编号"; ThisSheet.Cells[1, 2] = "姓名"; ThisSheet.Cells[1, 3] = "部门"; ThisSheet.Cells[1, 4] = "应发额"; ThisSheet.Cells[1, 5] = "代扣税"; ThisSheet.Cells[1, 6] = "本次实发"; ThisSheet.Cells[1, 7] = "项目"; ThisSheet.Cells[1, 8] = "备注"; ThisSheet.Cells[i + 2, 1] = username; ThisSheet.Cells[i + 2, 2] = realname; ThisSheet.Cells[i + 2, 3] = part; ThisSheet.Cells[i + 2, 4] = yingfae; ThisSheet.Cells[i + 2, 5] = daikoushui.ToString(); ThisSheet.Cells[i + 2, 6] = amount; ThisSheet.Cells[i + 2, 7] = Remarks; ThisSheet.Cells[i + 2, 8] = ""; } ThisApplication.Visible = false; ThisSheet.SaveAs(OK(strSaveFileName), missing, missing, missing, missing, missing, missing, missing, missing, missing); //打开刚才生成的Excel文件 //Excel.Workbook NewWorkBook; //NewWorkBook = ThisApplication.Workbooks.Open(strSaveFileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); //Excel.Worksheet NewSheet = (Excel.Worksheet)NewWorkBook.Sheets[1]; //ThisApplication.Visible = true; // System.Diagnostics.Process.Start(strSaveFileName); //也可以使用System.Diagnostics.Process.Start(strSaveFileName);来打开新文件 Response.Redirect(strSaveFileName); }一直没弄好怎么在本地打开，最后还是找了老朱。
看老朱弄好时挺郁闷了，本来挺简单的一个方法，自己就是没想到。
[转载]原文链接: http://www.cnblogs.com/gengxiaochao/archive/2008/05/09/1190253.html
