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?
@lewishawkins5267
3 ай бұрын
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?
@udaydivekar6116
3 жыл бұрын
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?
@tenisviejos
3 жыл бұрын
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!!!
@Joem0le
2 жыл бұрын
Thank you Sudhi, by any chance if you're seeing this, may I know how to write EventData into new rows please?
@chrisouellet2832
Жыл бұрын
thanks for sharing more advanced Office Scripts! really helpful
@smbossco
2 жыл бұрын
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?
@Juliadanial2
2 жыл бұрын
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 ?
@kristiankrusev6637
3 жыл бұрын
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?
@andrewbox2691
9 ай бұрын
Nice intro to this approach, was very useful.
@อดิษกรพิมพ์กลาง-ม3ฒ
Жыл бұрын
Teach how to insert rows between unequal row values.
@lianmg03
3 жыл бұрын
Thank you for the detailed explanations!
@MarceloMotaRibeiro
3 жыл бұрын
Thanks for help me.
@chrisdang7378
Жыл бұрын
Fantastic video.
@sujimonthankappan6832
3 жыл бұрын
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
@s65012r
3 жыл бұрын
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).
@sujimonthankappan6832
3 жыл бұрын
@@s65012r Thanks. Is it possible give a sample of a flow reading data from multiple excel files and feeding into a script.
@s65012r
3 жыл бұрын
@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
Пікірлер: 22