Hi, I am new to UIPath. I have to insert data into an ODS file. I’ve done the process of extracting the data, but I’m unsure how to go about inserting it. This is because I have to insert it horizontally because it depends on the date (in the first column).
Furthermore, I have to skip a column so it will not overwrite the data there. The greyed out details are the name of the hotels I’m doing this for. How can I insert values in two cells horizontally and skip a column? Below is a visualisation of what I want (and a screenshot of the actual ODS file).
1st, how would I make the array? (I’m not used to UIPath)
2nd, would the method you suggest continue to work in a loop? Because for every two values I have to get, it is from one different file every time. thus the data inserted is per file basis.
for each link
-> log in and access system
-> download file
-> extract data
-> insert into ods (two cells each time, going horizontal)
Each red bar is a location’s name. and below the names, each have two columns, Room and Revenue. I have to download and extract a different file to fill in those two cells every time, and since it goes by date it has to be inserted horizontally. I also cannot overwrite the Date column in the middle.
Since all the values isn’t in one place for me to insert it at once, I wonder if there’s a way to make it go right two cells each time.
Example values are:
something like this
create a columnNumber variable (integer) , initialize with 1
then when writing to cell , set cell to UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(columnNumber)+"1"
e.g. if columnNumber=3 , it will write to C1, if colmnNumber = 4, it will write to D1