Package com.leumanuel.woozydata.util

Class DataXlsxReader

java.lang.Object

com.leumanuel.woozydata.util.DataXlsxReader

public class DataXlsxReader
extends Object

Utility class for reading Excel (XLSX) files into DataFrame objects. Uses Apache POI for Excel file parsing.

Version:

1.0

Author:

Leu A. Manuel

Constructor Summary

Constructors

Constructor	Description
DataXlsxReader()

Method Summary

Modifier and Type	Method	Description
static DataFrame	readXLSX(String filePath)	Reads an Excel file and converts it to a DataFrame.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

DataXlsxReader

public DataXlsxReader()

Method Details

readXLSX

public static DataFrame readXLSX(String filePath)
                          throws Exception

Reads an Excel file and converts it to a DataFrame. Assumes first row contains headers and reads from first sheet. Supports string, numeric, and boolean cell types.

Parameters:

filePath - Path to the Excel file to read

Returns:

DataFrame containing the Excel data

Throws:

Exception - if there is an error reading or parsing the file