PowerShell script to convert Excel rows into individual txt files
Budget: £10 – £20 GBP
1. Our Excel spreadsheet has 8 columns and 1000+ rows. Each row needs to be transformed into an individual txt file.
2. The first column is the file name.
3. The other 7 column headings will be the field labels on the txt file (stacked). The label will be followed by the data from that cell.
4. If the cell is empty (no data), the field label will NOT be included in the transcript.
2. The first column is the file name.
3. The other 7 column headings will be the field labels on the txt file (stacked). The label will be followed by the data from that cell.
4. If the cell is empty (no data), the field label will NOT be included in the transcript.