/// <summary> /// 将dataset里所有数据导入excel. /// 需要添加com: microsoft excel object library. /// using excel; /// </summary> /// <param name="filepath"></param> /// <param name="ds"></param> public static void exporttoexcel(string filepath, dataset ds) { object omissing = system.reflection.missing.value; excel.applicationclass xlapp = new excel.applicationclass(); try { // 打开excel文件.以下为office 2000. excel.workbook xlworkbook = xlapp.workbooks.open(filepath, omissing, omissing, omissing, omissing, omissing, omissing, omissing, omissing, omissing, omissing, omissing, omissing); excel.worksheet xlworksheet; // 循环所有datatable for( int i=0; i<ds.tables.count; i++ ) { // 添加入一个新的sheet页.... 下一页