Excel根据模板导出数据

        public void CreateExcels(string xlsname, string xlsaddress,DataTable tbdate,string culname, bool islist)

        {

            ExcelEngine excelEngine = new ExcelEngine();

            IApplication application = excelEngine.Excel;

            IWorkbook workbook = application.Workbooks.Open(HttpContext.Current.Server.MapPath(xlsaddress), ExcelParseOptions.Default, false, "");

            if (tbdate != null)

            {

                IWorksheet sheet1 = workbook.Worksheets[0];

                sheet1.Range[1, 1, 1, tbdate.Rows.Count].CellStyle.Font.Bold = true;

                sheet1.Range[1, 1, 1, tbdate.Rows.Count].CellStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter;

                //获取首列名称

                if (islist)

                {

                    for (int i = 1; i < tbdate.Rows.Count+1; i++)

                    {

                        sheet1[1, i].Text = tbdate.Rows[i][0].ToString();

                    }

                    

                    for(int j = 1; j < tbdate.Rows.Count + 1; j++)

                    {

                        for (int i = 1; i < tbdate.Rows.Count + 1; i++)

                        {

                            sheet1[j, i].Text = tbdate.Rows[i][i].ToString();

                        }

                    }

                }

                else

                {

                    for (int i = 0; i < tbdate.Rows.Count; i++)

                    {

                        sheet1[i, 1].Text = tbdate.Rows[i][culname].ToString();

                    }

                }

 

            }

            workbook.SaveAs(HttpUtility.UrlEncode(xlsname+".xls", Encoding.UTF8), ExcelSaveType.SaveAsXLS, HttpContext.Current.Response, ExcelDownloadType.PromptDialog);

            

            workbook.Close();

            excelEngine.ThrowNotSavedOnDestroy = false;

            excelEngine.Dispose();

        }

 

相关DLLhttp://files.cnblogs.com/wanheng/dll.zip

 

转载于:https://www.cnblogs.com/wanheng/archive/2012/01/11/2318867.html