Question

Extract certain values from Excel

  • 18 July 2023
  • 2 replies
  • 81 views

Badge +4

Hi, I am trying to extract certain values from certain columns from an Excel file and save them in different .csv files. I can’t wrap my head around on how to achieve that. Any help or advice pointing out how to achive it would be appreciated, thanks.


2 replies

Userlevel 5
Badge +10

Hi @jsegura 2409 ,

Use the Advanced Excel Package and Loop Package to read the certain columns values. while reading the use the log file action (path/filename.csv) and write the values in to the .csv file.

Would you like to check the based on condition please use the If Package while reading the values from excel sheet.

Badge +4

Hi, I want to store certain values from certain columns in the csv, but I’m getting all the values stored in a single cell, with no headers or anything. Is there a way of achieving that? (Storing the values in the CSV with their headers and in columns)

 

Thanks

Reply