Export data

Export data - Сообщения

#1 Опубликовано: 10.12.2012 16:09:15
martin

martin

0 сообщений из 2 понравились пользователям.

Группа: 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 Опубликовано: 10.12.2012 21:39:33
Martin Kraska

Martin Kraska

1222 сообщений из 2150 понравились пользователям.

Группа: 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 Опубликовано: 11.12.2012 11:35:41
Davide Carpi

Davide Carpi

1415 сообщений из 2872 понравились пользователям.

Группа: 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 Опубликовано: 11.12.2012 14:38:47
martin

martin

0 сообщений из 2 понравились пользователям.

Группа: User

Hello,

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

Now I can be happy user of Smath
#5 Опубликовано: 11.12.2012 17:26:35
Davide Carpi

Davide Carpi

1415 сообщений из 2872 понравились пользователям.

Группа: 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
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений