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();
}
