search

robocorp / rpaframework

Collection of open-source libraries and tools for Robotic Process Automation (RPA), designed to be used with both Robot Framework and Python
https://www.rpaframework.org/
Apache License 2.0
1.17k stars 225 forks source link

No easy way to export/import RPA.Tables from/to RPA.Excel.Files #214

Open orlof opened 3 years ago

orlof commented 3 years ago

Sometimes it is necessary to extract a Table from exact area e.g. B3-D13. It might be logical to be able to also insert a Table into a specific location in Excel.

cmin764 commented 3 years ago

One keyword for extracting the custom region from excel as RPA table type.

Support

cmin764 commented 2 years ago

This looks outdated, so I'll break this feature in the actions we need to support (checked means already supported):

  1. [x] Import full Table from Excel: Read Worksheet As Table -> where we get the entire content as a Table object
  2. [x] Crop the table on both dimensions with: Pop Table Column, Pop Table Row, Filter Table By Column, Filter Empty Rows
  3. [ ] Import partial Table from Excel in one go: by providing top-left and bottom-right corners as cell positions. Can be accomplished with cell corner positions passed as params to Read Worksheet As Table. Do we want to support the same when reading from a CSV file as well?
  4. [ ] Set Cells Area new RPA.Excel.Files keyword: which inserts with overwrite a given Table from a starting top-left cell corner position into the active worksheet.

So I feel numbers 3 & 4 are missing and should be implemented. Is that correct @orlof / @mikahanninen ? (marked this as in consideration until we further scope and prioritize it)