C#用NPOI实现excel表格数据与DataTable、DataSet间的转换

 

DataSet保存到excel表

#region NPOI保存数据到excel

        /// <summary>

        /// 导出数据到excel中

        /// </summary>

        /// <param name="dataSet"></param>

        /// <param name="filename"></param>

        /// <returns></returns>

        public static bool TablesToExcel(DataSet dataSet, string filename)

        {

            MemoryStream ms = new MemoryStream();

            using (dataSet)

            {

                IWorkbook workBook;

                //IWorkbook workBook=WorkbookFactory.Create(filename);

                string suffix = filename.Substring(filename.LastIndexOf(".") + 1, filename.Length - filename.LastIndexOf(".") - 1);

                if (suffix == "xls")

                {

                    workBook = new HSSFWorkbook();

                }

                else

                    workBook = new XSSFWorkbook();

 

                for (int i = 0; i < dataSet.Tables.Count; i++)

                {

                    ISheet sheet = workBook.CreateSheet(dataSet.Tables[i].TableName);

                    CreatSheet(sheet, dataSet.Tables[i]);

                }

                workBook.Write(ms);

                try

                {

                    SaveToFile(ms, filename);

                    ms.Flush();

                    return true;

                }