Modify

Opened 10 years ago

Closed 10 years ago

#1937 closed Bug (No Bug)

_ExcelReadSheetToArray doesn`t work

Reported by: Tweaky Owned by:
Milestone: Component: AutoIt
Version: 3.3.6.1 Severity: None
Keywords: Cc:

Description

I use Win 7 64 bit and Office 2010 32bit.
$namen = _ExcelreadSheetToArray($oExcel, 1, 1, 10, 20) works fine. I get an array.
$namen = _ExcelreadSheetToArray($oExcel, 5, 1, 10, 20) doesn`t work.
I get @error = 3

Attachments (0)

Change History (8)

comment:1 Changed 10 years ago by Jon

You have to use 32bit autoit to access 32bit COM objects. Are you doing that?

comment:2 Changed 10 years ago by Tweaky

Öh, sorry I don`t understand you.
I use the script uncompiled.

comment:3 Changed 10 years ago by Jon

Are you running the script with AutoIt3.exe or AutoIt3_x64.exe?

comment:4 follow-up: Changed 10 years ago by Tweaky

I don`t know.
I press F5 when I am in SciTE an then the script is running

comment:5 in reply to: ↑ 4 Changed 10 years ago by Zedna

Replying to Tweaky:

I don`t know.
I press F5 when I am in SciTE an then the script is running

Copy content of output window in Scite (at bottom), there are all needed information.

comment:6 Changed 10 years ago by Jon

Try putting this at the top of your script, if it works then you were running the x64 version which can't talk to 32bit COM objects like Excel:

#AutoIt3Wrapper_UseX64=N

comment:7 Changed 10 years ago by Tweaky

@Zedna

"C:\Program Files (x86)\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.exe" /run /prod /ErrorStdOut /in "E:\test.au3" /autoit3dir "C:\Program Files (x86)\AutoIt3" /UserParams

+>19:34:24 Starting AutoIt3Wrapper v.2.0.1.24 Environment(Language:0407 Keyboard:00000407 OS:WIN_7/Service Pack 1 CPU:X64 OS:X64)

Running AU3Check (1.54.19.0) from:C:\Program Files (x86)\AutoIt3

+>19:34:24 AU3Check ended.rc:0

Running:(3.3.6.1):C:\Program Files (x86)\AutoIt3\autoit3_x64.exe "E:\test.au3"

+>19:34:47 AutoIT3.exe ended.rc:0

Exit code: 0 Time: 24.200

@Jon
the same result

comment:8 Changed 10 years ago by Jon

  • Resolution set to No Bug
  • Status changed from new to closed

You're definately running the x64 version so it's expected that this won't work. Closing the bug. Start a discussion on the forum on how to get your scripts to run using the x86 version of autoit.

Guidelines for posting comments:

  • You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
  • In-depth discussions should take place on the forum.

For more information see the full version of the ticket guidelines here.

Add Comment

Modify Ticket

Action
as closed The ticket will remain with no owner.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.