SpreadsheetGetColumnCount

Gets the number of columns in a worksheet.

Method Signature

SpreadsheetGetColumnCount(spreadsheetObj=[any], sheetName=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
sheetName	STRING	false	The name of the sheet. If not specified, uses the active sheet.

Examples

Get the number of columns:

// Get column count
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRow( spreadsheet, [ "A", "B", "C", "D" ] );
var colCount = SpreadsheetGetColumnCount( spreadsheet );
println( "Columns: " & colCount );  // Output: 4

Loop through all columns:

// Process all columns
var spreadsheet = SpreadsheetRead( "/path/to/file.xlsx" );
var colCount = SpreadsheetGetColumnCount( spreadsheet );

for ( var col = 1; col <= colCount; col++ ) {
    var value = SpreadsheetGetCellValue( spreadsheet, 1, col );
    println( "Column " & col & ": " & value );
}

Related

• SpreadsheetGetLastRowNumber() - Get last row

• SpreadsheetInfo() - Get spreadsheet info

• SpreadsheetGetColumnWidth() - Get column width