How can i create a table on a csv file?

Answer 1

what i mean is, i know writting on a csv file literaly means writing in a spread sheet, and it is comma separated that for every comma, means a cell.

But while using a spread sheet manualy, you can create graphs,charts, figures, tables, add pictures etc.

Now am trying to create a function which when it is called it will automatically open /create a csv file a prepare a table ready for user of my application/program to input data. so that when the user views the file, he/she will see a table with a distinct number of rows and columns, or when the user goes into the files and open the excel file, he/she will see the data he or she inserted are in a table.

Help please!!!!.

Answer 2

The rows will be increasing but the columns will be static, i dont care what will display on the console window, all i what is if i go to the file and open spreadsheet i created using the program, i want to see the data i a table.

I know it seems like am complicating thing but i want it that way, if there is a way.

Answer 3

Can you explain your question more clearly?
CSV file store data in plain text, each value is separated by comma (by default). For e.g: file test.csv contains "This, is, an, example", if you open this file in MS Excel (or similar programs), it can be displayed in table as |This|is|an|example|

Answer 4

I think you simply need to write your text data in an file.csv (row by row), and open it by any spreadsheet to see data in clean 'tabular' display. You should try manually create and edit the csv file then check how it actually display on a spreadsheet.
You can also convert the file type by rename '.csv' to '.xls' if need to do graphs, charts, .etc directly on the file, thought it doesn't guarantee to convert back from '.xls' to '.csv' correctly.