Hi,Is there option to limit time spend on loading Excel data to GC from multiple cells (different nodes uses different cells in excel). Writing data (export) from GC works fine (it's do it at once).In my case, I'm using single excel spreadsheet file with multiple cells and its opening Excel app each time GC is reading data (over 40times) and close and save excel app before reading next data.
Second issue is that when macros are in excel spreadsheet (saved with macro-enable option), it can't be use for GC data import source.Is there solution for that (we need macros inside excel) and use it without additional steps (exporting/importing data between macro-eneble excel and regular one). We need to read and write data using GC.We want to use simple excel software for data import.
Hello Mariusz,
Mariusz Mozgawa said:Is there option to limit time spend on loading Excel data to GC from multiple cells (different nodes uses different cells in excel). Writing data (export) from GC works fine (it's do it at once).
There is no such option of time limits but there is an option on all the nodes which is called Deferred update that can be used to limit which nodes you want to update & which you don't want.
Can you please explain more about macro enabled excel and what is the error you are getting while getting data from there?
Regards.Alifur
Hi,couldn't upload proper edited video file. Please watch in full screanWhen excel nodes reads or writes: Wnen working with macros, empty excel spreadsheets are creted, without proper data usage (in my case 126)
Please raise an service request so that we can have a meeting with you and dive deeper in the issue.
Regards,Alifur