Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Data in excel
#1
Hello,

I am new to python so apologies advance if this question doesn’t make sense.

I have an excel file that has 2 sheets.

Sheet 1 is where the formulas are and sheet 2 is where the raw data is.

Can someone point me in the right direction as to how I can automatically get the raw data for each day put it into the formulas record the output to a separate sheet then move on to the raw data for the next day and keep repeating the process until all the raw has been put into the formula and the output recorded.

I would like if someone can point me in the right direction and if possible give me some code that I can modify for my application.

Thanks in advance.
Quote
#2
openpyxl is the go-to package for working with excel files in python. https://openpyxl.readthedocs.io/en/stable/

If you could share a sample doc, with some forumulas, and two or three lines of sample data, we could maybe help out more. But that package is definitely a good starting point, as it allows you to read values, create new sheets, and save the edited excel doc.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to import data from database to excel nick123 1 319 Oct-09-2019, 04:39 PM
Last Post: sm51251
  Import data from excel to Teradata steve87bg 3 673 Sep-18-2019, 01:36 PM
Last Post: steve87bg
  Dictionary for Excel Data Ranjirock 0 362 Aug-18-2019, 05:26 PM
Last Post: Ranjirock
  iterate read data from excel sheet jp2017 1 366 Jun-19-2019, 07:45 PM
Last Post: micseydel
  Python validate excel values data types Useruser00 0 684 Apr-08-2019, 01:29 PM
Last Post: Useruser00
  data from excel mida1 0 521 Oct-12-2018, 02:02 PM
Last Post: mida1
  Read data and save in excel parthi1705 0 637 Apr-09-2018, 09:37 AM
Last Post: parthi1705
  Reading data from password protected excel Anirudh_Avantsa 2 8,894 Apr-04-2018, 03:26 PM
Last Post: nilamo
  Renaming PDF files using Excel data - Python okanaira 4 1,709 Mar-20-2018, 07:31 PM
Last Post: okanaira
  Excel Filter and copy data by python ls_01 0 817 Mar-19-2018, 03:17 PM
Last Post: ls_01

Forum Jump:


Users browsing this thread: 1 Guest(s)