static void Main(string[] args) { if (File.Exists("test1.xls")) { File.Delete("test1.xls"); } // Excel 导出格式. ExcelDataExportFormater <TestData> format1 = new TestDataExcelExportFormater1(); // Excel 异步导出处理 AsynchronousExcelExportProcess <ExcelDataExportFormater <TestData>, TestData> exper = new AsynchronousExcelExportProcess <ExcelDataExportFormater <TestData>, TestData>(); // 设置 格式化. exper.ExcelDataExportFormater = format1; // 设置输出文件. exper.OutputFileName = "test1.xls"; // 开始异步处理. exper.StartAsynchronousProcess(); // 模拟 分页数据读取. for (int i = 0; i < 10; i++) { // 队列加入数据. List <TestData> newList = GetTestData(i); exper.AddReportData(newList); } // 结束异步处理. exper.FinishAsynchronousProcess(); Console.WriteLine("异步生成 Excel 处理结束,按回车键开始 异步 Excel 读取!"); Console.ReadLine(); ExcelDataImportFormater <TestData> iformat1 = new TestDataExcelImportFormater1(); AsynchronousExcelImportProcess <ExcelDataImportFormater <TestData>, TestData> impor = new AsynchronousExcelImportProcess <ExcelDataImportFormater <TestData>, TestData>(); // 设置 格式化. impor.ExcelDataImportFormater = iformat1; // 设置输出文件. impor.InputFileName = "test1.xls"; // 设置窗口大小. impor.WindowsSize = 3; // 设置 触发事件. impor.DataReaderStep += new AsynchronousExcelImportProcess <ExcelDataImportFormater <TestData>, TestData> .DataReaderStepHandler(DataReaderStepHandler); impor.DataReaderFinish += new AsynchronousExcelImportProcess <ExcelDataImportFormater <TestData>, TestData> .DataReaderFinishHandler(DataReaderFinishHandler); // 开始异步处理. impor.StartAsynchronousProcess(); while (true) { if (isFinish) { break; } Thread.Sleep(500); } Console.ReadLine(); }
static void Main(string[] args) { if (File.Exists("test1.xls")) { File.Delete("test1.xls"); } // Excel 导出格式. ExcelDataExportFormater<TestData> format1 = new TestDataExcelExportFormater1(); // Excel 异步导出处理 AsynchronousExcelExportProcess<ExcelDataExportFormater<TestData>, TestData> exper = new AsynchronousExcelExportProcess<ExcelDataExportFormater<TestData>, TestData>(); // 设置 格式化. exper.ExcelDataExportFormater = format1; // 设置输出文件. exper.OutputFileName = "test1.xls"; // 开始异步处理. exper.StartAsynchronousProcess(); // 模拟 分页数据读取. for (int i = 0; i < 10; i++) { // 队列加入数据. List<TestData> newList = GetTestData(i); exper.AddReportData(newList); } // 结束异步处理. exper.FinishAsynchronousProcess(); Console.WriteLine("异步生成 Excel 处理结束,按回车键开始 异步 Excel 读取!"); Console.ReadLine(); ExcelDataImportFormater<TestData> iformat1 = new TestDataExcelImportFormater1(); AsynchronousExcelImportProcess<ExcelDataImportFormater<TestData>, TestData> impor = new AsynchronousExcelImportProcess<ExcelDataImportFormater<TestData>, TestData>(); // 设置 格式化. impor.ExcelDataImportFormater = iformat1; // 设置输出文件. impor.InputFileName = "test1.xls"; // 设置窗口大小. impor.WindowsSize = 3; // 设置 触发事件. impor.DataReaderStep += new AsynchronousExcelImportProcess<ExcelDataImportFormater<TestData>, TestData>.DataReaderStepHandler(DataReaderStepHandler); impor.DataReaderFinish += new AsynchronousExcelImportProcess<ExcelDataImportFormater<TestData>, TestData>.DataReaderFinishHandler(DataReaderFinishHandler); // 开始异步处理. impor.StartAsynchronousProcess(); while (true) { if (isFinish) { break; } Thread.Sleep(500); } Console.ReadLine(); }