# \#data **URL:** https://forum.uipath.com/tag/data/1743.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [How to show excel data in uipath apps](https://forum.uipath.com/t/how-to-show-excel-data-in-uipath-apps/5737120)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [April 10, 2026, 12:05pm UTC](https://forum.uipath.com/t/how-to-show-excel-data-in-uipath-apps/5737120 "2026-04-10T12:05:40Z")
Hello, i am building app like below- my requirement is to show excel data which i have in my local folder here in table in apps. how can i achieve this? is i need to do any upath process? help me on same. --- ## [Group list of strings by continuous alphabetical sequence](https://forum.uipath.com/t/group-list-of-strings-by-continuous-alphabetical-sequence/5707763)
**Author:** [@michael.j.gallamo](https://forum.uipath.com/u/michael.j.gallamo)\ **Replies:** 8\ **Last updated:** [January 13, 2026, 4:00am UTC](https://forum.uipath.com/t/group-list-of-strings-by-continuous-alphabetical-sequence/5707763 "2026-01-13T04:00:29Z")
I have a data table with a column that are string values, they are tag numbers. The values are alphanumeric e.g. BL6394B. I am trying to retrieve the first and last value of each continuous alphabetical sequence. Basica… --- ## [Add 8 string variables, 2 data tables to a single queue item](https://forum.uipath.com/t/add-8-string-variables-2-data-tables-to-a-single-queue-item/5689088)
**Author:** [@mohit\_RPA](https://forum.uipath.com/u/mohit_RPA)\ **Replies:** 8\ **Last updated:** [November 27, 2025, 4:46am UTC](https://forum.uipath.com/t/add-8-string-variables-2-data-tables-to-a-single-queue-item/5689088 "2025-11-27T04:46:16Z")
I wanted to add 8 string variables, 2 data table variables in a single queue item. Community please help/suggest. --- ## [Redundant nugget packages install and occupying memory](https://forum.uipath.com/t/redundant-nugget-packages-install-and-occupying-memory/5680245)
**Author:** [@Giraldo\_Juan\_P](https://forum.uipath.com/u/Giraldo_Juan_P)\ **Replies:** 1\ **Last updated:** [November 12, 2025, 9:09pm UTC](https://forum.uipath.com/t/redundant-nugget-packages-install-and-occupying-memory/5680245 "2025-11-12T21:09:54Z")
Hi all, We have an issue where our processes are downloading a large number of files into a .nuget folder under non-person accounts on our server. We have already configured UiPath to store NuGet packages in a separate … --- ## [Need Solution or Sequence for below xml](https://forum.uipath.com/t/need-solution-or-sequence-for-below-xml/772945)
**Author:** [@Vicky\_Kaliyamurthy](https://forum.uipath.com/u/Vicky_Kaliyamurthy)\ **Replies:** 2\ **Last updated:** [October 11, 2024, 1:19pm UTC](https://forum.uipath.com/t/need-solution-or-sequence-for-below-xml/772945 "2024-10-11T13:19:37Z")
Hi All, I have xml file from there i need to extract WID and First name and last name using Deserialize XML activity can you please help me to clear out in namespaces i will put test xml file please give solution or giv… --- ## [Can't view Data Manager](https://forum.uipath.com/t/cant-view-data-manager/763150)
**Author:** [@Nicolas\_Auadre](https://forum.uipath.com/u/Nicolas_Auadre)\ **Replies:** 6\ **Last updated:** [August 29, 2024, 11:58pm UTC](https://forum.uipath.com/t/cant-view-data-manager/763150 "2024-08-29T23:58:02Z")
Hi, Today I updated Studio to version 2024.10.4 and since then I couldn’t view my Data manager it straight up just shows a blank page: Does anyone else have the same issue? If so could you solve it? --- ## [Extract contents of a Table from Io\_ExtractionResult Variable](https://forum.uipath.com/t/extract-contents-of-a-table-from-io-extractionresult-variable/749412)
**Author:** [@Dhruvi\_Arumugam](https://forum.uipath.com/u/Dhruvi_Arumugam)\ **Replies:** 10\ **Last updated:** [June 25, 2024, 10:43am UTC](https://forum.uipath.com/t/extract-contents-of-a-table-from-io-extractionresult-variable/749412 "2024-06-25T10:43:16Z")
Hi All, Need urgent help!! I have a variable Io\_ExtractionResult which contains result gathered from Data extraction scope activity of UiPath, The data extracted is from an invoice. I want to extract the result of a t… --- ## [VLookup between two different Excel where column could contain null values](https://forum.uipath.com/t/vlookup-between-two-different-excel-where-column-could-contain-null-values/728136)
**Author:** [@rishiathawale](https://forum.uipath.com/u/rishiathawale)\ **Replies:** 4\ **Last updated:** [March 20, 2024, 8:51am UTC](https://forum.uipath.com/t/vlookup-between-two-different-excel-where-column-could-contain-null-values/728136 "2024-03-20T08:51:13Z")
Hi All, I am trying to apply VLookup between 2 different excel where column could have null values in it. Below is the sample data Input - DT1 Input - DT2 Output Below is the query I have written but it is… --- ## [Combining excels](https://forum.uipath.com/t/combining-excels/722449)
**Author:** [@khaled\_emad](https://forum.uipath.com/u/khaled_emad)\ **Replies:** 3\ **Last updated:** [February 26, 2024, 11:08am UTC](https://forum.uipath.com/t/combining-excels/722449 "2024-02-26T11:08:28Z")
I have an excel sheet with 8 columns (1-8). I need to take the data of column (1-3-4) and append them to another excel sheet with new columns header How can I add take these columns value from my data table and append … --- ## [String manipulation - Sort String to DT](https://forum.uipath.com/t/string-manipulation-sort-string-to-dt/712077)
**Author:** [@rishiathawale](https://forum.uipath.com/u/rishiathawale)\ **Replies:** 2\ **Last updated:** [January 12, 2024, 12:01pm UTC](https://forum.uipath.com/t/string-manipulation-sort-string-to-dt/712077 "2024-01-12T12:01:15Z")
Hi All, I have several strings coming from PDF, I want to sort such strings and put it into DT Input str = Royal Denson Short Term Mkt Y Acc 2.00 0.10 USD Money Market - Short Term Output Note- string text could… --- ## [Robotic Process automation to ensure data security and Access control of a system](https://forum.uipath.com/t/robotic-process-automation-to-ensure-data-security-and-access-control-of-a-system/703864)
**Author:** [@Deep\_HML](https://forum.uipath.com/u/Deep_HML)\ **Replies:** 2\ **Last updated:** [December 4, 2023, 6:32am UTC](https://forum.uipath.com/t/robotic-process-automation-to-ensure-data-security-and-access-control-of-a-system/703864 "2023-12-04T06:32:09Z")
Hello Guys , Hope you’re doing well. I have some questions about RPA practices in data security and access control , any ideas about how to ensure data security and access control in a system it may be for example web … --- ## [Need LINQ to update column data for specific scenario](https://forum.uipath.com/t/need-linq-to-update-column-data-for-specific-scenario/602698)
**Author:** [@rishiathawale](https://forum.uipath.com/u/rishiathawale)\ **Replies:** 1\ **Last updated:** [September 23, 2023, 9:32am UTC](https://forum.uipath.com/t/need-linq-to-update-column-data-for-specific-scenario/602698 "2023-09-23T09:32:18Z")
Hi All, Below is the data where I want to update RS column data. Condition Where Column “IT” is Y and column “RS” is N and N/A - replace “RS” column N and N/A with Y @ppr @Yoichi Thanks --- ## [How to get exact data like specific column in excel](https://forum.uipath.com/t/how-to-get-exact-data-like-specific-column-in-excel/597660)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [September 20, 2023, 2:38pm UTC](https://forum.uipath.com/t/how-to-get-exact-data-like-specific-column-in-excel/597660 "2023-09-20T14:38:42Z")
Hello, my expected data getting B &c column data using 1 api , d column data using 2 nd api and F&G column data using 3 rd api. requirement is i need to generate H column and data should look similar to D column. … --- ## [UiPath Tutorial: Filter Data in Dropdown Lists - UiPath Apps Tutorial Part 02](https://forum.uipath.com/t/uipath-tutorial-filter-data-in-dropdown-lists-uipath-apps-tutorial-part-02/591785)
**Author:** [@AndyMenon](https://forum.uipath.com/u/AndyMenon)\ **Replies:** 0\ **Last updated:** [September 17, 2023, 8:10am UTC](https://forum.uipath.com/t/uipath-tutorial-filter-data-in-dropdown-lists-uipath-apps-tutorial-part-02/591785 "2023-09-17T08:10:10Z")
Hello Community, In the Part 01 installment of this video, we covered a basic example on how to filter data in multi-selected drop down controls. However, this was just one of the many options covered, and it left seve… --- ## [Encrypt dictioanary value and store in a key in loop](https://forum.uipath.com/t/encrypt-dictioanary-value-and-store-in-a-key-in-loop/576779)
**Author:** [@anokhiraaz](https://forum.uipath.com/u/anokhiraaz)\ **Replies:** 2\ **Last updated:** [August 30, 2023, 6:53am UTC](https://forum.uipath.com/t/encrypt-dictioanary-value-and-store-in-a-key-in-loop/576779 "2023-08-30T06:53:58Z")
Hi Guyz, So i was working with dictionary, and i have to update the dictianary value in a loop. I have to encrypt the values and store in a same key in a loop. Can anyone help me into this. Thanks in advance. --- ## [How to Filter Data in Dropdown Lists - UiPath Apps Tutorial Part 01](https://forum.uipath.com/t/how-to-filter-data-in-dropdown-lists-uipath-apps-tutorial-part-01/567725)
**Author:** [@AndyMenon](https://forum.uipath.com/u/AndyMenon)\ **Replies:** 0\ **Last updated:** [July 28, 2023, 5:05am UTC](https://forum.uipath.com/t/how-to-filter-data-in-dropdown-lists-uipath-apps-tutorial-part-01/567725 "2023-07-28T05:05:16Z")
Hello Community, If you want to know how to build UiPath Apps that lets users filter data in multi-select dropdown lists, then you may find this video interesting. In this session we use a series of multi-select dropd… --- ## [How to get the following output using Assign Activity and String manipulation](https://forum.uipath.com/t/how-to-get-the-following-output-using-assign-activity-and-string-manipulation/537237)
**Author:** [@Ruchi](https://forum.uipath.com/u/Ruchi)\ **Replies:** 9\ **Last updated:** [April 20, 2023, 2:23pm UTC](https://forum.uipath.com/t/how-to-get-the-following-output-using-assign-activity-and-string-manipulation/537237 "2023-04-20T14:23:39Z")
How to fetch the floowing output string using string manipulation? Kindly help Input =\> 1025-MISD : Uenrkte KIFEDREWES CORP (333-22-1234) Expected output string =\> 333-22-1234 --- ## [How to split json like \[ \]](https://forum.uipath.com/t/how-to-split-json-like/532399)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 7\ **Last updated:** [April 4, 2023, 3:15pm UTC](https://forum.uipath.com/t/how-to-split-json-like/532399 "2023-04-04T15:15:49Z")
Hello, hi have huge json like below “completedCycles”: , “ongoingCycle”: { “startTime”: { “iso8601”: “2023-04-04T10:28:39+02:00”, “jira”: “2023-04-04T10:28:39.376+02:00”, “friendly”: “16 minutes ago”, “epochMilli… --- ## [Sort Datatable and Create new Datatable based on Sorting results](https://forum.uipath.com/t/sort-datatable-and-create-new-datatable-based-on-sorting-results/520294)
**Author:** [@Harshad\_Jadhav](https://forum.uipath.com/u/Harshad_Jadhav)\ **Replies:** 3\ **Last updated:** [March 14, 2023, 12:24pm UTC](https://forum.uipath.com/t/sort-datatable-and-create-new-datatable-based-on-sorting-results/520294 "2023-03-14T12:24:49Z")
Hi All, I am looking for help here in one of the requirement where i have to Sort the data table first and then create new data table based on sorting results. For e.g Emp ID Emp Name Department 1 abc … --- ## [Unable to select perfect string](https://forum.uipath.com/t/unable-to-select-perfect-string/512220)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [January 31, 2023, 7:20am UTC](https://forum.uipath.com/t/unable-to-select-perfect-string/512220 "2023-01-31T07:20:54Z")
Hello, I have data in varaiable as string and i need to compair it from excel and need to get the index of row. if varaible contains string data like “sandhyar” , i need to check in which row exact data is there after… --- ## [Issue when invoking python script](https://forum.uipath.com/t/issue-when-invoking-python-script/494755)
**Author:** [@b.forbes](https://forum.uipath.com/u/b.forbes)\ **Replies:** 1\ **Last updated:** [December 1, 2022, 4:00pm UTC](https://forum.uipath.com/t/issue-when-invoking-python-script/494755 "2022-12-01T16:00:52Z")
I am trying to run a python script on a series of documents to generate new reports. The script is working, but it is throwing this error in UiPath, causing the bot to fail - There are no arguments or variables call… --- ## [Use mysql to retrieve data from the Excel into a data table](https://forum.uipath.com/t/use-mysql-to-retrieve-data-from-the-excel-into-a-data-table/480254)
**Author:** [@bobevrosen](https://forum.uipath.com/u/bobevrosen)\ **Replies:** 0\ **Last updated:** [October 12, 2022, 5:58am UTC](https://forum.uipath.com/t/use-mysql-to-retrieve-data-from-the-excel-into-a-data-table/480254 "2022-10-12T05:58:55Z")
Hi, In order to connect dynamically to Excel from UiPath I suggest you use OLEDB. Then you will be able to use mysql to retrieve data from the Excel into a data table. Here is a YouTube video how you can do it: https:… --- ## [\[LINQ\]Use linq to join all rows that contain two equal column values with separators ;](https://forum.uipath.com/t/linq-use-linq-to-join-all-rows-that-contain-two-equal-column-values-with-separators/479105)
**Author:** [@Felipe\_Domingos](https://forum.uipath.com/u/Felipe_Domingos)\ **Replies:** 18\ **Last updated:** [October 18, 2022, 1:56am UTC](https://forum.uipath.com/t/linq-use-linq-to-join-all-rows-that-contain-two-equal-column-values-with-separators/479105 "2022-10-18T01:56:16Z")
Hi, coul someome help me to join all rows into a datatable where 2 colunmns values are equals? I have the follow datatable: And I want to join all columns with the same Code and Postpone, merging only the columns Re… --- ## [Check the type](https://forum.uipath.com/t/check-the-type/481800)
**Author:** [@agathiyanv](https://forum.uipath.com/u/agathiyanv)\ **Replies:** 7\ **Last updated:** [October 17, 2022, 1:19pm UTC](https://forum.uipath.com/t/check-the-type/481800 "2022-10-17T13:19:14Z")
I need to check that if the variable type is int, then i need to change the format to “{0:0.0}”, how we can do this via query or function. --- ## [Create Excel file if not exists](https://forum.uipath.com/t/create-excel-file-if-not-exists/451697)
**Author:** [@b.forbes](https://forum.uipath.com/u/b.forbes)\ **Replies:** 5\ **Last updated:** [June 28, 2022, 10:58am UTC](https://forum.uipath.com/t/create-excel-file-if-not-exists/451697 "2022-06-28T10:58:41Z")
I am trying to write a dt back to an excel file but want to create a file with todays date from template if one does not exist. I have selected “create if not exists” and indicated the template file but I keep getting t… --- ## [UiPath Apps-Data Service Integration - Part 05B | Bind Data Context to Form Elements](https://forum.uipath.com/t/uipath-apps-data-service-integration-part-05b-bind-data-context-to-form-elements/418463)
**Author:** [@AndyMenon](https://forum.uipath.com/u/AndyMenon)\ **Replies:** 0\ **Last updated:** [April 27, 2022, 7:52am UTC](https://forum.uipath.com/t/uipath-apps-data-service-integration-part-05b-bind-data-context-to-form-elements/418463 "2022-04-27T07:52:27Z")
Hello Community! It’s time to pick up where we left off in the Part 05A video and go under the surface to familiarize ourselves on working with Data Context. If you haven’t watched the Part 5A , please do from this UiP… --- ## [UiPath Apps-Data Service Integration - Part 04 | Update or Delete Data Service Entity Records](https://forum.uipath.com/t/uipath-apps-data-service-integration-part-04-update-or-delete-data-service-entity-records/383005)
**Author:** [@AndyMenon](https://forum.uipath.com/u/AndyMenon)\ **Replies:** 0\ **Last updated:** [December 21, 2021, 7:20am UTC](https://forum.uipath.com/t/uipath-apps-data-service-integration-part-04-update-or-delete-data-service-entity-records/383005 "2021-12-21T07:20:35Z")
Hello Community, This is the last video of the UiPath Apps to Data Service Integration Series! We continue with the Acme Survey App created in Part 03 and demonstrate how an existing Entity record could be updated or d… --- ## [Vlookup to perform lakhs of data](https://forum.uipath.com/t/vlookup-to-perform-lakhs-of-data/368292)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 21\ **Last updated:** [December 16, 2021, 7:48pm UTC](https://forum.uipath.com/t/vlookup-to-perform-lakhs-of-data/368292 "2021-12-16T19:48:00Z")
Hi everyone, I have two excels with more tan lakhs of data and i have to perform vlookups on first dt, and if common value found then replace their price with dt2 value. I tries this solution but this is not working. … --- ## [Dt.rows.count throws object reference not to set to instance](https://forum.uipath.com/t/dt-rows-count-throws-object-reference-not-to-set-to-instance/341335)
**Author:** [@ranjani](https://forum.uipath.com/u/ranjani)\ **Replies:** 2\ **Last updated:** [September 1, 2021, 4:49am UTC](https://forum.uipath.com/t/dt-rows-count-throws-object-reference-not-to-set-to-instance/341335 "2021-09-01T04:49:30Z")
Hi , I have a variable of type list and initiated as New list(of system.Data.Datatable) .i will add different dt to this list and loop through each one of them later.It was working fine.Recently i did remove some name… --- ## [String Manipulation - Help](https://forum.uipath.com/t/string-manipulation-help/328803)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 5\ **Last updated:** [July 11, 2021, 2:34pm UTC](https://forum.uipath.com/t/string-manipulation-help/328803 "2021-07-11T14:34:22Z")
Hi, Can anyone help me into this, I used Get text data and it is returning the String Value and i splitted that by using , Wholedata.Split(Environment.NewLine.ToArray)(4) but sometime there is no data present in this, So… [Next page](https://forum.uipath.com/tag/data/1743.md?match_all_tags=true&page=1&tags%5B%5D=data)