Need help finding the next empty row to input daily info

Help Studio
, ,
1

Hi all, everyday I have to fill out a backlog report. I’m stuck at the point of trying to input my data into the next empty row of cells. I do not understand how to read the spreadsheet and get it to add data to the first open cell.

2

Just use Append Range to add your new rows.

3

Hi @Ann_Jones

Welcome to UiPath community!

Where is the input coming from to append to the existing spreadsheet?

4

Hi @Ann_Jones

Welcome to uipath community

  1. Need to check the spreadsheet is exist in the appr folder location

For that,

  1. Use If activity
System.IO.File.Exists(Environment.CurrentDirectory+"\Test.xlsx")

Instead of the Environment.CurrentDirectory+"\Test.xlsx" need to give the correct folder path

  1. Use Append range and Write range Activity

If the spreadsheet is not there it will create an spreadsheet and write the data.

If the spreadsheet is there it will append the data.

For Reference:

image
image811×406 10.6 KB

Regards
Gokul

5

Hi @ushu, The input is coming from email but I have pulled it from email and into a blank sheet in the report I am using.

I have 3 spreadsheets that I need to input these numbers in. (lets call them X,Y,Z)
In the data pulled from my email I have a number for each X, Y and Z that needs to go into each spreadsheet. They will always go into the same column but I need a new row daily.

6

Use Append Range. It automatically writes a datatable into the next blank row in the spreadsheet.