def test_save_and_read_excel_without_name(tmpdir): original_fitting_data = FittingData(data=RAW_DATA) original_fitting_data.save_excel(tmpdir, sheet=SHEET_NAME) loaded_fitting_data = FittingData.read_from_excel( Path(tmpdir / "fitting_data.xlsx"), SHEET_NAME) assert_fitting_data_are_equal(original_fitting_data, loaded_fitting_data)
def read_excel(self, filepath, sheet): """ Read data from excel file. :param filepath: path of the excel file :param sheet: sheet from which to read the data. """ self.fitting_data = FittingData.read_from_excel(filepath, sheet)
def select_default_sheet(self): """ Automatically choose the first valid sheet. If it fails to find a valid sheet, resets the input file. """ for sheet in self.input_file_box.sheets_options: if sheet != NO_VALUE: try: self.data_columns_box.fitting_data = FittingData.read_from_excel( Path(self.input_file_box.file_path), sheet) self.input_file_box.selected_sheet = sheet return except FittingDataError: pass if self.data_columns_box.fitting_data is None: self.main_window.error_dialog( title="Input data error", message=("No sheet available with valid data.\n" "Please fix the file or load another one."), ) self.input_file_box.file_path = None
def actual_read(file_path, **kwargs): return FittingData.read_from_excel(file_path, SHEET_NAME, **kwargs)
def read_method(**kwargs): return FittingData.read_from_excel(EXCEL_FILE, sheet_name, **kwargs)