Metadata-Version: 2.1
Name: brenda_teste
Version: 0.3
Summary: A small example package
Author-email: Example Author <author@example.com>
Project-URL: Homepage, https://github.com/pypa/sampleproject
Project-URL: Issues, https://github.com/pypa/sampleproject/issues
Classifier: Programming Language :: Python :: 3
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Requires-Python: >=3.8
Description-Content-Type: text/markdown

# BMLGRAPHAPI

Pacote para obter tabelas xlsx do SharePoint através de seu link.

# Exemplo de uso
```
import pandas as pd
from main import obter_planilha

client_id = "__TOKEN__"
client_secret = "__TOKEN__"
tenant_id = "__TOKEN__"
planilha_url = "https://xyz.sharepoint.com/sites/${SITE}/${DRIVE}/NOME_DA_TABELA.xlsx"

workbook = obter_planilha(client_id, client_secret, tenant_id, planilha_url)

aba = "NOME DA ABA"

print('Lendo a tabela:', aba)

linhas = workbook[aba].values
colunas = next(linhas)

planilha = pd.DataFrame(linhas, columns=colunas)

print(planilha)
```
