Pacote para obter tabelas xlsx do SharePoint através de seu link
Project description
BMLGRAPHAPI
Pacote para obter tabelas xlsx do SharePoint através de seu link.
Função obter_planilha()
Assinatura da função: obter_planilha(client_id, client_secret, tenant_id, planilha_url, aba_sheet=None). Retorno da função: Dataframe (pd.read_excel()).
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"
aba_da_planilha = "__NOME DA ABA__"
planilha = obter_planilha(client_id, client_secret, tenant_id, planilha_url, aba_da_planilha)
print(planilha)
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
bmlgraphapi-0.4.tar.gz
(2.7 kB
view hashes)
Built Distribution
Close
Hashes for bmlgraphapi-0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 99e1d894cf02f4f4579670490fc6cdd2ab0ebea6476712a87350a6c8b00bc723 |
|
MD5 | a416cf5698ca531c39cfbaeba3b9ff8e |
|
BLAKE2b-256 | a2184d4d8024558699122c2d1f8d2652964840259d60f898e8d90131c411b3fb |