private async Task ReadFile()
{
Progress = "开始读取excel文件...";
var file = await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///Data/data.xlsx"));
var column = new List <int>();
for (int i = 1; i < 33; i++)
{
column.Add(i);
}
Ret = await ExcelService.ReadAllCellsAsync(file.Path, SheetName.Text, 2, column);
Cells.Clear();
foreach (var item in Ret)
{
Cells.Add(ExcelService.GetCellValue(item));
}
await Task.CompletedTask.ConfigureAwait(true);
}
private async void InsectButton_Click(object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
if (SheetName.Text != "insect")
{
Progress = "Sheet Name Wrong!";
return;
}
await ReadFile();
Progress = "开始写入数据库...";
for (int i = 0; i < Ret.Count; i++)
{
var name = ExcelService.GetCellValue(Ret[i]);
var number = ExcelService.GetCellValue(Ret[i + 1]);
var eng = ExcelService.GetCellValue(Ret[i + 2]);
var jap = ExcelService.GetCellValue(Ret[i + 3]);
var price = ExcelService.GetCellValue(Ret[i + 4]);
var position = ExcelService.GetCellValue(Ret[i + 5]);
var weather = ExcelService.GetCellValue(Ret[i + 6]);
var time = ExcelService.GetCellValue(Ret[i + 7]);
//北半球
var Nappear = new List <string>();
for (int j = 1; j < 13; j++)
{
var value = ExcelService.GetCellValue(Ret[i + 7 + j]);
Nappear.Add(value);
}
var Nmonth = new Month {
AppearMonth = Nappear
};
var north = new North {
Month = Nmonth
};
//南半球
var Sappear = new List <string>();
for (int j = 1; j < 13; j++)
{
var value = ExcelService.GetCellValue(Ret[i + 19 + j]);
Sappear.Add(value);
}
var Smonth = new Month {
AppearMonth = Sappear
};
var south = new South {
Month = Smonth
};
//汇总
var insect = new Insect {
Name = name, Number = Convert.ToInt32(number), English = eng, Japanese = jap, Price = Convert.ToInt32(price), Position = position, Weather = weather, Time = time, Hemisphere = new Hemisphere {
North = north, South = south
}
};
var json = Newtonsoft.Json.JsonConvert.SerializeObject(insect);
SQLiteService.AddInsectData(name, json);
i = i + 31;
}
Progress = "写入数据完成";
}