Hi,
I am using the Excel dynamic read plugin/component that Xiaoming had made, but it doesn’t work properly when i try to get the Path linked to the component. Everytime i get the error:
- Solution exception:Object reference not set to an instance of an object.
Sometimes it opens the file, but then after editing something it doesnt open anymore. If i use the Static version of the component, then it works, but its not a direct live link.
Does anyone know how i can fix this?
I have figured out that the dynamic read only works with 1 file at a time and 1 sheet. Is there an option to read multiple sheets dynamic and let it be as a data tree? Cause if i now connect that sheet 1 and 2 needs to be read and i try to get the right range on both, it just goes for that range on both sheets. So example:
I want to read on sheet 1 only A3 and on sheet 2 B3, the component gives me on both sheets the values of A3 and B3. Does anyone know if there is a way to split this per sheet?
1 Like
Were you able to find a solution to this? I am also looking for a live link with multiple sheets.
I found a way to read multiple sheets with excel+ but I am now looking for a sort of live link reading and writing to excel.
