Custom Query (3927 matches)

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))

[I:\aaa\cc\aa vv vv vv (dd).txt]
name=aa vv vv vv (dd).txt
[I:\ffff\ffff\ffff ffff ffff ffff  [ffff]\ffff\ffff.txt]
name=ffff.txt

$ini = IniReadSectionNames(@ScriptDir&"\my.ini")
_ArrayDisplay($ini)
for $x = 1 to UBound($ini)-1
ConsoleWrite($ini[$x]&@CRLF)
Next

Au3Check.exe accept many invalid scripts like:

$X = "data" _
#cs
#ce