HI there
this is driving me nuts - i get the row count, but not the column count - what am I missing? Thanks for your help!
#include <Excel.au3>
#include <Array.au3>
#include <MsgBoxConstants.au3>
; XlDirection enumeration: https://msdn.microsoft.com/en-us/library/office/ff820880.aspxGlobal $oExcel = _Excel_Open()
Global $xlup = -4162
Global $xlByRows, $xlPrevious, $xlByColumns
Global $oExcel = _Excel_Open()
$bookname = "temp.xlsx"
$sWorkbook = @ScriptDir & "\" & $bookname
Global $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, Default, Default, True)
With $oWorkbook.ActiveSheet ; process active sheet
$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) ; get a Range that contains the last used cells
$iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count ; get the the row count for the range starting in row/column 1 and ending at the last used row/column
$iColCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Column.Count
MsgBox(0, "", "row:" & $iRowCount & "Col:" & $iColCount)
EndWith
for context - i want to :
* count columns used in excel
* create ini file from the rows in each column - finishing at the last column used - i.e. one column for one ini file; containing 15 rows or so.
is it better to read the entire sheet to an array via the sheettoarray function? then read it from that?
temp.xlsx
