scautable
API
Generated with
scautable/io.github.quafadas/io.github.quafadas.scautable/ExcelUtils

ExcelUtils

io.github.quafadas.scautable.ExcelUtils
object ExcelUtils

Common utilities and exceptions for Excel processing

Attributes

Graph
Supertypes
class Object
trait Matchable
class Any
Self type
ExcelUtils.type

Members list

Value members

Concrete methods

inline def extractHeaders(filePath: String, sheetName: String, colRange: Option[String]): List[String]

Extracts headers from an Excel sheet, either from a specific range or the first row

Extracts headers from an Excel sheet, either from a specific range or the first row

Value parameters

colRange

Optional range specification (e.g., "A1:C10")

filePath

Path to the Excel file

sheetName

Name of the sheet

Attributes

Returns

List of header strings

inline def parseRange(range: String): (Int, Int, Int, Int)

Parses a cell range string into its components

Parses a cell range string into its components

Value parameters

range

Excel range string (e.g., "A1:C10")

Attributes

Returns

Tuple of (firstRow, lastRow, firstColumn, lastColumn)

inline def validateUniqueHeaders(headers: List[String]): Unit

Validates that headers are unique (no duplicates)

Validates that headers are unique (no duplicates)

Value parameters

headers

List of header strings to validate

Attributes

Throws
BadTableException

if duplicate headers are found

Generated with