Convert CSV file to Excel file
Budget: £10 – £20 GBP
CSV files are stored in C:/csvfiles. Four sample files are contained within sampleinput.zip
Script required to:
• Collate all CSV files (can be up to 20 files) into one merged file (as per CONVERTEDOUTPUT.XLSX).
• The CLOSED PRICE and DATE are the columns required.
• If dates do not align for all input files, a warning message is to be produced and the conversion should fail - for example, if the list of dates for one CSV file is different to the other CSV files.
• The output file contains formulas (bold text) and should be able to handle up to 20 csv files
Script required to:
• Collate all CSV files (can be up to 20 files) into one merged file (as per CONVERTEDOUTPUT.XLSX).
• The CLOSED PRICE and DATE are the columns required.
• If dates do not align for all input files, a warning message is to be produced and the conversion should fail - for example, if the list of dates for one CSV file is different to the other CSV files.
• The output file contains formulas (bold text) and should be able to handle up to 20 csv files