Export an R data frame into a formatted Excel sheet
Posted 22nd March 2024
No comments
A straightforward method for exporting an R data frame to a formatted Excel workbook.
Convert CSV to XLSX via PowerShell
Posted 9th March 2016
51 comments
A nifty PowerShell script that will take a delimited CSV file and convert it to a XLSX file.
Combine multiple CSVs into one XLSX via PowerShell
Posted 25th November 2015
19 comments
A convenient PowerShell script that will detect all of the CSV files in a directory and merge them into a single XLSX file. Each CSV becomes a worksheet in the XLSX.