Navigating Columns and Rows of a CSV file
The Problem: Navigating through a CSV file to write data in specific columns and rows.
This is the logic behind the code I am planning:
- Create the CSV file.
- Enter loop which will run the core function numerous times produces numerous sets of data to be saved to the csv file.
- Close and clear.
The problem I foresee is this...
Each run of the core function will produce 2 columns of data. Each time I run the core function I would like to append further columns to the csv file. e.g.) After run 1 columns A and B are filled with data, after run 2 - further data is added to columns C and D, etc.
My question is this, how can I write, for example, to the 1st row of the 3rd column after my initial data write??? To put it another way, after the first set of data has been written to columns A and B, how do I code for then writing to the next available column space for the next set of data?
Thanks for reading. Any suggestions will be gratefully received.