Buckets:
| """Functionality for working with Microsoft Office.""" | |
| import os | |
| def excel_chart_to_image( | |
| input_fpath: str, | |
| output_fpath: str, | |
| sheet: int = 1, | |
| chart_index: int = 0, | |
| ): | |
| """Export a chart from an Excel sheet to image.""" | |
| import win32com.client | |
| from PIL import ImageGrab | |
| # Open the excel application using win32com | |
| excel = win32com.client.Dispatch("Excel.Application") | |
| # Disable alerts and visibility to the user | |
| excel.Visible = 0 | |
| excel.DisplayAlerts = 0 | |
| # Open workbook | |
| wb = excel.Workbooks.Open(os.path.abspath(input_fpath)) | |
| # Extract sheet | |
| # TODO: Close workbook if something fails | |
| sheet = excel.Sheets(sheet) | |
| shape = sheet.Shapes[chart_index] | |
| shape.Copy() | |
| image = ImageGrab.grabclipboard() | |
| # Check if we need to change the mode of the image | |
| _, ext = os.path.splitext(output_fpath) | |
| if ( | |
| ext in [".jpg", ".eps", ".tiff", ".gif", ".bmp"] | |
| and image.mode != "RGB" | |
| ): | |
| image = image.convert("RGB") | |
| # Save the image, overwriting if exists | |
| dirname = os.path.dirname(output_fpath) | |
| if dirname and not os.path.isdir(dirname): | |
| os.makedirs(dirname) | |
| image.save(os.path.abspath(output_fpath), quality=95, dpi=(300, 300)) | |
| wb.Close(True) | |
| excel.Quit() | |
Xet Storage Details
- Size:
- 1.29 kB
- Xet hash:
- c2bdbf6082fab42765948c4c8f9d7daf90ab6222f051461c2fc7fadfdd5bbc11
·
Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.