하루 지날 때 마다 행은 고정 열은 한칸씩 증가한 위치에 셀 입력을 하고 싶은데요,
방법 부탁드립니다. 아니면 열 헤드의 날짜와 금일 날짜가 일치하면 해당 셀의 위치에 값을 입력하도록 하는 방식도 좋을 것 같습니다.
데일리로 날짜에 맞게 셀 입력이 되었으면 좋겠습니다!
Hi @GEONYONG_AN
Your Query is confusing, could you share the Input data and required output data for our understanding.
Dear mkankatala,
I check the shipping quantity of the previous day and the remaining inventory on our system every day. (7/12 out quantity 1012 / Remaining stock 200)
so, I want to save them as variables and write them by date in the inventory management Excel file every day.
Please help me find the columns of cells that match today’s date and enter the cells. (like 7/12 enter Q3, 7/13 R3, 7/14 S3)
Please understand that I can’t attach the file due to the company’s security policy
Okay got it… @GEONYONG_AN
If your excel as below,
Then you have to write the Remaining Inventory variable value in Today’s date column, in the above image in 7/12 column in C2 cell.
If yes, then you can follow the below steps,
→ Store the Remaining Inventory in a String datatype variable called RemainingInventory.
- Assign -> RemainingInventory = "out quantity 2000 / Remaining stock 500"
→ Use the Excel Process scope activity inside of it insert the Use excel file activity.
→ Give the Excel Path to use excel file activity.
→ Inside Use excel file activity insert the Find/Replace activity to find the today’s date column. store the output in a variable called ColumnFoundAt.
→ After Find/Replace activity insert the assign activity and create a variable called CelltoWrite and give expression in assign activity as below,
- Assign -> CelltoWrite = System.Text.RegularExpressions.Regex.Match(ColumnFoundAt.ToString, "[A-Za-z]+").Value+"2"
→ Then use the write cell activity to write the RemainingInventory variable value to the required cell in excel.
Check the below workflow for better understanding,
Sequence1.xaml (10.8 KB)
Check the below output excel -
Hope it helps!!
Dear mkankatala,
Please one more question
“ColumnFoundat” is not declared with an error
Please let me know this problem
Are you getting any exception in the workflow… @GEONYONG_AN
Send me the screenshot
This is my output data. Input data is declared as variable in UiPath
I am not understanding what you are saying… @GEONYONG_AN
OMG, I’m a new user in this Forum. so i can’t post the screenshot.
I have no idea… Thanks mkankatala
I have to on my way…
Click on the indicate button in below screenshot to upload the files… @GEONYONG_AN
If possible share us a excel file with dummy data but maintain the same structure then I am able to give the solution easily.
Okay @GEONYONG_AN
You stored the two variables where you want to write in excel right,
→ Then delete the set variable value activity and find\replace value activity in your flow.
→ Inside Use excel file activity first, insert the Find/replace value activity and give parameters as below,
Select the Find option in Operation dropdown.
In where to serach give the Excel.Sheet(“Sheet name”)
In Value to find give the DateTime.Now.ToString(“M/d”)
Create a variable with ColumnFoundAt variable name in the Foundat field.
→ After Find/Replace activity insert the Set variable value activity and create a variable called CelltoWrite_A which is string datatype. then give the below expression,
CelltoWrite_A = System.Text.RegularExpressions.Regex.Match(ColumnFoundAt.ToString, "[A-Za-z]+").Value+"2"
→ Again take one more Set variable value activity and create a variable called Celltowrite_B and give the below expression,
Celltowrite_B = System.Text.RegularExpressions.Regex.Match(ColumnFoundAt.ToString, "[A-Za-z]+").Value+"3"
→ After this use the write cell activity and pass the variable which you want to write in 2nd row in what to write field and give the Excel.Sheet(“Sheet Name”).Cell(Celltowrite_A) as below image,
Check the below workflow and develop the same in your code,
Hope it helps!!
1 Like
Dear mkankatala,
I did it!!
Many Thanks, my teacher! 
It’s my pleasure… @GEONYONG_AN
Happy Automation!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
prashant1603765
gorby
sharazkm32
pabaleloh