We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Hi,
openpyxl==2.6.1
bloodhoundanalytics.py
def save_workbook(self): for worksheet in self.workbook._sheets: for col in worksheet.columns: max_length = 0 column = col[0].column # Get the column name for cell in col: try: # Necessary to avoid error on empty cells if len(str(cell.value)) > max_length: max_length = len(cell.value) except: pass adjusted_width = (max_length + 2) * 1.2 worksheet.column_dimensions[column].width = adjusted_width self.workbook.save("BloodHoundAnalytics.xlsx")
This line column = col[0].column # Get the column name returns the column number (1, 2, ...) instead of its name.
column = col[0].column # Get the column name
Use from openpyxl.utils import get_column_letter to get the column's letter
from openpyxl.utils import get_column_letter
A pull request was made
The text was updated successfully, but these errors were encountered:
5332e44
Merge pull request #9 from Hackndo/master
2736a03
Fix #5 Column is an INT instead of a STRING
No branches or pull requests
Hi,
Version
openpyxl==2.6.1
File
bloodhoundanalytics.py
Error
This line
column = col[0].column # Get the column name
returns the column number (1, 2, ...) instead of its name.Recommandation
Use
from openpyxl.utils import get_column_letter
to get the column's letterFix
A pull request was made
The text was updated successfully, but these errors were encountered: