Author Topic: Titleblock take data from xls  (Read 2251 times)

0 Members and 1 Guest are viewing this topic.

Zykl0

  • Guest
Titleblock take data from xls
« on: May 12, 2009, 09:19:06 AM »
Hello,

I am trying to figure a way to take data from .xls files and update Mtext or Attribute in my layout.
Like most programming language do with .ini files.

What i am trying to do is creating a Master file in excel for each future project, and filling every needed cell like;
adress1, adress2, contractor, and other usefull informations.

I'm on AutoCAD 2007 Actually and maybe 2010 if i can find some argument to convince my boss.

Thanks

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Titleblock take data from xls
« Reply #1 on: May 12, 2009, 09:35:27 AM »
Me thinks you will be happier trying to perform this function with FIELDS, and Sheet Set Manager. (no upgrade required)
Be your Best


Michael Farrell
http://primeservicesglobal.com/

Zykl0

  • Guest
Re: Titleblock take data from xls
« Reply #2 on: May 12, 2009, 09:58:08 AM »
Me thinks you will be happier trying to perform this function with FIELDS, and Sheet Set Manager. (no upgrade required)

i tired the Field earlier but i cant find anything usefull with this
Tried with hyperlink, loaded excel file, and everything i see is the path of the excel file in mtext (not that useful :( )

mjfarrell

  • Seagull
  • Posts: 14444
  • Every Student their own Lesson
Re: Titleblock take data from xls
« Reply #3 on: May 12, 2009, 10:04:52 AM »
Did you try using Sheet Set Manager, and Fields together?


I am not saying that you can link this to your client/project XLS file, however one need only enter this data once for the client/project, and then one can use current or previous sheet sets as a template for the next set of sheets(job).

Someone here might have a way to edit the DST file and create the sheet set files with VBA or other program.
Be your Best


Michael Farrell
http://primeservicesglobal.com/

It's Alive!

  • Retired
  • Needs a day job
  • Posts: 8662
  • AKA Daniel
Re: Titleblock take data from xls
« Reply #4 on: May 12, 2009, 10:16:13 AM »
I use fields and custom properties, also I wrote a little routine to save the data in an SQLite database.
You can probably find something to query an XLS file to populate the fields