Skip to content

Document

Excel, PDF, and Word document read/write/convert.

8 modules

ModuleDescription
Ler ExcelLer dados de arquivos Excel (xlsx, xls)
Escrever ExcelEscrever dados em arquivos Excel (xlsx)
Preencher Formulario PDFPreencher campos de formulario PDF com dados e opcionalmente inserir imagens
Gerar PDFGerar arquivos PDF a partir de conteudo HTML ou texto
Analisar PDFExtrair texto e metadados de arquivos PDF
PDF para WordConverter arquivos PDF para documentos Word (.docx)
Analisar Documento WordExtrair texto e conteudo de documentos Word (.docx)
Word para PDFConverter documentos Word (.docx) para arquivos PDF

Modules

Ler Excel

excel.read

Ler dados de arquivos Excel (xlsx, xls)

Parameters:

NameTypeRequiredDefaultDescription
pathstringYes-Path to the Excel file
sheetstringNo-Sheet name (default: first sheet)
header_rownumberNo1Row number for headers (1-based, 0 for no headers)
rangestringNo-Cell range to read (e.g., "A1:D10")
as_dictbooleanNoTrueReturn rows as dictionaries (using headers as keys)

Output:

FieldTypeDescription
dataarrayLinhas de dados extraidas
headersarrayLinhas de dados extraidas
row_countnumberLinhas de dados extraidas
sheet_namesarrayCabecalhos das colunas

Example: Read entire sheet

yaml
path: /tmp/data.xlsx
as_dict: true

Escrever Excel

excel.write

Escrever dados em arquivos Excel (xlsx)

Parameters:

NameTypeRequiredDefaultDescription
pathstringYes-Path to the Excel file
dataarrayYes-Data to write (array of arrays or array of objects)
headersarrayNo-Column headers (auto-detected from objects if not provided)
sheet_namestringNoSheet1Name of the worksheet
auto_widthbooleanNoTrueAutomatically adjust column widths

Output:

FieldTypeDescription
pathstringCaminho para o arquivo Excel criado
row_countnumberCaminho para o arquivo Excel criado
sizenumberCaminho para o arquivo Excel criado

Example: Write data to Excel

yaml
path: /tmp/output.xlsx
data: [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]

Preencher Formulario PDF

pdf.fill_form

Preencher campos de formulario PDF com dados e opcionalmente inserir imagens

Parameters:

NameTypeRequiredDefaultDescription
templatestringYes-Path to the PDF template file
outputstringYes-Path for the output document
fieldsobjectNo{}Key-value pairs of form field names and values
imagesarrayNo[]List of images to insert with position info
flattenbooleanNoTrueFlatten form fields (make them non-editable)

Output:

FieldTypeDescription
output_pathstringCaminho para o PDF preenchido
fields_fillednumberCaminho para o PDF preenchido
images_insertednumberCaminho para o PDF preenchido
file_size_bytesnumberNumero de imagens inseridas

Example: Fill form with text fields

yaml
template: /templates/form.pdf
output: /output/filled.pdf
fields: {"name": "John Doe", "id_number": "A123456789", "date": "2024-01-01"}

Example: Fill form with photo

yaml
template: /templates/id_card.pdf
output: /output/id_card_filled.pdf
fields: {"name": "Jane Doe"}
images: [{"file": "/photos/jane.jpg", "page": 1, "x": 50, "y": 650, "width": 100, "height": 120}]

Gerar PDF

pdf.generate

Gerar arquivos PDF a partir de conteudo HTML ou texto

Parameters:

NameTypeRequiredDefaultDescription
contentstringYes-HTML or text content to convert to PDF
output_pathstringYes-Path for the output document
titlestringNo-Document title (metadata)
authorstringNo-Document author (metadata)
page_sizeselect (A4, Letter, Legal, A3, A5)NoA4Page size format
orientationselect (portrait, landscape)NoportraitPage orientation
marginnumberNo20Page margin in millimeters
headerstringNo-Header text for each page
footerstringNo-Footer text for each page

Output:

FieldTypeDescription
output_pathstringCaminho para o PDF gerado
page_countnumberCaminho para o PDF gerado
file_size_bytesnumberNumero de paginas no PDF

Example: Generate from HTML

yaml
content: <h1>Report</h1><p>Content here</p>
output_path: /path/to/report.pdf
title: Monthly Report

Analisar PDF

pdf.parse

Extrair texto e metadados de arquivos PDF

Parameters:

NameTypeRequiredDefaultDescription
pathstringYes-Path to the PDF file
pagesstringNoallPage range (e.g., "1-5", "1,3,5", or "all")
extract_imagesbooleanNoFalseExtract embedded images
extract_tablesbooleanNoFalseExtract tables as structured data

Output:

FieldTypeDescription
textstringConteudo de texto extraido
pagesarrayConteudo de texto extraido
metadataobjectConteudo de texto extraido
page_countnumberConteudo de texto por pagina

Example: Extract all text from PDF

yaml
path: /tmp/document.pdf
pages: all

PDF para Word

pdf.to_word

Converter arquivos PDF para documentos Word (.docx)

Parameters:

NameTypeRequiredDefaultDescription
input_pathstringYes-Path to the input document
output_pathstringNo-Path for the output document
preserve_formattingbooleanNoTruePreserve basic formatting
pagesstringNoallPage range (e.g., "1-5", "1,3,5", or "all")

Output:

FieldTypeDescription
output_pathstringCaminho para o documento Word gerado
page_countnumberCaminho para o documento Word gerado
file_sizenumberNumero de paginas convertidas

Example: Convert entire PDF to Word

yaml
input_path: /tmp/document.pdf

Example: Convert specific pages

yaml
input_path: /tmp/document.pdf
output_path: /tmp/output.docx
pages: 1-5

Analisar Documento Word

word.parse

Extrair texto e conteudo de documentos Word (.docx)

Parameters:

NameTypeRequiredDefaultDescription
file_pathstringYes-Path to the Word document (.docx)
extract_tablesbooleanNoTrueExtract tables as structured data
extract_imagesbooleanNoFalseExtract embedded images
images_output_dirstringNo-Directory to save extracted images
preserve_formattingbooleanNoFalsePreserve basic formatting

Output:

FieldTypeDescription
textstringConteudo de texto completo do documento
paragraphsarrayConteudo de texto completo do documento
tablesarrayConteudo de texto completo do documento
imagesarrayLista de paragrafos
metadataobjectTabelas extraidas como arrays

Example: Extract text from Word

yaml
file_path: /path/to/document.docx

Example: Extract with tables and images

yaml
file_path: /path/to/document.docx
extract_tables: true
extract_images: true
images_output_dir: /path/to/images/

Word para PDF

word.to_pdf

Converter documentos Word (.docx) para arquivos PDF

Parameters:

NameTypeRequiredDefaultDescription
input_pathstringYes-Path to the input document
output_pathstringNo-Path for the output document
methodselect (auto, libreoffice, docx2pdf)NoautoMethod to use for conversion

Output:

FieldTypeDescription
output_pathstringCaminho para o arquivo PDF gerado
file_sizenumberCaminho para o arquivo PDF gerado
method_usedstringTamanho do arquivo de saida em bytes

Example: Convert Word to PDF

yaml
input_path: /tmp/document.docx

Example: Convert with specific output path

yaml
input_path: /tmp/document.docx
output_path: /tmp/output.pdf

Released under the Apache 2.0 License.