Need to copy one of excel sheet data into another new excel other than read and write range

Help Activities
, ,
1

Hi Team,

I have an input excel with multiple sheets.

i need to extract one of the excel sheet data into another new excel without using read and write range excel or workbook activities.

Do we have any other option?

Thanks
Likitha

2

@vinjam_likitha

I think its not possible without using read range and write range activities

if we found any it was nice to learn that!

thanks

3

Hello @vinjam_likitha

  1. Initialize an Excel Application Scope to work with Excel files.

  2. Use Excel VBA code to open the source Excel file and extract data from the specific sheet.

  3. Create a new Excel file.

  4. Copy the extracted data to the new Excel file.

  5. Save and close both Excel files.

  6. End the Excel Application Scope to release resources.

Thanks & Cheers!!!

4

Hi,

can’t we use LINQ queries?

Thanks
Likitha

5

hi @vinjam_likitha
Extract the data and write it into datatable using Build datatable and use the data table output variable for the further process.
It Helps!

6

@vinjam_likitha

LINQ queries is used for datatable which are applied after reading the excel files.

1 Like
7

Hi, if you want to extract data from one sheet of an Excel file and write it to another Excel file without using the “Read Range” and “Write Range” activities, you can use the following steps:

  1. Use the “Excel Application Scope” activity to open the source Excel file, which contains the sheet you want to extract data from.

  2. Use the “Select Range” activity to select the entire sheet’s data you want to copy. This activity simulates selecting data using keyboard shortcuts, similar to pressing Ctrl+A.

  3. Use the “Copy Selected Text” activity to copy the selected data to the clipboard.

  4. Use the “Excel Application Scope” activity to open the target Excel file where you want to paste the data.

  5. Use the “Send Hotkey” activity to activate the target Excel file and simulate the Ctrl+V (Paste) keyboard shortcut to paste the data from the clipboard into the target Excel file.

8

@vinjam_likitha
firstly we need to read the excel data ,all the data stored in a datatable-then we can you LinQ for that datatable…
without reading excel we cant use LinQ for excel files or excel sheets

9

Hi @vinjam_likitha

You can use invoke vba activity within excel Process scope.

image
image742Ă—692 28.9 KB

Hope it helps!!

10

After reading the excel the data is stored in datatable. how to apply linq queries on it

11

can you tell me the requirement for applying the linq

12

i need to read the one of the sheet excel data. and store it in datatable. then need to apply linq queries to copy to another new excel

13

@vinjam_likitha
are you perfoming any filteration or sorting in the DT to store into second excel sheet?

14

i planning to go with macro

Thanks all for the solutions

1 Like