Copy particular Excel columns values to Datatable

Help Studio
, ,
1

Attached Input XLS file for reference…
TEST1.XLS (30.5 KB)
This file will downloaded from SAP.

Requirement —

  1. Need to copy the row values under “User” & Logon (There are two logon columns… we need the values only from First logon column) column from XLS file to DT
  2. Change the column name from “User” to “UserID”
  3. Remove the empty row next to “User” Column

Note : There is no FIXED row number for this “User” Column… because in every download this user column will be different row

The image shows a screenshot of an Excel spreadsheet listing user account details, including usernames, login times, and password statuses. (Captioned by AI)
The image shows a screenshot of an Excel spreadsheet listing user account details, including usernames, login times, and password statuses. (Captioned by AI)1867×599 56.3 KB

Expected output : — Please refer this file for expected output
expectedoutput.xlsx (10.9 KB)

2

Hi @Sathish_Kumar_S

Can you try the below

This image depicts an automated Excel processing workflow that includes steps for opening a file, finding and replacing values, displaying message boxes, copying and pasting ranges, reading a range, filtering data, clearing a range, and writing a DataTable to an Excel sheet. (Captioned by AI)
This image depicts an automated Excel processing workflow that includes steps for opening a file, finding and replacing values, displaying message boxes, copying and pasting ranges, reading a range, filtering data, clearing a range, and writing a DataTable to an Excel sheet. (Captioned by AI)832×2799 208 KB

Sequence21.xaml (18.2 KB)

Output:

A spreadsheet with columns for "UserID" and "Logon," containing one entry with "IDALAI" and the logon date "08/28/2024". (Captioned by AI)

Regards,

3

Thank you …it worked

1 Like
4

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