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 in Python by M
• 160 points
26 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by Omkar
• 66,050 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 in Python by Nymeria
• 3,500 points
203 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 in Python by Mohammad
• 1,400 points
8 views
0 votes
0 answers

Excel attachments inside another Excel file handling?

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

Mar 22 in Python by M
• 160 points
13 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,580 points
56 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,420 points
43 views
+2 votes
3 answers

How can I play an audio file in the background using Python?

down voteacceptedFor windows: you could use  winsound.SND_ASYNC to play them ...READ MORE

answered Apr 3, 2018 in Python by charlie_brown
• 7,710 points
958 views
+2 votes
2 answers

How to use BeatifulSoup for webscraping?

your programme is fine until you start ...READ MORE

answered Apr 4, 2018 in Python by charlie_brown
• 7,710 points
16 views
+1 vote
5 answers

Check whether the file exists or not?

Use this import os os.path.exists(path) # Returns whether the ...READ MORE

answered Oct 18, 2018 in Python by reyam
59 views
0 votes
1 answer

Permission denied for .pyc file

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

answered Feb 7 in Python by Omkar
• 66,050 points
39 views
0 votes
1 answer

Python convert XLS and XLSX file to csv

You can't convert the files with both ...READ MORE

answered Feb 8 in Python by Omkar
• 66,050 points
622 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.