当前位置： 移动技术网 > IT编程>开发语言>c# > c#生成excel示例sql数据库导出excel

c#生成excel示例sql数据库导出excel

2019年07月18日  | 移动技术网IT编程  | 我要评论

复制代码 代码如下:

using system;
using system.collections.generic;
using system.linq;
using system.text;
using microsoft.office.interop.excel;
using system.reflection;

namespace listtoexcel
{
    class program
    {
        static list<objtype> objs = new list<objtype>();
        static void main(string[] args)
        {
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            objs.add(new objtype() { name = "allen", val = "aaa" });
            exportdatatoexcel("", "", @"c:\a.xls", "a");
        }
        /// <summary>
        /// 直接导出数据到excel
        /// </summary>
        /// <param name="connectionstring">连接字符串</param>
        /// <param name="sql">查询语句</param>
        /// <param name="filename">文件名</param>
        /// <param name="sheetname">表名</param>
        static void exportdatatoexcel(string connectionstring, string sql, string filename, string sheetname)
        {
            application app = new application();
            workbook wb = app.workbooks.add(missing.value);
            worksheet ws = wb.worksheets.add(missing.value, missing.value, missing.value, missing.value) as worksheet;
            ws.name = sheetname;
            try
            {
                int n = 0;

                for (int i = 1; i < objs.count; i++)
                {
                      var excelrange = (range)ws.cells[i, 1];
                   excelrange.value2 = objs[i].val;//value2?
                   excelrange = null;
                }
            }
            catch (exception ex)
            {
                string str = ex.message;
            }
            finally
            {
                wb.saved = true;
                wb.savecopyas(filename);//保存
                app.quit();//关闭进程
            }
        }
    }
    class objtype
    {
        public string name { get; set; }
        public string val { get; set; }
    }
}

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网