# ExcelCom.au3 Problem with reading large Numbers

## Recommended Posts

Hello guys....

I am making a little program that is pulling some data from a xls table, and pasting it in a tool that we use at work. some of the numbers are big ( they do not represent money buy just customer purchese numbers and things like that.

To do the job I am using ExcelCom.au3 .

The thing is that it reads large numbers wrong. for example 5000286310 is read 5000286208 if it is a number, and 5000286310 if it is text.

Now I also get a very strange error, after twinking the script and xls files for some time...

>"C:\Program Files\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.exe" /run /beta /ErrorStdOut /in "C:\Bogdan\scripting\table pull test.au3" /autoit3dir "C:\Program Files\AutoIt3\beta" /UserParams
+> Starting AutoIt3Wrapper v.1.7.3
>Running AU3Check (1.54.4.0)  params:  from:C:\Program Files\AutoIt3\beta
+>AU3Check ended.rc:0
>Running:(3.2.1.3):C:\Program Files\AutoIt3\beta\autoit3.exe "C:\Bogdan\scripting\table pull test.au3"
C:\PROGRA~1\AutoIt3\beta\Include\ExcelCom.au3 (212) : ==> The requested action with this object has failed.:
If $s_i_Sheet >$oExcel.Worksheets.count Then $s_i_Sheet =$oExcel.Worksheets.count
If $s_i_Sheet >$oExcel.Worksheets^ ERROR
+>AutoIT3.exe ended.rc:0
>Exit code: 0   Time: 1.836

Does anyone know what to do? I have already reinstalled autoit several times, and still get the same error.. and all worked fine until 15 minutes ago.

##### Share on other sites

Very strange, after I rebooted the computer everything seems to be fine, the number is read fine to, ... still very strange thing/ error.

Do not really know how I could reproduce this bug in autoit/SciTE ... happened to be before one time... hope you guys will find how/why it is and fix it.

## Create an account

Register a new account