This topic contains 4 replies, has 3 voices, and was last updated by
April 4, 2018 at 5:05 pm #97884ParticipantPoints: 0Rank: Member
I have 50+ files (Excel) with 4 or 5 working sheets in it, e.g Main, Jan, Feb, Mar, Apr etc. from each sheet in particular column (Fixed) e.g Customer Number in A1), I need to copy the entire column, again there will be gabs in numbers row wise, all visible numbers to copied and pasted in new excel sheet, the task has to performed for 50+ files (Loop through).
In total 50* 3 sheets = 150 Sheets to be processed, all the customer numbers to be populated in to separate excel sheet.
If some one can help me to fix this will be appreciated.
April 4, 2018 at 5:08 pm #97885KeymasterPoints: 1,785Rank: Community Hero
I find I often get better and more useful answers when I ask a specific PowerShell question, rather than just stating a need and hoping someone posts a complete script ;).
Have you tried something in particular and gotten stuck, for example? If there's a specific question, it would be easier to try and aim for an answer.
Note that programming Excel from PowerShell isn't easy all the time. The Excel programmability bits are old, and imperfectly compatible. It would probably be easier to do this entirely inside Excel, using VBA, and Microsoft has several excellent tutorials and example sets for that.
April 4, 2018 at 5:14 pm #97887ParticipantPoints: 0Rank: Member
I am not use to power shell, I have tried with SSIS but its not working for me, so thought to give a try with google, most of the options are feasible with power shell.
April 4, 2018 at 5:16 pm #97888KeymasterPoints: 1,785Rank: Community Hero
Well, as we're all volunteers with existing full-time jobs, I'm not sure anyone's going to be able to jump in and just tell you how to do it. We're happy to answer specific questions, if you have one, though! I would personally use VBA entirely within Excel, as it would be easier than PowerShell.
April 4, 2018 at 6:00 pm #97890ParticipantPoints: 80Rank: Member
i've done a bit of excel work, mostly combining csv files into an excel output.
take a look at the module here:
its what i'm using
The topic ‘Extract and paste particular column from excel to new one’ is closed to new replies.