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
712 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Configuring Remote Assistance for use with SCCM
An introduction to the wonderful sport of Scam Baiting.  Learn how to help fight scammers by beating them at their own game. This great pass time helps the world, while providing an endless source of entertainment. Enjoy!
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…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

717 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