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();
}
static void Main(string[] args)
{
if (File.Exists("test1.xls"))
{
File.Delete("test1.xls");
}
if (File.Exists("test2.xls"))
{
File.Delete("test2.xls");
}
// 用于测试的数据列表.
List<TestData> testDataList = new List<TestData>();
testDataList.Add(new TestData { UserName = "******", City = "上海", Zip = "200000" });
testDataList.Add(new TestData { UserName = "******", City = "桂林" });
testDataList.Add(new TestData { UserName = "******" });
ExcelDataExportFormater<TestData> format1 = new TestDataExcelExportFormater1();
ExcelDataExportFormater<TestData> format2 = new TestDataExcelExportFormater2();
// 数据导出到 Excel。
ExcelExportProcess<ExcelDataExportFormater<TestData>, TestData> exper =
new ExcelExportProcess<ExcelDataExportFormater<TestData>, TestData>();
// 设置 格式化.
exper.ExcelDataExportFormater = format1;
// 导出.
exper.CreateExcelReport(testDataList, "test1.xls");
Debug.WriteLine("输出到 test1.xls 完毕！");
// 设置 格式化.
exper.ExcelDataExportFormater = format2;
// 导出.
exper.CreateExcelReport(testDataList, "test2.xls");
Debug.WriteLine("输出到 test2.xls 完毕！");
ExcelDataImportFormater<TestData> iformat1 = new TestDataExcelImportFormater1();
ExcelDataImportFormater<TestData> iformat2 = new TestDataExcelImportFormater2();
ExcelImportProcess<ExcelDataImportFormater<TestData>, TestData> impr =
new ExcelImportProcess<ExcelDataImportFormater<TestData>,TestData>();
// 从 test1.xls 读取.
impr.ExcelDataImportFormater = iformat1;
List<TestData> fileList1 = impr.ReadDataFromExcelReport("test1.xls");
Console.WriteLine("从 test1.xls 读取数据！");
foreach (TestData data in fileList1)
{
Console.WriteLine("UserName = {0}, City = {1}, Zip ={2}",
data.UserName,
data.City,
data.Zip);
}
// 从 test2.xls 读取.
impr.ExcelDataImportFormater = iformat2;
List<TestData> fileList2 = impr.ReadDataFromExcelReport("test2.xls");
Console.WriteLine("从 test2.xls 读取数据！");
foreach (TestData data in fileList2)
{
Console.WriteLine("UserName = {0}, City = {1}, Zip ={2}",
data.UserName,
data.City,
data.Zip);
}
Console.ReadLine();
}
static void Main(string[] args)
{
if (File.Exists("test1.xls"))
{
File.Delete("test1.xls");
}
if (File.Exists("test2.xls"))
{
File.Delete("test2.xls");
}
// 用于测试的数据列表.
List <TestData> testDataList = new List <TestData>();
testDataList.Add(new TestData {
UserName = "******", City = "上海", Zip = "200000"
});
testDataList.Add(new TestData {
UserName = "******", City = "桂林"
});
testDataList.Add(new TestData {
UserName = "******"
});
ExcelDataExportFormater <TestData> format1 = new TestDataExcelExportFormater1();
ExcelDataExportFormater <TestData> format2 = new TestDataExcelExportFormater2();
// 数据导出到 Excel。
ExcelExportProcess <ExcelDataExportFormater <TestData>, TestData> exper =
new ExcelExportProcess <ExcelDataExportFormater <TestData>, TestData>();
// 设置 格式化.
exper.ExcelDataExportFormater = format1;
// 导出.
exper.CreateExcelReport(testDataList, "test1.xls");
Debug.WriteLine("输出到 test1.xls 完毕！");
// 设置 格式化.
exper.ExcelDataExportFormater = format2;
// 导出.
exper.CreateExcelReport(testDataList, "test2.xls");
Debug.WriteLine("输出到 test2.xls 完毕！");
ExcelDataImportFormater <TestData> iformat1 = new TestDataExcelImportFormater1();
ExcelDataImportFormater <TestData> iformat2 = new TestDataExcelImportFormater2();
ExcelImportProcess <ExcelDataImportFormater <TestData>, TestData> impr =
new ExcelImportProcess <ExcelDataImportFormater <TestData>, TestData>();
// 从 test1.xls 读取.
impr.ExcelDataImportFormater = iformat1;
List <TestData> fileList1 = impr.ReadDataFromExcelReport("test1.xls");
Console.WriteLine("从 test1.xls 读取数据！");
foreach (TestData data in fileList1)
{
Console.WriteLine("UserName = {0}, City = {1}, Zip ={2}",
data.UserName,
data.City,
data.Zip);
}
// 从 test2.xls 读取.
impr.ExcelDataImportFormater = iformat2;
List <TestData> fileList2 = impr.ReadDataFromExcelReport("test2.xls");
Console.WriteLine("从 test2.xls 读取数据！");
foreach (TestData data in fileList2)
{
Console.WriteLine("UserName = {0}, City = {1}, Zip ={2}",
data.UserName,
data.City,
data.Zip);
}
Console.ReadLine();
}