This video is pure gold; not near as complex as the multiple files I'm trying to handle but clear enough to work with as a base. Thanks a lot. I agree with the other comments: the documentation and examples are not enough. But, the potential is there. Keep it up!!!
Trying to do the IF formula in officescript and getting the error: Range setFormulasLocal: An internal error occurred while processing the request. Would anyone know if the script accepts IF?
Hi, Very helpful and informative. I have couple of doubts.. 1, is it possible to trigger flow from office script. 2, Can the flow be setup with dynamic file details ie use single flow to fetch data from multiple workbooks. Thanks
It is not possible to trigger flow from Office Scripts. It can be part of a flow. Currently, the files have to be present in the folder with a predefined name for this to work. There is an effort to look into reading files with the path (with file being dynamically added during the flow.. right now if an Excel file is created in the flow, it doesn't work). If the files are present you can read data from multiple files and feed into single script (just add new arguments to main function in the script).
@Sujimon Thankappan It's quite easy. You write Script-1 that reads from File1, Script-2 that reads from File2. In both cases you should return a value you need. You can return anything... but you'll receive it as string in the script that reads it. You can then write Script3 and inside of it have two more arguments called input1, input2. Just map the input1/2 from the output of Script-1 & 2 in PA. Finally, run it all in a sequence in PA. I can do a sample -- probably will take some time. If you have any issues, leave an issue at this repo - github.com/sumurthy/officescripts-projects
Hello Sudhi, I love office scripts and the Script Lab add-in so I use both in my workplace. Following your example I am reading and passing data from file: A -> writing to file: B, then I read and pass data from file:C and I want to write again to file: B. The first operation(A>B) is rather quick takes about 30seconds but the data in file C is more and it has to write more info to file B and it usually takes the same structured script about 55 seconds and very often the C>B fails with error Range getCell: Timeout. Could you post something to help me write large dataset?
has anyone had any luck cross referencing more than two spreadsheets? I get an error when trying to add a third Run Script step. perhaps there's a work around that doesnt involve creating a new flow?
This video is pure gold; not near as complex as the multiple files I'm trying to handle but clear enough to work with as a base. Thanks a lot. I agree with the other comments: the documentation and examples are not enough. But, the potential is there. Keep it up!!!
thanks for sharing more advanced Office Scripts! really helpful
Nice intro to this approach, was very useful.
Thanks, Sudhi.This is very helpful. Is there a way we can copy the error records in a separate excel sheet and share it over mail?
Thank you for the detailed explanations!
This runs for maybe 2 of my 24 workbooks, then seems to do nothing else, even though it says it is running. What is wrong?
Thank you Sudhi, by any chance if you're seeing this, may I know how to write EventData into new rows please?
Fantastic video.
hey
I am trying to automate but for some reason i can't find it in the Add-Ins store , can you tell me which Add-ins you have there ?
Trying to do the IF formula in officescript and getting the error:
Range setFormulasLocal: An internal error occurred while processing the request.
Would anyone know if the script accepts IF?
Hi, Very helpful and informative. I have couple of doubts.. 1, is it possible to trigger flow from office script. 2, Can the flow be setup with dynamic file details ie use single flow to fetch data from multiple workbooks.
Thanks
It is not possible to trigger flow from Office Scripts. It can be part of a flow.
Currently, the files have to be present in the folder with a predefined name for this to work. There is an effort to look into reading files with the path (with file being dynamically added during the flow.. right now if an Excel file is created in the flow, it doesn't work). If the files are present you can read data from multiple files and feed into single script (just add new arguments to main function in the script).
@@s65012r Thanks. Is it possible give a sample of a flow reading data from multiple excel files and feeding into a script.
@Sujimon Thankappan It's quite easy. You write Script-1 that reads from File1, Script-2 that reads from File2. In both cases you should return a value you need. You can return anything... but you'll receive it as string in the script that reads it. You can then write Script3 and inside of it have two more arguments called input1, input2. Just map the input1/2 from the output of Script-1 & 2 in PA.
Finally, run it all in a sequence in PA. I can do a sample -- probably will take some time. If you have any issues, leave an issue at this repo - github.com/sumurthy/officescripts-projects
Hello Sudhi, I love office scripts and the Script Lab add-in so I use both in my workplace. Following your example I am reading and passing data from file: A -> writing to file: B, then I read and pass data from file:C and I want to write again to file: B. The first operation(A>B) is rather quick takes about 30seconds but the data in file C is more and it has to write more info to file B and it usually takes the same structured script about 55 seconds and very often the C>B fails with error Range getCell: Timeout. Could you post something to help me write large dataset?
has anyone had any luck cross referencing more than two spreadsheets? I get an error when trying to add a third Run Script step. perhaps there's a work around that doesnt involve creating a new flow?
Thanks for help me.
Teach how to insert rows between unequal row values.
Wow!