Use the Excel VBO. Create an Excel Instance.Jacob - What to do If i want to follow your approach?
I've around 10 workbooks in one folder how can I move all data the into one collection? Please specify the steps and I would really appreciate if you proivde some screenshot as well.
Many thanks
Use Append Rows to Collection action - your master collection (which will be empty on the first time around the loop) should be the Main Collection input, and your new collection should be the Collection to Append input.I've managed all of the suggested tasks above by (nickbell123) except this one (Once you have extracted the worksheet into a collection, append that to a single master collection that will contain all of your data (look through the Utility - Collection Manipulation actions). Continue through the loop.). When I tried to append the data it's completely remove the all the data from the collection
Kindly help. All i want to do is to copy all the data one by one into master collection
If you need them as Input parameters they also need to be set in the Input of the Start stage of the Filter action.Hi
I've one created one tab inside the MS Excel VBO to filter out some data in excel sheet. I've provided the parameters such as handle, workbook, workbookname (refer Filter_1 Excel vbo screenshot2). But when I am calling that Filter VBO through Action parameters not showing up(refer Filter_2 Excel vbo screenshot3). I've attached the screenshots. please let me know what I am doing wrong..thanks
Try Worksheet.UsedRangeHi There,
Is there any function or command which I can use inside the code to select all the data from excel worksheet at one go. I've used currentregion (VBA technique) but didn't work for me.
Thanks in advanced
How do you determine what a duplicate is? On one field or multiple?Thanks it's working now.
Is there any way to get unique list from any column or remove duplicates?