Skip to main content
Question

Extract certain values from Excel

  • July 18, 2023
  • 2 replies
  • 189 views
J
Forum|alt.badge.img+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

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+18
  • Tamil Arasu10Most Valuable Pathfinder
  • Most Valuable Pathfinder
  • July 20, 2023

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.

_Tamil_
J
J
Forum|alt.badge.img+4
  • jsegura 2409
  • Author
  • Cadet | Tier 2
  • July 21, 2023

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

Terms & ConditionsCookie settingsAccessibility statement