/*private ObservableCollection<MemberInfo> GetMember()
* {
* return new ObservableCollection<MemberInfo>()
* {
* new MemberInfo()
* {
* UserName="******",
* Alias="aaa",
* WsAlias="ddd",
* Technology="ooo",
* Group="ssss",
* VacationHour=6,
* },
* };
* }*/
async public void Readfile()
{
Stream finalstream = await SpreadsheetHelper.filepathhelper();
try
{
members = SpreadsheetHelper.ReadDataFromExcel(finalstream, "Sheet1", "A2", "F29");
this.Members = members;
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message.ToString());
}
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
try
{
Stream finalstream = await SpreadsheetHelper.filepathhelper();
SpreadsheetHelper.ReadDataFromExcel(finalstream, "Sheet1", "A2", "F35", memcoll);
mycollection = memcoll;
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message.ToString());
}
}