Subject: Re: [WB]load points from xls using API (Js) Author: =?UTF-8?B?UmFmYcWCIFJvYmFr?= Date: 2008-10-14 18:27:35Fabricio Lopes e Silva wrote: > Dear all, > > I have a very large xls file from where I would like to get points to > use as basis for profiles in Workbench. I saw that is possible to > introduce points via API into WB's sketches, but I could not find a way > to do it reading directly from excel files. > There is a possibility that uses the option "points" to load some points > from txt files, but this points are not imported into sketches and I > think it is a problem to generate a body with some specific tools from WB. > Somebody knows something about that? I found some information aobut > reading a excel file with JavaScript, but I couldn't find some > information about writing this points as JScript to run in Workbench. > > Thanks in advance > > Fabricio Lopes e Silva > Doctoral Student > ^---------------------------------------------------- > | XANSYS web - www.xansys.org | > | XANSYS blog - xansys.blogspot.com | > | The Online Community for users | > | of ANSYS, Inc. Software | > | Hosted by PADT - www.padtinc.com | > ^---------------------------------------------------- > > Hi, Maybe you will able to export xls file to text file. If yes i think it will be simple to create profile in Ansys using APDL macro. Just you have to read points to array and the create kpoints (k,nn,x,y,z and lines on these kp). After that macro can export IGES file with entire model which you can read in WB.