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
700 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Lockdown of laptops 10 39
Share and Advanced Sharing permissions 8 54
Trasfering FSMO roles 8 76
Folder size tool 6 61
Learn about cloud computing and its benefits for small business owners.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

757 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

22 Experts available now in Live!

Get 1:1 Help Now