Search the Community
Showing results for tags 'excel visual lisp'.
-
excel visual lisp Lisp reads excel to only 4 decimal places.
KerrCAD posted a topic in AutoLISP, Visual LISP & DCL
Am writing lsp code to process lat/lng data points. The source program writes out to xlsx. When I read in the file (many thanks to Shadi - see link below) it rounds/truncates the lat/lng data to 4 decimal places. I'd like to get as much precision as possible. Can anyone help me through this? Shadi's code starts with this: (vlax-get-object "Excel.Application.16") and reads the entire file to a list quite quickly. But I cannot find a way around the 4 decimal limit read into AutoCAD. Many Thanks! Excel source data: Lisp result (with job name deleted): -
Hi, I know how to open and edit an existing excel file from inside viaual lisp code, but am not able to create a new one:?. Has anybody any idea? Mehrdad Ahankhah
-
Hi, I know how to open and edit an existing excel file from inside viaual lisp code, but am not able to create a new one:?. Has anybody any idea:sweat:? Mehrdad Ahankhah www.irancad.com
-
Hi, I know how to open and edit an existing excel file from inside viaual lisp code, but am not able to create a new one:?. Has anybody any idea? Mehrdad Ahankhah