Python Forum
Excel: Apply formating of a sheet(file1) to another sheet(file2)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel: Apply formating of a sheet(file1) to another sheet(file2)
#1
Hello!

Does python offers the possibility of applying the formatting style from a sheet (from file1) to another sheet(from file2). I would like to this without opening the file and just apply the "format painter" or without trying using macros or VBA s.

This can be done by python or do I need to install additional plugins/add-ons?
Reply
#2
(May-26-2020, 07:00 AM)lowermoon Wrote: I would like to this without opening the file
How do you expect to read from and write to a file without opening the source and target files? By opening I don't mean starting excel application...
There are plenty of packages to work with excel files. It may depend on file format - xls or xlsx.
For example - relevant section in openpyxl documentation - Working with styles
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  propper formating paracelsusx 2 256 Jul-16-2021, 09:17 AM
Last Post: perfringo
  Python script for excel sheet Nabil 5 443 Jun-01-2021, 02:29 PM
Last Post: anuradha
  IF statement to apply at each date illmattic 2 765 Apr-08-2021, 12:31 PM
Last Post: illmattic
  Add a new column when I extract each sheet in an Excel workbook as a new csv file shantanu97 0 457 Mar-24-2021, 04:56 AM
Last Post: shantanu97
  Append excel sheet using openpyxl TammyP 1 483 Feb-02-2021, 06:32 PM
Last Post: nilamo
  Adding graph points and formating project_science 4 528 Jan-24-2021, 05:02 PM
Last Post: project_science
  Function won't apply dynamically in timeseries illmattic 1 379 Jan-08-2021, 03:15 PM
Last Post: stullis
  How to Copy Single Value From One Excel Sheet to Another SunWers 4 674 Dec-29-2020, 05:39 PM
Last Post: SunWers
Question Python + Google Sheet | Best way to update specific cells in a single Update()? Vokofe 1 498 Dec-16-2020, 05:26 AM
Last Post: Vokofe
  Writing to existing excel sheet jksvend 0 498 Oct-12-2020, 11:19 AM
Last Post: jksvend

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020