Modify

Opened 17 years ago

Closed 17 years ago

#903 closed Bug (Duplicate)

_ExcelReadSheetToArray doesn't work with other MSoffice language than US

Reported by: rooversj@… Owned by:
Milestone: Component: AutoIt
Version: 3.3.0.0 Severity: None
Keywords: Cc:

Description

When the OS language or MS Office language is other than US the function _ExcelReadSheetToArray might not work correctly. Because of the letter "C" in the functioncode mentioned below. For example "Column" in Dutch is "Kolom" so when I change the "C" into "K" the function magically will work on my pc (Dutch OS en Dutch MS Office) because "lR1C1" in the Dutch version of Excel is "lR1K1".

	; Extract integer last row and col
	Local $iLastRow = StringInStr($sLastCell, "R")
	Local $iLastColumn = StringInStr($sLastCell, "C")
	$iLastRow = Number(StringMid($sLastCell, $iLastRow + 1, $iLastColumn - $iLastRow - 1))
	$iLastColumn = Number(StringMid($sLastCell, $iLastColumn + 1))

Attachments (0)

Change History (1)

comment:1 by Valik, 17 years ago

Resolution: Duplicate
Status: newclosed

Closing as duplicate of #850. A simple search for "_ExcelReadSheetToArray" would have provided results.

Modify Ticket

Action
as closed The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.