Python Forum
Copy xlsx cell format into data frame or table
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Copy xlsx cell format into data frame or table
#1
Hello,

Is there a way to copy excel cell data format into python.
Cell format for example, in a cell some words are bold while others are link.

Are there any packages to do this ?

Please advise
Reply
#2
use pandas.read_excel(filename, sheetname)
Reply
#3
Larz60+,

wow, I am new to python. Does that really work.
Could you provide a simple code example ?

We’re talking about the same format in excel cell into python.

Thanks
Reply
#4
see: https://pandas.pydata.org/pandas-docs/st...excel.html
basic syntax is as shown in previous post
Reply
#5
(Aug-30-2019, 11:16 AM)Larz60+ Wrote: use pandas.read_excel(filename, sheetname)

That’s amazing to know.

(Aug-30-2019, 04:09 PM)Larz60+ Wrote: see: https://pandas.pydata.org/pandas-docs/st...excel.html basic syntax is as shown in previous post

I use the basic syntax, I don’t think it uploads
the same format as the excel file.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  the data format i am designing with indentation Skaperen 7 3,041 Mar-15-2020, 09:50 PM
Last Post: Skaperen
  which format to use .csv or .xlsx or .txt garikhgh0 1 3,618 Apr-10-2018, 07:12 AM
Last Post: garikhgh0

Forum Jump:

User Panel Messages

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