Auto Fill help needed

Help Studio
1

Hi, I would like to drag the same contents in cell A2 till cell A6. I can’t find auto fill range activity and i used auto fill with the syntax as follows. No compilation errors but it did not give any output onto the excel file.

image
image723×686 20.5 KB

2

dependencies i have is as follows

image

3

excel file is as follows

image

4

@jollie_ng,

Use Select Source as A2 only. This will auto fill till your column end. Try using like this.

Excel.Sheet("Sheet5").Range("A2")

Thanks,
Ashok :slightly_smiling_face:

5

Hi @jollie_ng

Search Fill Range activity

The image shows the "Activities" panel in UiPath Studio with a search for "Fill Range," displaying relevant activities for Excel and Google Sheets integrations. (Captioned by AI)
The image shows the "Activities" panel in UiPath Studio with a search for "Fill Range," displaying relevant activities for Excel and Google Sheets integrations. (Captioned by AI)488×870 16.5 KB

The image shows an automation workflow for Excel, where a value from cell A2 of the "Input" sheet in "Excel1.xlsx" is read and then copied into the range A3:A6 of the same sheet. (Captioned by AI)
The image shows an automation workflow for Excel, where a value from cell A2 of the "Input" sheet in "Excel1.xlsx" is read and then copied into the range A3:A6 of the same sheet. (Captioned by AI)541×704 21.8 KB

Regards,

6

thank you @lrtetala

any idea why is the format of column B’s output different?

image

7

my UiPath screen looks like this

image
image677×1655 123 KB

8

@jollie_ng

Can you try to change below formats

This image displays a user interface for an automation script that operates on an Excel file, where it reads a cell value from one location and fills it into a specified range. (Captioned by AI)
This image displays a user interface for an automation script that operates on an Excel file, where it reads a cell value from one location and fills it into a specified range. (Captioned by AI)488×606 39.4 KB

Or

For B Column only uncheck Get formatted text

The image shows a "Read Cell Value" operation in Excel, with the cell "Excel.Sheet("Sheet5").Cell("B2")" being read and the option to "Get formatted text" checked. (Captioned by AI)

Regards,

9

hi @lrtetala, unfortunately, i have alr selected same as project and get formatted text, but the error remains.

10

hi @ashokkarale and @lrtetala, btw, given the dependencies i showed in the screenshots earlier, am i short of something which caused me not to have the activity autofill range ?

11

@jollie_ng

I told you to try below 3 methods any one of it works

This image shows an Excel Process Scope setup within an automation project, including configurations for reading and writing cell values from an Excel file with specific read formatting options highlighted. (Captioned by AI)
This image shows an Excel Process Scope setup within an automation project, including configurations for reading and writing cell values from an Excel file with specific read formatting options highlighted. (Captioned by AI)618×760 62.6 KB

or

For B Column only uncheck Get formatted text

The image shows a "Read Cell Value" configuration in Excel, where cell "B2" from "Sheet5" is read and saved to "CellVal", with the "Get formatted text" option checked. (Captioned by AI)
The image shows a "Read Cell Value" configuration in Excel, where cell "B2" from "Sheet5" is read and saved to "CellVal", with the "Get formatted text" option checked. (Captioned by AI)851×319 35.4 KB

Auto fill Range is GSuite activities

The image shows a search result within a software tool for "Auto fill range," highlighting relevant functions under the "UiPath.Excel.Activities" and "UiPath.GSuite.Activities" packages, with "Auto Fill Range" and "Autofit Range" options. (Captioned by AI)
The image shows a search result within a software tool for "Auto fill range," highlighting relevant functions under the "UiPath.Excel.Activities" and "UiPath.GSuite.Activities" packages, with "Auto Fill Range" and "Autofit Range" options. (Captioned by AI)521×649 12.8 KB

I think you are looking for these activities Fill Range, AutoFit Range, Auto Fill activities

Regards,

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.