Export data

Export data - Messages

#1 Posted: 12/10/2012 4:09:15 PM
martin

martin

0 likes in 2 posts.

Group: User

Hello,

can you help me with exporting of data, please? I need export data from Smath to any txt, csv, or xls file. I tried ExcelCollab plugin, but it is not function in version 0.95. If I made matrix using function augment and than save this matrix to file with function wfile it is in bad format, not exportable to excel.

For me is very important possibility make graphs in excel or gnuplot. Do you know how can I solve this problem?

Thank you for help

Martin
#2 Posted: 12/10/2012 9:39:33 PM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

Hi,

the excel plugin indeed is somewhat broken. You can write data to a file and read in again but excel can't read that file. Also reading in does not work for floating point numbers, just for integers or strings. Keep in mind, that the file must exist before reading or writing to it.

Alternative would be to use wfile with separate vectors for individual columns and replace the argument delimiters (e.g. by newlines. Then gnuplot should cope. Eventuelly, you can define an input format directly in gnuplot. I never did data export. Rather I would then go for Maxima, Octave, Scilab or the like. SMath for me is fine as long I can take advantage of the GUI and the 2D doc format. Of course, all these tools would be able to read wfile format (with some regexp coding) and make nice plots out of these. However, they could generate the data perhaps directly.

Best regards, Martin Kraska
Excel.PNG
Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#3 Posted: 12/11/2012 11:35:41 AM
Davide Carpi

Davide Carpi

1417 likes in 2873 posts.

Group: Moderator

Wrote

Hello,

can you help me with exporting of data, please? I need export data from Smath to any txt, csv, or xls file. I tried ExcelCollab plugin, but it is not function in version 0.95. If I made matrix using function augment and than save this matrix to file with function wfile it is in bad format, not exportable to excel.

For me is very important possibility make graphs in excel or gnuplot. Do you know how can I solve this problem?

Thank you for help

Martin



Hi martin,

you can try with the SMath matrix editor. (actually not available beacuse the wiki server is unavailable)

If you are brave enough you can try with the plugin attached here (it's a beta, I'm sure that works for the common cases but I have not had time to check for special cases)

EDIT: here there is the plugin updated and extended


regards,

w3b5urf3r
PrtScr capture.png
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#4 Posted: 12/11/2012 2:38:47 PM
martin

martin

0 likes in 2 posts.

Group: User

Hello,

thank you for your help. Export CSV function is that what I need.

Now I can be happy user of Smath
#5 Posted: 12/11/2012 5:26:35 PM
Davide Carpi

Davide Carpi

1417 likes in 2873 posts.

Group: Moderator

Wrote

Hello,

thank you for your help. Export CSV function is that what I need.

Now I can be happy user of Smath



You're welcome


best regards,

w3b5urf3r
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
  • New Posts New Posts
  • No New Posts No New Posts