随笔分类 -  Excel

摘要：private void OpenForEditSheet(string strFilePath, string strSheetName) { Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new ApplicationClass(); Microsoft.Office.Interop.Excel.Workbooks xlWorkbooks; Microsoft.Office.Interop.Excel.Workbook xlWorkbook; Microsoft.Office.Interop.Excel.Worksheet 阅读全文

摘要：private void OpenForEditSheet(string strFilePath, string strSheetName) { Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new ApplicationClass(); Microsoft.Office.Interop.Excel.Workbooks xlWorkbooks; Microsoft.Office.Interop.Excel.Workbook xlWorkbook; Microsoft.Office.Interop.Excel.Worksheet 阅读全文

摘要：//此方法不可少public override void VerifyRenderingInServerForm(Control control) { //base.VerifyRenderingInServerForm(control); } protected void btnExpExcel_Click(object sender, EventArgs e) { this.Response.Clear(); this.Response.AppendHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.To 阅读全文

摘要：private void UpdateSheet(string strFilePath, string strSheetName) { Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new ApplicationClass(); Microsoft.Office.Interop.Excel.Workbooks xlWorkbooks; Microsoft.Office.Interop.Excel.Workbook xlWorkbook; Microsoft.Office.Interop.Excel.Worksheet xlWor 阅读全文

摘要：调用Excel的打印预览页面public void ExcelPrint(string strFilePath, string strSheetName) { Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new ApplicationClass(); Microsoft.Office.Interop.Excel.Workbooks xlWorkbooks; Microsoft.Office.Interop.Excel.Workbook xlWorkbook; Microsoft.Office.Interop.Excel.Wor 阅读全文