formatting info true for xlsx file handling

0 votes
I would like modify without loosing data of one xlsx file which has charts, table formats, attachments.

Thank you in advance

Babu Mamidi
Mar 18, 2019 in Python by M
• 160 points
246 views

1 answer to this question.

0 votes

There are 2 libraries used to handle excel files in python: openpyxl and xlsxwriter

But you can not use either directly because xlsxwriter does not support modifying existing xlsx files and if you use openpyxl you will lose the charts. The workaround is to convert the xlsx file to xls file and modify it. 

answered Mar 19, 2019 by Omkar
• 69,130 points
Thank you for your response, now i am to handle xlsx file without loosing graphs, Table format. Previously i am getting error while file saving due to comments inside some cells. when removed comments in all cells by VB. now i am able to do my tasks.
Glad to be of help :)

Related Questions In Python

0 votes
1 answer

Need help extracting a schema to make use for an avro file in Python

Hi, nice question. So what I daily use ...READ MORE

answered Jan 10, 2019 in Python by Nymeria
• 3,520 points
2,080 views
0 votes
1 answer

how to check for exceptions in a file?

try { if (!file.exists("TextFile1.txt")) throw ...READ MORE

answered Mar 20, 2019 in Python by Mohammad
• 3,210 points
68 views
0 votes
0 answers

Excel attachments inside another Excel file handling?

Thank you in advance. I would like open ...READ MORE

Mar 22, 2019 in Python by M
• 160 points
85 views
0 votes
2 answers

How do you read from a file using file handling in python?

for write, read,append data in file check ...READ MORE

answered Jun 21, 2020 in Python by sahil
• 540 points
208 views
0 votes
0 answers

How to handle large files using file handling in python?

I have used file handling for smaller ...READ MORE

Aug 2, 2019 in Python by Waseem
• 4,540 points
124 views
0 votes
1 answer

python code for fall detection of a video file

Hello @Aruna, You can refer this for your ...READ MORE

answered Dec 2, 2020 in Python by Niroj
• 82,540 points
40 views
+3 votes
7 answers

How can I rename a file in Python?

yes, you can use "os.rename" for that. ...READ MORE

answered Mar 31, 2018 in Python by DareDev
• 6,890 points
11,755 views
+2 votes
2 answers

How can I create a new file in Python?

You can try the below code which ...READ MORE

answered Mar 31, 2018 in Python by anto.trigg4
• 3,440 points
364 views
0 votes
1 answer

Permission denied for .pyc file

Did you run the python script as ...READ MORE

answered Feb 7, 2019 in Python by Omkar
• 69,130 points
895 views
+1 vote
2 answers

Python convert XLS and XLSX file to csv

XLSX tables are usually created in MS ...READ MORE

answered Aug 30, 2019 in Python by Mian Tanzeel
11,588 views