What if a console application that runs daily to retrieve data from a RESTful API endpoint, gets an HttpStatusCode=422 (because the endpoint data is not available) ? 2 hours later, the endpoint data becomes available, then, how can UiPath check for the 422 error, then resubmit the task under Windows Task Scheduler, so it can detect HttpStatusCode=200OK, then have Windows Task Scheduler restart the task to retrieve the endpoint data ?
Hi @ooikaisheng3500, the workflow will merge the shared column from all sheets into a single one. For instance, all Excel sheets demonstrated in the video feature a shared column titled "Name," and the resulting output file consolidates data from all "Name" columns into one.
Hi@@autopilotatwork , thanks for the reply. How about I don't want the name to be duplicated. Example, 'rock' has B in column E, I want 'rock's data in the same row of rock at row 5. Is that possible to be done in UiPath?
Hi @@ooikaisheng3500, in this case, instead of merging the data tables, you might wanna use another activity called Join Data Tables. This activity will allow you to join the data tables using the common column. You can also specify the join type you want. Hope this helps :)
Hey Michelle, how do i take certain values from an Excel file and have them written in a specific cell in another Excel file using Uipath? Lets say we want to take values under a column from the first Excel and write the sum of the numbers in that column in the second Excel at a desired location under a specific column.
Hi Efe, you can assign that certain value e.g. the sum of numbers in a variable and then use write cell activity to write the value in the specified excel cell or range. I'll have a similar use case for the next video. Stay tune :)
Thanks for good information video, May i know ur fb name? I have a few of questions to ask in order to create multiple workbooks based on my data tables. Thanks in advance😊
In Read range activity, make sure UseFilter property is unchecked. It's unchecked by default, so the filter wont be applied. If you want to use Ctrl+Shft+L, you can try HotKey or invoking VBA
Hello, I need to download multiple excel sheets and then paste that data into another excel sheet , and do the same process again with different downloaded files and different file to paste the data . How to I do this iterative process ?
Hi Diya, it sounds like you want to combine multiple sheets into one. Perhaps this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Gmu2IGZ50WY.html can help?
hello i have task so pls do it on video in ths topic Task: Extract DPs into separate excel sheets with respect to Region specified. Please extract all the DPs into separate excel files, where data has been captured (excluding DP codes with decimal values, i.e. only parent DPs required, have attached the DP list ) And in each file data needs to be separated as per Region (List of regions provided in Dp list sheet) For reference have attached an sample output file, please follow the same format(File Name - 746_Data.xlsx) Please find the attached source files on which the extraction needs to be done(Retagged)
Hi there, hopefully this video is able to help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ISaE6LdUyRU.html Please look at the description regarding file name. Let me know if you still need help.
Hi Michell, thank you for this very helpful and easy to follow video. I got a validate error on "Filenames" - value of type '1-dimensional array of String' cannot be converted to 'String'. I replayed your video 10 times and still could not find where I did wrong.
thanks for the great video, but when I tried with my files, the original format is not kept and only plan text/sheet are written at desination file. Do you know why? Thank you in advance!
Hi Ceekay, you need a different activity e.g. copy/paste range instead of write range if you want to keep formula or cell format. I'd recommend you to check out another video on the uipath automation playlist that explains how to use these activities to copy formula from one sheet to another. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Lf522pQS2-Y.html
thank you for this helpful video. Your solution is correct, but iam just wondering why we need condition "if" here, i tried without if-condition, it prints just the last sheet. Can you explan me more detail why if-condition is used there? Thank you.
Hi Thi, the if condition is just to initialise the data table dtMain only if it is empty. We only need to initialise the data table once. In this example we initialise by cloning the data structure of first sheet.
Hi Kaleque, I do have a few videos on how to read multiple worksheets. Check out my videos here ru-vid.com/show-UCVxk_HxfeHPY4ItIX2h4KxQvideos. You might find this video helpful ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Gmu2IGZ50WY.html
Can you help me? How can I copy a formula from one Excel sheet to another? I want to copy data from a range "A1-C45" and behind those data there is a formula. I tried with read/write but that just copied the values and not the formulas. Thank you very much.
Hi Matija, I have made a video to answer your question. Hopefully this is still helpful ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Lf522pQS2-Y.html
Hi, Have you made a video of taking data from multiple excel workbooks and consolidate it into one workbook? I have to prepare monthly report, and the data are available from multiple workbooks.
Hi..Thank you so much for the video. Really helpful. Just wanted to ask if is it possible to modify this process to rename the sheet name with cell value within that sheet imported. But want the rest of the process to work as it is. Thanks. Really appreciate.
Hi Subhasish, I'm glad that you found this video useful. Yes it's possible if you know which cell value you want to use to rename the sheet. You can assign sheetname = dt.Rows(rowindex)(columnindex).ToString
This is such a great example. You could have explained how you fine tuning the selectors, that should be fun to learn for a lot of people. Thank you for uploading this video.