Skip to main content
Answer

I want to take the text that I have and loop it in Excel

  • February 22, 2024
  • 8 replies
  • 150 views

Forum|alt.badge.img+4

I want to disturb those who know. If I want to take the text that I have and loop it in Excel with specified columns, for example from row 2 to column H, what should I do? Circle and enter data for about 15 rows.

Best answer by Ahmedhd

make your loop for each row in excel sheet, specific rows from 2 to 15, and save the output to rCurrentRecord variable. then use this record variable to access your column H by index or by your column’s header name

8 replies

Forum|alt.badge.img
  • Cadet | Tier 2
  • February 22, 2024

Can you elaburate your requerment. 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 22, 2024

I want to disturb those who know. If I want to take the text that I have and loop it in Excel with specified columns, for example from row 2 to column H, what should I do? Circle and enter data for about 15 rows.

Please share specific requirement, also screenshots, if it is possible.


Forum|alt.badge.img+3
  • Navigator | Tier 3
  • Answer
  • February 22, 2024

make your loop for each row in excel sheet, specific rows from 2 to 15, and save the output to rCurrentRecord variable. then use this record variable to access your column H by index or by your column’s header name


Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • February 23, 2024

 

I want to take the variable values ​​that I got from one place and loop them into the fields of This DocumentNumber continues down until the end of the available value.


Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • February 23, 2024

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 23, 2024

 

I want to take the variable values ​​that I got from one place and loop them into the fields of This DocumentNumber continues down until the end of the available value.

Can you please elaborate

 

Forum|alt.badge.img+4
  • Author
  • Navigator | Tier 3
  • February 23, 2024

I run sap and get 1 document number to replace the variable value. Then I want to take the value of that variable and put it in the row in the Document Number field for each row.


Forum|alt.badge.img+3
  • Navigator | Tier 3
  • February 23, 2024

after making your loop “for each row in excel advanced or excel if you do not have excel installed” from row 2 to nTotalRows variable “by grabbing get number of rows from excel advanced package and save the output to nTotalRows variable”. then assign the output from the loop to a record variable, let’s call it “rCurrentRecordVariable”. then inside the loop, grab “set cell from excel advanced package”. the question now is which cell?. in your case you need to fill the columns H “DocumentNumber”. then in the cell option of “set cell action” use specific cell and write U$rCurerntRecordVariable[your cell index or by cell name]$. then in the cell value choose your variable value