July 14th, 2012, 10:17 AM
Is it possible to use Parse Record procedure on 5 CSV files
I have an unusual request / problem:
- open 5 csv files,
- calculate the average value for each cell,
- save one csv file with new values, which has the same structure as the five selected.
Is it possible to calculate the average of the matrix / Each cell separately in Borland Delphi 7?
July 21st, 2012, 06:52 AM
Yes, it is possible. Use TStringList instances to help you read in and parse csv files, and also to write the new csv file.
July 22nd, 2012, 01:47 PM
Another option would be to automate the process with Excel (only possible if Excel is installed on your and your user's computer)
You can look here for an example of automating excel from within Delphi: