Write to a specific CSV position

Solar2D General Questions/Discussion
#1

Hello, I have .CSV files, needs to change in my Corona app.
 

How it looks in Excel

[sharedmedia=core:attachments:7347]
How it looks in Corona

[sharedmedia=core:attachments:7348]

For example I need to write a value in F8 cell. What should I do for write to this cell using Corona?

#2

Have you thought about doing it in SQLlite? CSV can be imported into a .db file and read/edited in Corona.

#3

This program will not be for me, and that person only has .CSV files.SQLlite is only one solution?

#4

Trying to edit a csv file with an excel mindset isnt gonna work well. The csv file doesnt have a F8 cell to edit. I suppose some smart logic and counting could do it but its an uphill battle.

Import to SQLite is much better but i suspect you want to use corona to edit that csv file, and thats a bit like the wrong tool for the job

#5

Ok, how I can import my .CSV to .DB ?

WIll work this code in corona for import csv to db?

sqlite\> .mode csv sqlite\>.import c:/sqlite/mydb.csv dbs
#6

You should read the corona documentation, its well written and understandable.

#7

You could convert your CSV to JSON

Then to edit F8 it would be jsonTable[8][6] = "My new value"

But this would only modify the in memory copy of the table, you would need to persist the JSON to disk if you wanted a permanent edit

#8

Have you thought about doing it in SQLlite? CSV can be imported into a .db file and read/edited in Corona.

#9

This program will not be for me, and that person only has .CSV files.SQLlite is only one solution?

#10

Trying to edit a csv file with an excel mindset isnt gonna work well. The csv file doesnt have a F8 cell to edit. I suppose some smart logic and counting could do it but its an uphill battle.

Import to SQLite is much better but i suspect you want to use corona to edit that csv file, and thats a bit like the wrong tool for the job

#11

Ok, how I can import my .CSV to .DB ?

WIll work this code in corona for import csv to db?

sqlite\> .mode csv sqlite\>.import c:/sqlite/mydb.csv dbs
#12

You should read the corona documentation, its well written and understandable.

#13

You could convert your CSV to JSON

Then to edit F8 it would be jsonTable[8][6] = "My new value"

But this would only modify the in memory copy of the table, you would need to persist the JSON to disk if you wanted a permanent edit