I am having an issue using TTToolbox’s excel features. The intent is to export data to 1 worksheet in an excel file. And then read data from a different worksheet in the same excel file. But when using both at same time, the data gets written to the wrong worksheets, overwriting important calculations etc.
Sending data to Excel works as intended (on its own), reliably sending the data to worksheet ‘1’.
However as soon as i connect ‘XL In’ to read the second worksheet. The XL Out component changes what worksheet it is exporting data to.
This seems like a relatively basic issue, so i am not sure if I am doing something incorrectly. I have tried on 2 different machines. Please let me know your thoughts.
Lunchbox excel tools are reliable, but lack the ‘live’ listen feature to changes in file.
Thank you for suggesting the great plugin. But Bumblebee seems to throw an error if the list of indices in each tree is non equal. (eg {0} N=1, {1}, N=2) . This seems to be an issue in TT Toolbox as well. I don’t want to add nulls / zeros to make the indices equal. Is there any other way?
Yes, that’s something I think the latest version seens to be missing (i’ve contacted David Mans about it)
In the meantime, with the previous version of Bumblebee, you can have different lengths.
You can also send Nulls to excel so that cells stay empty allowing you to skip columns for example.
Here’s the workflow i’ve been using to send multiple tables in excel using only one export component.
you’ll need Wombat and Elefront and the previous release of Bumblebee for this to run.
