Hi Chris,
Chris Sherlock schrieb am 04.01.2026 um 05:47:
Hi Regina,
Are you thinking that the functionality is duplicated and it might be better to
merge them into one?
They are different from point of file format and therefore cannot be merged.
The "Insert Sheet from File" tool generates a <table:table-source> child
element of the <table:table> element. Thus it is always a property of an
entire sheet.
The "Data Provider" tool result is bound to a data base range. That is a
<table:database-range> element and effects not an entire sheet but a
cell range of a sheet. Thus several "Data Provider" tool results on one
sheet are possible.
It is more about the internal code. Both work with the liborcus library
but do not have common methods. The "Insert Sheet from File" uses the
library with good results. The "Data Provider" uses the library in case
of CSV and XML and does not work for these cases.
Kind regards,
Regina
