t-office-365
Advanced tools
+1
-1
| Metadata-Version: 2.4 | ||
| Name: t_office_365 | ||
| Version: 0.1.25 | ||
| Version: 0.1.26 | ||
| Summary: An open-source Python package, t_office_365 providing easy-to-use classes and methods for interacting with Microsoft Office 365 services, including SharePoint, OneDrive, Outlook, and Excel, with features such as file management, email handling, and spreadsheet operations. | ||
@@ -5,0 +5,0 @@ Home-page: https://www.thoughtful.ai/ |
+1
-1
| [bumpversion] | ||
| current_version = 0.1.25 | ||
| current_version = 0.1.26 | ||
| commit = True | ||
@@ -4,0 +4,0 @@ tag = False |
+1
-1
@@ -31,5 +31,5 @@ #!/usr/bin/env python | ||
| url="https://www.thoughtful.ai/", | ||
| version="0.1.25", | ||
| version="0.1.26", | ||
| zip_safe=False, | ||
| install_requires=install_requirements, | ||
| ) |
| Metadata-Version: 2.4 | ||
| Name: t_office_365 | ||
| Version: 0.1.25 | ||
| Version: 0.1.26 | ||
| Summary: An open-source Python package, t_office_365 providing easy-to-use classes and methods for interacting with Microsoft Office 365 services, including SharePoint, OneDrive, Outlook, and Excel, with features such as file management, email handling, and spreadsheet operations. | ||
@@ -5,0 +5,0 @@ Home-page: https://www.thoughtful.ai/ |
@@ -5,3 +5,3 @@ """Top-level package for t-office-365.""" | ||
| __email__ = "support@thoughtful.ai" | ||
| __version__ = "0.1.25" | ||
| __version__ = "0.1.26" | ||
@@ -8,0 +8,0 @@ from .drive.excel import Excel |
@@ -5,2 +5,2 @@ """Top-level package for t_office_365/drive.""" | ||
| __email__ = "support@thoughtful.ai" | ||
| __version__ = "0.1.25" | ||
| __version__ = "0.1.26" |
@@ -282,2 +282,33 @@ """Excel class.""" | ||
| @retry_if_exception | ||
| def update_rows_value( | ||
| self, file_id: str, sheet_name: str, values: List[list[str]], start_row: int = 1, end_row: int = 1 | ||
| ) -> None: | ||
| """Update rows in Excel. | ||
| :param: | ||
| - file_id (str): The ID of the Excel file. | ||
| - sheet_name (str): The name of the sheet. | ||
| - values: The new values to be set in the row. | ||
| - start_row (int): The start row index of the sheet to update. | ||
| - end_row (int): The end row index of the sheet to update. | ||
| :raises: | ||
| - BadRequestError: If there is a bad request. | ||
| - UnexpectedError: If there is an unexpected error during the request. | ||
| """ | ||
| url = self.get_url( | ||
| workbook_api.get_row_endpoint( | ||
| drive_id=self.__drive_id, | ||
| file_id=file_id, | ||
| sheet_name=sheet_name, | ||
| start_row=start_row, | ||
| end_row=end_row, | ||
| end_column=get_column_letter(len(values[0])), | ||
| ) | ||
| ) | ||
| payload = {"values": values} | ||
| result = requests.patch(url, json=payload, headers=self.headers()) | ||
| check_result(result, f"{file_id}") | ||
| def get_last_row_number(self, file_id: str, sheet_name: str) -> int: | ||
@@ -284,0 +315,0 @@ """Get the last row number in Excel. |
@@ -5,3 +5,3 @@ """This module for t_office_365 package api endpoints.""" | ||
| __email__ = "support@thoughtful.ai" | ||
| __version__ = "0.1.25" | ||
| __version__ = "0.1.26" | ||
@@ -8,0 +8,0 @@ from t_office_365.endpoints import drive_api, mail_api, workbook_api |
Alert delta unavailable
Currently unable to show alert delta for PyPI packages.
70375
1.7%1399
2.04%