读取EXCEL 跨行、跨列代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】读取EXCEL 跨行、跨列
作者:kunkun0921 / 发布于2015/1/26/ 994

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Reflection;

	namespace CAPExcel
	{
	 class Program
	 {
	 static void Main(string[] args)
	 {
	 ExcelHelper eh = new ExcelHelper();
	 eh.Get();

	
	 Console.ReadLine();
	 }

	
	 }

	 class ExcelHelper
	 {
	 Microsoft.Office.Interop.Excel.Application application;
	 Microsoft.Office.Interop.Excel.Workbook workbook;
	 Microsoft.Office.Interop.Excel.Worksheet worksheet;
	 Microsoft.Office.Interop.Excel.Range range;

	 public void Get()
	 {

	 //创建EXCEL应用程序对象
	 application = new Microsoft.Office.Interop.Excel.Application();
	 //加载excel对象
	 workbook = application.Workbooks.Open(System.Environment.CurrentDirectory + "\\system.xls", Missing.Value, Missing.Value,
	 Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
	 Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
	 Missing.Value, Missing.Value);
	 //获取第一个工作簿
	 worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];

	 range = worksheet.get_Range(worksheet.Cells[1, 1], worksheet.Cells[1, 1]);
	 Console.WriteLine("主要标题：" + range.Value2);
	 range = worksheet.get_Range(worksheet.Cells[2, 1], worksheet.Cells[2, 1]);
	 Console.WriteLine("副标题：" + range.Value2);
	 Console.Write("日期：");
	 //获取第一个日期
	 range = worksheet.get_Range(worksheet.Cells[4, 2], worksheet.Cells[4, 2]);
	 Console.Write(range.Value2);
	 //获取第二个日期(因为第一给日期占了4个单元格，所以第二个日期是从第6个单元格开始的)
	 range = worksheet.get_Range(worksheet.Cells[4, 6], worksheet.Cells[4, 6]);
	 Console.Write("\t\t" + range.Value2);
	 Console.WriteLine();
	 //第九行
	 int startRow = 9;
	 //每个专业行数
	 int rowTemp = 3;
	 //每行的课程数量
	 int columnTemp = 4 * 2;
	 //11个专业、每个专业3行课程
	 int endRow = 11 * rowTemp + startRow;
	 List<Professional> list = new List<Professional>();
	 for (startRow = 9; startRow < endRow; startRow = startRow + 3)
	 {
	 Professional p = new Professional()
	 {
	 ProfessionalNo = worksheet.get_Range(worksheet.Cells[startRow, 1], worksheet.Cells[startRow, 1]).Value2.ToString(),
	 ProfessionalName = worksheet.get_Range(worksheet.Cells[startRow + 1, 1], worksheet.Cells[startRow + 1, 1]).Value2.ToString()
	 };
	 //遍历课程行
	 for (int i = 0; i < rowTemp; i++)
	 {
	 for (int j = 0; j < columnTemp; j = j + 2)
	 {
	 Subject s = new Subject();
	 s.SubjectNo = worksheet.get_Range(worksheet.Cells[startRow + i, 2 + j], worksheet.Cells[startRow + i, 2 + j]).Value2;
	 s.ExamTime = j % 4 == 0 ? "上午9:00-11:30" : "下午14:30-17:00";
	 s.SubjectName = worksheet.get_Range(worksheet.Cells[startRow + i, 3 + j], worksheet.Cells[startRow + i, 3 + j]).Value2;
	 if (s.SubjectNo != null)
	 p.SubjectArray.Add(s);

	 }
	 }
	 list.Add(p);
	 }

	 //查看读取数据是否正确
	 foreach (var item in list)
	 {
	 Console.WriteLine("专业名称/专业代码：" + item.ProfessionalName + "/" + item.ProfessionalNo);
	 Console.WriteLine("上午9:00-11:30考试：");
	 foreach (var item2 in item.SubjectArray.Where(p => p.ExamTime == "上午9:00-11:30").ToList())
	 {
	 Console.WriteLine("\t" + item2.SubjectNo + "\t" + item2.SubjectName);
	 }
	 Console.WriteLine("下午14:30-17:00考试：");
	 foreach (var item2 in item.SubjectArray.Where(p => p.ExamTime == "下午14:30-17:00").ToList())
	 {
	 Console.WriteLine("\t" + item2.SubjectNo + "\t" + item2.SubjectName);
	 }
	 Console.WriteLine("-===========================");
	 }
	 }

	
	 }

	 /// <summary>
	 /// 专业代码
	 /// </summary>
	 class Professional
	 {
	 /// <summary>
	 /// 专业名称
	 /// </summary>
	 public string ProfessionalName { get; set; }

	 /// <summary>
	 /// 专业名称代码
	 /// </summary>
	 public string ProfessionalNo { get; set; }

	 /// <summary>
	 /// 专业中的课程集合
	 /// </summary>
	 public List<Subject> SubjectArray = new List<Subject>();
	 }

	 /// <summary>
	 /// 课程代码
	 /// </summary>
	 class Subject
	 {
	 /// <summary>
	 /// 课程代码
	 /// </summary>
	 public object SubjectNo { get; set; }

	 /// <summary>
	 /// 课程名称
	 /// </summary>
	 public object SubjectName { get; set; }

	 /// <summary>
	 /// 课程考试时间
	 /// </summary>
	 public string ExamTime { get; set; }

	
	 }
	}
试试其它关键字
　读取EXCEL　
同语言下
可能有用的
kunkun0921贡献的其它代码(40)