Author Topic: Excel library subs  (Read 36869 times)

0 Members and 1 Guest are viewing this topic.

jbuzbee

  • Swamp Rat
  • Posts: 851
Excel library subs
« on: May 31, 2011, 10:16:11 AM »
OK, before you yell at me I did try to search using "Excel" but you guys use the term "Excellent" WAY too much around here!  :-D

Does any one have a link or code for retrieving info in an excel spreadsheet via AutoLISP / VLisp?

Thank you for any help!!
« Last Edit: May 31, 2011, 10:19:30 AM by jbuzbee »
James Buzbee
Windows 8

kruuger

  • Swamp Rat
  • Posts: 625
Re: Excell library subs
« Reply #1 on: May 31, 2011, 10:19:50 AM »
OK, before you yell at me I did try to search using "Excel" but you guys use the term "Excellent" WAY too much around here!  :-D

Does any one have a link or code for retrieving info in an excel spreadsheet via AutoLISP / VLisp?

Thank you for any help!!
try READ EXCEL
kruuger

jbuzbee

  • Swamp Rat
  • Posts: 851
Re: Excel library subs
« Reply #2 on: May 31, 2011, 10:32:21 AM »
Excellent!  Thanks!!

 :-)
James Buzbee
Windows 8

hmspe

  • Bull Frog
  • Posts: 362
Re: Excel library subs
« Reply #3 on: May 31, 2011, 10:46:25 AM »
Somewhat off topic, but I have to agree with jbuzbee.  This site is incredibly hard to search and have meaningful results.  Punctuation gets stripped out, and there's no way to search for a phrase that I can find.  Yesterday I wanted to look for      (command "text"      as a phrase.  103 pages of results were returned.  If I limit the search to the lisp and "show your stuff" forums it is still 51 pages.  The search function would be fine for most sites, but for a site that deals with programming languages it leaves a lot to be desired.  I also wish that there was a way to make the forum selections sticky instead of having search default to all forums.  

I don't mean for this to be taken as a complaint.  More a "wish list" suggestion.  This is a great site, and one that I've benefited from greatly.  
"Science is the belief in the ignorance of experts." - Richard Feynman

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Excel library subs
« Reply #4 on: May 31, 2011, 10:49:32 AM »
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
Re: Excel library subs
« Reply #5 on: May 31, 2011, 10:59:58 AM »
I use google often for swamp searches too. 8-)

Check this out as well James
http://web2.airmail.net/terrycad/LISP/GetExcel.lsp
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

alanjt

  • Needs a day job
  • Posts: 5352
  • Standby for witty remark...
Re: Excel library subs
« Reply #6 on: May 31, 2011, 11:05:47 AM »
I use google often for swamp searches too. 8-)

Check this out as well James
http://web2.airmail.net/terrycad/LISP/GetExcel.lsp
Well, I feel like a noob; I just use theSwamp to search theSwamp.

let me do that for you
or this
Civil 3D 2019 ~ Windohz 7 64bit
Dropbox

hmspe

  • Bull Frog
  • Posts: 362
Re: Excel library subs
« Reply #7 on: May 31, 2011, 12:07:52 PM »
I realize that Google search works, and I appreciate the syntax example since I've never quite figured out Google search syntax works.  Maybe its just me, but I prefer to use the search built-in to a web site when possible.   
"Science is the belief in the ignorance of experts." - Richard Feynman

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
« Last Edit: May 31, 2011, 12:52:01 PM by CAB »
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

Matt__W

  • Seagull
  • Posts: 12955
  • I like my water diluted.
Autodesk Expert Elite
Revit Subject Matter Expert (SME)
Owner/FAA sUAS Pilot @ http://skyviz.io

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
Re: Excel library subs
« Reply #10 on: May 31, 2011, 12:51:40 PM »
I realize that Google search works, and I appreciate the syntax example since I've never quite figured out Google search syntax works.  Maybe its just me, but I prefer to use the search built-in to a web site when possible.   
I always start here:
http://www.google.com/advanced_search?hl=en
using the this exact wording or phrase: to narrow down the search, same as using quotes
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
Re: Excel library subs
« Reply #11 on: May 31, 2011, 12:53:34 PM »
OK so spelling is my Kryptonite.  :-P
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

MP

  • Seagull
  • Posts: 17750
  • Have thousands of dwgs to process? Contact me.
Re: Excel library subs
« Reply #12 on: May 31, 2011, 12:54:21 PM »
maybe you and se7en could start a support group :P
Engineering Technologist • CAD Automation Practitioner
Automation ▸ Design ▸ Drafting ▸ Document Control ▸ Client
cadanalyst@gmail.comhttp://cadanalyst.slack.comhttp://linkedin.com/in/cadanalyst

CAB

  • Global Moderator
  • Seagull
  • Posts: 10401
Re: Excel library subs
« Reply #13 on: May 31, 2011, 01:03:30 PM »
Ah the perfect pear. he he he  8-)
I've reached the age where the happy hour is a nap. (°¿°)
Windows 10 core i7 4790k 4Ghz 32GB GTX 970
Please support this web site.

Lee Mac

  • Seagull
  • Posts: 12906
  • London, England
Re: Excel library subs
« Reply #14 on: May 31, 2011, 01:05:51 PM »