public async Task StorePatientRecordInExcelAsyncTest() { var patient = new Patient { Id = 0, Name = "Muster", Vorname = "Hans", Strasse = "Teststrasse 99", Plz = 9999, Ort = "Testort", Geburtsdatum = new DateTime(1901, 1, 1), Geschlecht = GeschlechtType.M, PatientenNr = "PatientenNr002", AhvNr = "AhvNr002", VekaNr = "VekaNr002", VersichertenNr = "VersNr002", Kanton = "TE", Kopie = false, VerguetungsArt = VerguetungsartType.Tp, VertragsNr = "VertrNr002" }; var excel = new ExcelConnector(ExcelFilePath); //var res = await excel.StorePatientRecordInExcelAsync(patient); await excel.StorePatientRecordInExcelAsync(patient); }
private void GetPatientRecords() { try { Mouse.OverrideCursor = Cursors.Wait; _excel = new ExcelConnector(ExcelFilePath); DataGridPatient.ItemsSource = _excel.ReadAllPatientsFromExcelAsync().Result; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { Mouse.OverrideCursor = null; } }
public void GenerarReporte1(string archivo, List <List <String> > datos) { ExcelConnector excel = new ExcelConnector(archivo); excel.WriteToSheet("CUENTAS", datos); }
public async Task ReadAllPatientsFromExcelAsyncTest() { var excel = new ExcelConnector(ExcelFilePath); var patients = await excel.ReadAllPatientsFromExcelAsync(); }