Issues in Preserving Formulas and Formats in Excel Files Using openpyxl

[NastaranAhadian]

Problem Description:

When using the openpyxl library to process Excel files, we encounter issues in preserving existing formulas and formats. These problems occur during sheet deletion, number entry, and even reading data in read-only mode.

Steps to Reproduce the Problems:

1.  Sheet Deletion Issue:
•   Open an Excel file with specific formulas and formats.
•   Delete a sheet using openpyxl.
•   Save the file.
•   Open the new file and notice changes in formulas and formats.
2.  Number Entry Issue:
•   Open an Excel file with specific formulas and formats.
•   Enter new numbers in the file.
•   Save the file.
•   Open the new file and notice changes in formulas and formats.
3.  Read-Only Mode Issue:
•   Open an Excel file in read-only mode.
•   Attempt to read data.
•   Notice issues accessing tables and data.

Expected Outcome:

Formulas and formats in the Excel file should remain unchanged.

Current Outcome:

Formulas and formats in the Excel file are altered or lost.

Environment Used:

•   openpyxl library
•   Version: [Specify the version used]

Suggestions and Requests:

1.  Investigate and fix the openpyxl library to accurately preserve formulas and formats.
2.  Provide alternative solutions for maintaining data integrity.

Contact Information:

nastaran_ahadian@yahoo.com

[NastaranAhadian]

im still waiting for your reply