Hello!
What I have done has been to create a SetConnection action using Data OLEDB.
"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\VoNet\RobotsVonet\BUYBACKMONITORINGSAP3.xls;Extended Properties=""Excel 12.0 Xml;HDR=Yes;"""
To manipulate the collection (because I only want some columns)...
Hello! I need to copy only some columns of .xls1 and paste in another .xls2 but in different order of the columns, that is to say, xls1 copied column A and C and paste it in .xls2 in D and E.
Please, I appreciate your help.
regards
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.