# \#write-range **URL:** https://forum.uipath.com/tag/write-range/2765.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [Write range: No cells were found](https://forum.uipath.com/t/write-range-no-cells-were-found/785187)
**Author:** [@Short](https://forum.uipath.com/u/Short)\ **Replies:** 1\ **Last updated:** [December 11, 2024, 5:26pm UTC](https://forum.uipath.com/t/write-range-no-cells-were-found/785187 "2024-12-11T17:26:16Z")
Hi all I’ve had a process which has ran perfectly on the schedule every 15 minutes for about a year And all of a sudden, 6 days ago it started coming up with this error: Basically it copies a range from 1 spreads… --- ## [Unattended Automation -\> Write Range Workbook NOT WORKING](https://forum.uipath.com/t/unattended-automation-write-range-workbook-not-working/715558)
**Author:** [@bhaskar](https://forum.uipath.com/u/bhaskar)\ **Replies:** 5\ **Last updated:** [January 29, 2024, 7:02am UTC](https://forum.uipath.com/t/unattended-automation-write-range-workbook-not-working/715558 "2024-01-29T07:02:19Z")
just to give you a brief overview of the process. the process opens a website to scrape data and outputs the data in the messagebox and with the help of Write Range Activity, im creating new excel file to store the scrap… --- ## [Subtract 2 row values and add the result to 3rd row](https://forum.uipath.com/t/subtract-2-row-values-and-add-the-result-to-3rd-row/707429)
**Author:** [@RenukaRPA](https://forum.uipath.com/u/RenukaRPA)\ **Replies:** 3\ **Last updated:** [December 19, 2023, 12:02pm UTC](https://forum.uipath.com/t/subtract-2-row-values-and-add-the-result-to-3rd-row/707429 "2023-12-19T12:02:34Z")
I have 2 rows . Ignore the dates. I have to subtract the row(0)-row(2) and add the result to the 3rd row. read the 3rd row range and paste it to different excel. Please help --- ## [Office365.Activities.Excel.WriteRange - numbers are changed, no PreserveFormat option](https://forum.uipath.com/t/office365-activities-excel-writerange-numbers-are-changed-no-preserveformat-option/661957)
**Author:** [@dbukk](https://forum.uipath.com/u/dbukk)\ **Replies:** 5\ **Last updated:** [October 26, 2023, 12:45pm UTC](https://forum.uipath.com/t/office365-activities-excel-writerange-numbers-are-changed-no-preserveformat-option/661957 "2023-10-26T12:45:04Z")
Hello team, I am trying to copy data from an Excel workbook into the Excel workbook on Sharepoint using the MicrosoftOffice365.Activities.Excel.WriteRange. For some reason the formatting changes and data is inserted in… --- ## [Excel範囲に書き込みでハイパーリンクが広範囲に入力されてしまう](https://forum.uipath.com/t/excel/574581)
**Author:** [@funicho](https://forum.uipath.com/u/funicho)\ **Replies:** 3\ **Last updated:** [August 22, 2023, 7:50am UTC](https://forum.uipath.com/t/excel/574581 "2023-08-22T07:50:41Z")
Excelの範囲に書き込みアクティビティについて、お教えください。 ハイパーリンク(数式=HYPERLINK(“https://XXX”, “https://XXX”))を含むデータテーブルを作成し、「範囲に書き込み」アクティビティを用いて入力を行っております。ハイパーリンクの部分が、指定した範囲以外の行全てに、自動的に入力されてしまいます。(画像の入力結果をご参照ください。)ハイパーリンクではない値については、指定した行だけに入力さ… --- ## [Unable to copy proper data in excel](https://forum.uipath.com/t/unable-to-copy-proper-data-in-excel/563273)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 17\ **Last updated:** [July 14, 2023, 8:45am UTC](https://forum.uipath.com/t/unable-to-copy-proper-data-in-excel/563273 "2023-07-14T08:45:01Z")
Hello, I am tryong to copy data from same sheet from A7 to G2. when automation pasting data it is writing some data in date formate and i am not understanding from where this date is coming. check below ss. help… --- ## [Where to use DateTable in Process Transaction?](https://forum.uipath.com/t/where-to-use-datetable-in-process-transaction/540933)
**Author:** [@Muralikrishna\_Surve](https://forum.uipath.com/u/Muralikrishna_Surve)\ **Replies:** 5\ **Last updated:** [May 2, 2023, 11:55am UTC](https://forum.uipath.com/t/where-to-use-datetable-in-process-transaction/540933 "2023-05-02T11:55:36Z")
Hi There, I have doubt like, Can we keep ‘Build DataTable’ in Process Transaction RE. If we keep, t will not clear DataTable for each itereration, right ? And Where can we keep ‘Write Range’ in Process Transaction RE. … --- ## [Whenever i use write datatable, the written data leaves few rows and updates the excel sheet](https://forum.uipath.com/t/whenever-i-use-write-datatable-the-written-data-leaves-few-rows-and-updates-the-excel-sheet/525558)
**Author:** [@Bhushan\_Nagaonkar](https://forum.uipath.com/u/Bhushan_Nagaonkar)\ **Replies:** 5\ **Last updated:** [March 13, 2023, 1:03pm UTC](https://forum.uipath.com/t/whenever-i-use-write-datatable-the-written-data-leaves-few-rows-and-updates-the-excel-sheet/525558 "2023-03-13T13:03:46Z")
As you can the data has left few rows and updated the sheet. Why is this happening. I also tried clear content. --- ## [Where to write output DataTable in ReFramework?](https://forum.uipath.com/t/where-to-write-output-datatable-in-reframework/514921)
**Author:** [@Muralikrishna\_Surve](https://forum.uipath.com/u/Muralikrishna_Surve)\ **Replies:** 1\ **Last updated:** [February 8, 2023, 10:31am UTC](https://forum.uipath.com/t/where-to-write-output-datatable-in-reframework/514921 "2023-02-08T10:31:14Z")
Hi There, I have used ‘Build DataTable’ in ‘Initialization’ state of ReFramework to store all exception details. In which state should i use to ‘Write range’ activity to write this datatable ? So that it will write wh… --- ## [How to keep formulas in excel intact while writing into excel](https://forum.uipath.com/t/how-to-keep-formulas-in-excel-intact-while-writing-into-excel/491687)
**Author:** [@Athawale\_Rushikesh](https://forum.uipath.com/u/Athawale_Rushikesh)\ **Replies:** 2\ **Last updated:** [January 3, 2023, 7:20am UTC](https://forum.uipath.com/t/how-to-keep-formulas-in-excel-intact-while-writing-into-excel/491687 "2023-01-03T07:20:16Z")
Hi All, I want to keep excel formulas intact even while writing the excel range. I have an excel file where few cell contains formula, hence when bot write the range, it gets over written with empty cells and formulas … --- ## [How can i get first cell from range?](https://forum.uipath.com/t/how-can-i-get-first-cell-from-range/489035)
**Author:** [@heyium](https://forum.uipath.com/u/heyium)\ **Replies:** 4\ **Last updated:** [November 11, 2022, 5:59am UTC](https://forum.uipath.com/t/how-can-i-get-first-cell-from-range/489035 "2022-11-11T05:59:14Z")
Hi! I have a multi-table excel. First I find the table range to use with the “Get Table Range” activity. Then I want to write text in the first row of the 4th column with “Write Range”, but the cell I will start typing … --- ## [Append Range - Google Sheets](https://forum.uipath.com/t/append-range-google-sheets/478786)
**Author:** [@sam.willson](https://forum.uipath.com/u/sam.willson)\ **Replies:** 2\ **Last updated:** [October 13, 2022, 10:16am UTC](https://forum.uipath.com/t/append-range-google-sheets/478786 "2022-10-13T10:16:24Z")
Hi all, I’m having some issues appending a range in Google Sheets. I have an existing set of data in a Google Sheet, and I’m trying to read a range from a different Google Sheet (with the same table layout structure) an… --- ## [Write cell in Excel and merge 2 cells to write a single text](https://forum.uipath.com/t/write-cell-in-excel-and-merge-2-cells-to-write-a-single-text/474762)
**Author:** [@Ray\_Sha1](https://forum.uipath.com/u/Ray_Sha1)\ **Replies:** 7\ **Last updated:** [September 22, 2022, 5:45am UTC](https://forum.uipath.com/t/write-cell-in-excel-and-merge-2-cells-to-write-a-single-text/474762 "2022-09-22T05:45:50Z")
Hi all, I’m using Write cell activity in UiPath where i want to merge 2 cells and write in it. Eg. I want to write “Hi” in cells A1 and A2. I want to also bold it and add colour to the cell. Is it possible? Thanks … --- ## [Write Range(Workbook) with Large Volume](https://forum.uipath.com/t/write-range-workbook-with-large-volume/404680)
**Author:** [@Konda\_Sai\_Charan\_Goud](https://forum.uipath.com/u/Konda_Sai_Charan_Goud)\ **Replies:** 4\ **Last updated:** [March 6, 2022, 2:00pm UTC](https://forum.uipath.com/t/write-range-workbook-with-large-volume/404680 "2022-03-06T14:00:25Z")
My Data table contains 104356 rows and 101 columns. I am trying to write that data table into the Excel sheet using Workbook activity, but facing an error “Job stopped with an unexpected exit code 0xE0434352”. I have tr…