Excel Table

Excel Table - Add an table of excel - 消息

#1 已发布: 2021/10/2 22:31:09
Lelar

Lelar

0个赞,共7个帖子。

组: 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 已发布: 2021/10/3 12:42:01
overlord

overlord

600个赞,共1,381个帖子。

组: 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 已发布: 2021/10/3 13:02:53
Lelar

Lelar

0个赞,共7个帖子。

组: 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.07 KiB)已下载 1000 次。
#4 已发布: 2021/10/3 17:08:00
overlord

overlord

600个赞,共1,381个帖子。

组: 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.99 KiB)已下载 1543 次。
  • 有新帖
  • 无新帖