Hi all, I have having a problem when writing the data into the excel file.
Basically, I want the data to be written in such a way where the subsequent list will append the data of the previous list, showing me all data of all list in excel. However, when I used the “Excel.WriteToFile” node, the data of the subsequent list will overwrite the data of the previous list, giving me only the data of subsequent list in Excel. Anyone knows if there is a way to tackle this problem?
Also, is there a way to replace “Empty List” in the sublists with “0” value? I have tried the “List.ReplaceEmptyLists” node from clockwork package but it only replace the “Empty list” in list L3, but not L2 and L1.
Thank you so much!!!