PowerShell Script for Excel Data Integration
Budget: $10 – $30 USD
I'm seeking a PowerShell expert who can create a script to read data from an Excel file, update variables in a sample plain text template, and save the text file with the variable name and date as the filename in a different folder.
Key Requirements:
- The saved text files should be named using the variable name from the specified Excel column.
- The specific Excel columns containing the variable names and the data to be updated will be provided later.
- The script needs to work with a provided plain text file template.
Ideal Skills and Experience:
- Proficient in PowerShell scripting.
- Experienced with Excel data manipulation.
- Familiar with working with plain text file templates.
- Able to deliver a flexible script that can accommodate custom specifications.
The date should be included in the filename in the format YYYY-MM-DD. The script should be capable of processing new Excel files on a **"when required"** basis. In case of errors or invalid data in the Excel file, the script should log the error and continue processing. Errors should be logged to the console. The filename should separate the variable name and date using a hyphen (-). If the text template is missing one of the variables mentioned in the Excel file, log an error and continue with the next entry. The error log should be in a plain text format. The script should be compatible with PowerShell 5.1. The text files should be saved in plain text format.
Key Requirements:
- The saved text files should be named using the variable name from the specified Excel column.
- The specific Excel columns containing the variable names and the data to be updated will be provided later.
- The script needs to work with a provided plain text file template.
Ideal Skills and Experience:
- Proficient in PowerShell scripting.
- Experienced with Excel data manipulation.
- Familiar with working with plain text file templates.
- Able to deliver a flexible script that can accommodate custom specifications.
The date should be included in the filename in the format YYYY-MM-DD. The script should be capable of processing new Excel files on a **"when required"** basis. In case of errors or invalid data in the Excel file, the script should log the error and continue processing. Errors should be logged to the console. The filename should separate the variable name and date using a hyphen (-). If the text template is missing one of the variables mentioned in the Excel file, log an error and continue with the next entry. The error log should be in a plain text format. The script should be compatible with PowerShell 5.1. The text files should be saved in plain text format.