XLSX

gllm-docproc | Tutorial: XLSX Loader | Use Case: Advanced DPO Pipeline | API Reference

XLSX Loader is a component designed for extracting information from XLSX documents and converting it into a standardized JSON format.

Prerequisites

This example specifically requires completion of all setup steps listed on the Prerequisites page.

Installation

Linux, macOS, or Windows WSL

# you can use a Conda environment
pip install --extra-index-url https://oauth2accesstoken:$(gcloud auth print-access-token)@glsdk.gdplabs.id/gen-ai-internal/simple/ "gllm-docproc[xlsx]"

Windows Powershell

Windows Command Prompt

You can use the following as a sample file: xlsx-example.xlsx.

Openpyxl Loader

OpenpyxlLoader is responsible to extract Table within XLSX document.

1

Create a script called main.py:

from gllm_docproc.loader.xlsx import OpenpyxlLoader

source = "./data/source/xlsx-example.xlsx"

# initialize the OpenpyxlLoader
loader = OpenpyxlLoader()

# load the xlsx source
loaded_elements = loader.load(source)

2

Run the script:

python main.py

3

The loader will generate the following: output JSON.