TheSwamp
Code Red => AutoLISP (Vanilla / Visual) => Topic started by: Lee Mac on August 20, 2009, 12:57:50 PM
-
I keep getting the above error when trying to read data from an Excel Spreadsheet, but I do not know what is causing the error, as I have run my program on other spreadsheets and all seems fine.
Have any of you experienced this?
Thanks,
Lee
-
Hi
The simplest is to provide an example.
@+
-
Hi
The simplest is to provide an example.
@+
Thank you for your response Patrick.
I have recently found that this error occurs when reading a cell that contains an invalid formula, and have resolved the issue.
Thanks,
Lee
-
Hi Lee, Just now (12 years after you sent this post :2funny:) I found that this error occures when an "Excel" cell is containing a numeric value with a "point" as "period".
AFAIK it is not Excel related problem. It is due to "Windows" settings when "/" is assigned to "Decimal Symbol".
Enclosed Clip shows how I got rid of the error. But I don't know why this incompatibility occures. When using "/" to write a decimal number like1.5 obviously it must be typed as: 1/5, but surprisingly Excel changes that to 0/2 (It divides 1 to 5).
I am sure you can write a Visual LISP code to solve this problem automatically.