Jump to content

Recommended Posts

Posted

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.

Please help

Posted

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 or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...