Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Read data and save in excel
#1
I am having a website which contains buy/sell information of multiple distributor, for each distributor i need to choose the invoice date say for a period of one month and download data.

For that i am having userid & password for each distributor so that i can download each distributor data seperately. this is by design and we are using it as this is third party website. The result will be displayed in columns & rows and if we want to download it as excel/csv options are there with button as "export to".
Is there a way to dowload the files as csv /.xlsx with my information using python.

will python access the userid and password from an xml file/ any prescribed and login to the website and navigate to reports and then filter and then download ?

why this requirement is to automate the process as we have more than 1K distributors, in-order to minimize the manual work.
Will Python can help me ?
is there are any relevant links available to do this kind ?
If so can it be shared here
Appreciate all of your help in this regard!!
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with to check an Input list data with a data read from an external source sacharyya 3 396 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  how to save to multiple locations during save cubangt 1 542 Oct-23-2023, 10:16 PM
Last Post: deanhystad
  Copy data from Excel and paste into Discord (Midjourney) Joe_Wright 4 2,033 Jun-06-2023, 05:49 PM
Last Post: rajeshgk
  Reading data from excel file –> process it >>then write to another excel output file Jennifer_Jone 0 1,088 Mar-14-2023, 07:59 PM
Last Post: Jennifer_Jone
  Pymodbus read and save to database stewietopg 3 1,853 Mar-02-2023, 09:32 AM
Last Post: stewietopg
  Save and Close Excel File avd88 0 3,008 Feb-20-2023, 07:19 PM
Last Post: avd88
  Correctly read a malformed CSV file data klllmmm 2 1,924 Jan-25-2023, 04:12 PM
Last Post: klllmmm
  how to read txt file, and write into excel with multiply sheet jacklee26 14 9,894 Jan-21-2023, 06:57 AM
Last Post: jacklee26
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,872 Dec-12-2022, 08:22 PM
Last Post: jh67
  Trying to Get Arduino sensor data over to excel using Python. eh5713 1 1,695 Dec-01-2022, 01:52 PM
Last Post: deanhystad

Forum Jump:

User Panel Messages

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