Excel Table

Excel Table - Add an table of excel - Messages

#1 Posted: 10/2/2021 10:31:09 PM
Lelar

Lelar

0 likes in 7 posts.

Group: User

Hi there! I am newbie in Smath, and I want to add an excel table but, when I take a screenshot, this image looks a bit pixelated, anyway, I know that with a code I will be able to add this table, but I don't know how. I hope you can help me.
#2 Posted: 10/3/2021 12:42:01 PM
overlord

overlord

551 likes in 1332 posts.

Group: Moderator

There is a tool SMath Matrix editor for windows as far as I remember.
Excel spreadsheet could be copied from excel and pasted into it as SMath matrix.
Than that matrix can be shown as a table region.

There is also xlsx import plugins, they directly get tables from excel files.
Than table region solution again.

If it is not proprietary data, attaching it to this topic could help you faster.
Someone shall show you how to do it fast and properly.

Regards
#3 Posted: 10/3/2021 1:02:53 PM
Lelar

Lelar

0 likes in 7 posts.

Group: User

Hi! thanks for your answer, I install the xls extension... I wanna add this table of excel... If u can help me it could be very usefull.
DensidadMaxMin.xlsx (14 KiB) downloaded 118 time(s).
#4 Posted: 10/3/2021 5:08:00 PM
overlord

overlord

551 likes in 1332 posts.

Group: Moderator

Wrote

Hi! thanks for your answer, I install the xls extension... I wanna add this table of excel... If u can help me it could be very usefull.


Put this worksheet into same folder of your excel file.
When you open it you will get your table.
If you don't need excel file later, just copy the values of table.
And make a new variable named table, define it with that copied matrix.
After that, you can remove importData() function.

Regards

Worksheet1.sm (8 KiB) downloaded 254 time(s).
  • New Posts New Posts
  • No New Posts No New Posts