Solved

How to read a excel file and write into another excel using PowerShell script

Posted on 2014-09-17
1
282 Views
Last Modified: 2014-09-21
I have excel file with two sheets and I would like to read each sheet and write into another excel using PowerShell. Could you provide the code How can i do using powershell script
0
Comment
Question by:SURESH0518
1 Comment
 
LVL 40

Accepted Solution

by:
Subsun earned 500 total points
ID: 40330800
You can use the module from TechNet gallery Import From and Export To Excel.

Ref : http://gallery.technet.microsoft.com/office/7b2fdc8f-a528-4f19-b9ef-f5af349dc906

Once you import the module to PowerShell you can use commands Export-Excel & Import-Excel
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

This article shows how a content item can be identified directly or through translation of a navigation type. It then shows how this information can be used to create a menu for further navigation.
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now