UiPath | How to change the value of cells and columns in Excel | Guide

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 39

  • @andreirotaru.c
    @andreirotaru.c 2 ปีที่แล้ว +1

    A very good video, Anders If you can please to update your videos to the new version of UiPath Studio because is pretty different from the version you have here. Thank you for your work

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว +1

      Hey Andrei. Thanks a lot. I will update it this week :) Kind regards, Anders

  • @jaydelacruz3982
    @jaydelacruz3982 ปีที่แล้ว +1

    Thank you for this content!
    I got a question: How do I change/update a formula from all cells in a sheet? I used the Find/Replace but is not allowing to change the text from Excel formula and in Excel comments.
    Thank you in advance Jens and more power!

    • @andersjensenorg
      @andersjensenorg  ปีที่แล้ว

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): th-cam.com/video/xWFz-S96XGo/w-d-xo.html Kind regards, Anders

  • @fernandoagalvao
    @fernandoagalvao 2 ปีที่แล้ว +1

    very good! saved me again! Thank you very much for the explanation, best regards.

    • @andersjensenorg
      @andersjensenorg  2 ปีที่แล้ว

      You're very welcome, Fernando Galvao - your support helps me a lot 😍

  • @Amulyajp
    @Amulyajp 3 ปีที่แล้ว

    Hi , how can I enter the data of some output into excel without overwrite.
    Data should write in A1 A2 accordingly

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว +1

      Hey HengeNaavu TV
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
      Have a great day.
      Kind regards,
      Anders

    • @Amulyajp
      @Amulyajp 3 ปีที่แล้ว

      @@andersjensenorg thank you sir

  • @ponnanikhil9611
    @ponnanikhil9611 4 ปีที่แล้ว +2

    I wish.. you do videos on real time scenario.

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว

      Hey Ponna. That is not a bad idea. Why do you think it is better? Just curious ☺ Kind regards, Anders

    • @ponnanikhil9611
      @ponnanikhil9611 4 ปีที่แล้ว

      @@andersjensenorg your doing well. It would be helpful us to know realtime environments of uipath

  • @АнастасияКузьмина-р6о
    @АнастасияКузьмина-р6о 3 ปีที่แล้ว +1

    Thank you! I like your videos!

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว +1

      Hey Анастасия. Thanks for the outstanding support you're showing me. Kind regards, Anders

  • @cheeku0
    @cheeku0 4 ปีที่แล้ว +1

    Thank you very much for all the valuable videos. I am looking for excel operation where I need to remove a part of text in columns and replace. Ex: if a column has text "LOAD ABCD", I want to remove the word LOAD and keep ABCD. This for all the cells in the column. Is it possible?
    Thank you very much.

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว

      Hey Raja. You can do "LOAD ABCD".Replace("LOAD ",""). Check the Replace method here: th-cam.com/video/1Rs6WfSk7p8/w-d-xo.html Kind regards, Anders

    • @cheeku0
      @cheeku0 4 ปีที่แล้ว

      Thank you very much Anders

  • @vrundashah3599
    @vrundashah3599 4 ปีที่แล้ว

    Can you please suggest good articles related to string functions and files/folders?

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว

      Hey Vrunda. I made a UiPath book guide once and the best book to understand the coding language (VB.NET) in UiPath is definately this, amzn.to/3d2x3NE To strings in UiPath, I have made this th-cam.com/play/PLXXz88_TPiHrsQDDFImamh94ULuGF9G3b.html and I made 4-5 videos about files/folders. So now I managed to answer your questions without giving you an answer (providing you with articles) 😏 I hope it helps anyway. Kind regards, Anders

  • @kstevenson3504
    @kstevenson3504 4 ปีที่แล้ว

    Any suggestions on how to change values of cells on grids in Windows Forms? I don't see anything online. Everything is about Excel. If i have a two columns, how do i copy one value from one cell column to the adjacent column next to it? The rows will vary. Some will have 1 row other 20+. I had hoped i could use arrow keys but it said there was a scope issue.
    Thanks

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว

      Hey K Stevenson. I never used Windows Forms, but I assume it's .NET based. Can you use UI activitives? Then I would just: Get Text, Output it to a string in properties, then use a Type Into and type the string, where you want it. Let me know, if thats possible? If yes, we can easily make a loop :) Have a great day. Kind regards, Anders

    • @kstevenson3504
      @kstevenson3504 4 ปีที่แล้ว

      @@andersjensenorg I so appreciate your giving me feedback. So with GetText you have to Indicate on screen. If i don't, Get Text gives me an error when i run it. How do get the text when i move to the next cell below the current number? There could be N number of rows. What i was trying to do was tie it to the row count and use arrow keys. But if i copy and paste, i don't know how to get the copy into a variable. Thanks so much.

    • @kstevenson3504
      @kstevenson3504 4 ปีที่แล้ว

      I subscribed to your channel thanks! Ok, i got GET FROM CLIPBOARD ACTIVITY!!!

  • @jessedelaney1969
    @jessedelaney1969 4 ปีที่แล้ว

    Is there any easy way using the DataTable.Rows assign that you used, to instead of just filling one row with DataTable.Row(0), to fill all all of the rows in that column with the same string?

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว +1

      Hey Jesse. You can make a 'For Each Row' of your DataTable and simply just use an assign, where row.item("NameOfYourColumn") = "SameString". Does that make sense? Kind regards, Anders

    • @jessedelaney1969
      @jessedelaney1969 4 ปีที่แล้ว +1

      @@andersjensenorg Thanks that's great. Question, if I have a column that is dates but showing up as numbers, is there an easy way to change the whole column to the date format?

    • @andersjensenorg
      @andersjensenorg  4 ปีที่แล้ว

      Sure. In Excel or a Data Table in the memory of a UiPath process?

    • @jessedelaney1969
      @jessedelaney1969 4 ปีที่แล้ว

      @@andersjensenorg Data Table in the memory of a UIPath process please!

  • @karendn20
    @karendn20 4 ปีที่แล้ว

    Thanks for your videos! ❤️ Question: How can I detect cells that exceed the length limit (example 6 characters) and remove those rows? 🤔

    • @goldenmonkey9085
      @goldenmonkey9085 3 ปีที่แล้ว +2

      Ex: ext.Length > 10

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว +1

      Hey Tana Storm
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
      Have a great day.
      Kind regards,
      Anders

  • @muhammadzuhairi7765
    @muhammadzuhairi7765 3 ปีที่แล้ว

    Nice video sir, I want ask something, how do I delete the value from specific cells and columns in excel? thanks in advance.

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว

      Hey Muhammad Zuhairi
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: th-cam.com/video/C6xmGfEL07I/w-d-xo.html
      Have a great day.
      Kind regards,
      Anders

  • @sirfbikeparghumo2204
    @sirfbikeparghumo2204 3 ปีที่แล้ว

    How can I find a specific value in row and them delete the cell to shift the cell up?
    Eg- I want to find text Zone in the row , once found I want to delete the cell and shift the remaining cells up.

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว

      Hey Prateek. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: th-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @akshayt1745
    @akshayt1745 4 ปีที่แล้ว

    Thanks sir

    • @andersjensenorg
      @andersjensenorg  3 ปีที่แล้ว +1

      You're very welcome, AKSHAY T - your support helps me a lot 😍