tabular parsing from multiple excel sheets
Discussing with @amgo it came out that the following schema wouldn't work because I'm trying to parse data from different excel sheets.
I am trying to fill quantities in 3 different sections (from 3 different sheets) - note that this works with "mode: column":
* the root level, where TableData is inherited and where data_file quantity is placed
* my_subsection_1
* my_subsection_2
Is it possible to make the "mode" keyword specific for the targeted subsection? One could in this way parse one section in column and another in row mode?
If this is not possible, a workaround I see is to instantiate a data_file quantity in each subsection with either column or row modes, and then just link the quantity to the root level data_file one so the user does not need to put the same data_file in each section
One more point, if it is not possible to parse quantities directly in the root level (as it is for mode: column) I may think to move all the root level quantities in a sub_section called global
```
data:
m_def: My_Eln
data_file: test.xlsx
definitions:
name: 'test eln'
sections:
My_Eln:
base_sections:
- nomad.parsing.tabular.TableData
quantities:
data_file:
type: str
m_annotations:
tabular_parser:
comment: '#'
mode: row
target_sub_section:
- My_Eln # (not sure what would be needed here)
- my_subsection_1
- my_subsection_2
browser:
adaptor: RawFileAdaptor
eln:
component: FileEditQuantity
my_parsed_quantity_root:
type: str
m_annotations:
tabular:
name: Sheet_3/Column_header_3
eln:
component: StringEditQuantity
sub_sections:
my_subsection_1:
repeats: true
section:
m_annotations:
eln:
quantities:
my_parsed_quantity_1:
type: str
m_annotations:
tabular:
name: Sheet_1/Column_header_1
eln:
component: StringEditQuantity
my_subsection_2:
repeats: true
section:
m_annotations:
eln:
quantities:
my_parsed_quantity_2:
type: str
m_annotations:
tabular:
name: Sheet_2/Column_header_2
eln:
component: StringEditQuantity
```
issue