Solved

PowerShell script to programmatically rename a .csv file to a .xls or .xlt file after .csv lands on a windows file share.

Posted on 2010-09-15
3
710 Views
Last Modified: 2012-05-11
PowerShell script to programmatically rename a .csv file to a .xls or .xlt file after .csv lands on a windows file share.

Trying to find a solution that will change the format of the file...have a solution for renaming...it just does not change the format.
0
Comment
Question by:JGH5
3 Comments
 
LVL 28

Accepted Solution

by:
Michael Pfister earned 500 total points
ID: 33680828
I assume you want to read the CSV into PowerShell and export it as an XLS?

There is no "export to XLS" function, but LucD wrote a nice PS function to do it.

http://www.lucd.info/2010/05/29/beyond-export-csv-export-xls/

HTH
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 34850242
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

821 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