Extract and convert all Excel worksheets into CSV files using PowerShell

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 21 May 2014 06:00:00 UT Indexed on 2014/05/29 9:37 UTC
Read the original article Hit count: 206

Filed under:

Can PowerShell provide an easy way to export Excel as a CSV? Yes. Tim Smith demonstrates that whether you have multiple Excel files, or just multiple worksheets in Excel, PowerShell simplifies the process.

sqlmonitor Get to grips with SQL Server replication
In this new eBook Sebastian Meine gives a hands-on introduction to SQL Server replication, including implementation and security. Download free ebook now.

© SQL Server Central or respective owner