CalcBuilder Forum

Loading CSV file into Matrix

User moon_336 2012-03-27 22:47:18

Hi,

I have tried many methods to get a CSV file loaded into a matrix but can't seem to get the matrix to format correctly with 6 columns.

I end up with 1 column and all 6 column values per row entered into the 1 cell of each row in the single column.

Please advise.


Aaah, I have this sorted. No problems.

Thanks

Edited by moon_336 - 28.03.2012 09:55

Moonsoft support 2012-03-28 10:01:17

Hello,

We can see you have a solution ;) . Although we write some basic cvs tips to help anyone in forum.

CSV column content should be without "" or '' and separate colum char are ;

For example:

;1;2;3
A0;A1;A2;A3

This csv code creates 2 rows with 4 colums (first column of first row is not considered).

Hope this helps. Regards,

Moonsoft Team

...
Support/development 40 hours

With the peace of mind of having a professional team at your service (20% discount)

Buy now!
...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!