xls import

xls import - importing data from excel table of steel sections - 消息

#1 已发布: 2018/4/24 05:46:43
ftodorovic

ftodorovic

0个赞,共1个帖子。

组: User

Database_ArcelorMittal.xlsx (471.15 KiB)已下载 881 次。
I downloaded arcelormittal's table of steel sections parameters. It contains in first column a name of section (e.g HE 200 and in next columns other numerous parameters like dimensions of flange, web, radius in between, area, inertia moments, second moment of area, radius of gyration ... I would like to make smath calculation where in input parameters i would enter a name of a section and in next step to define variables h=, b=, A=, Iy=, Iz= ... parameters of steel section which would read their values from xls table that is in the same row like a name that i previously entered. I guess it could be done because i made the same sheet in mathcad. Does anyone knows how?
#2 已发布: 2018/4/24 05:49:09
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

Hello [userlink]ftodorovic[/userlink],


look here
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#3 已发布: 2018/4/24 09:11:53
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Wrote

I would like to make smath calculation ...


You could create a resident Smath document of that Excel steel properties.
c/w a header, via a for-loop, same as Mathcad.

  • 有新帖
  • 无新帖