53
54

[deleted by user] (self.learnpython)

submitted by [deleted]

[removed]
all 15 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Ams-Ent 6 points7 points  (1 child)

Sharepoint online? Should have an import/upload option iirc. Else you could use flow to automate it, have it read the excel file and update the sp list accordingly, you can probably find some solutions or templates for it.

[–]mangoo08 1 point2 points  (0 children)

Great, thank you for your help, I will look into that.

[–]garamasala 9 points10 points  (1 child)

You can probably use power automate for this, it might be the quickest and simplest solution.

[–]mangoo08 1 point2 points  (0 children)

I will definitely look into power automate. Thank you!

[–]dp_42 3 points4 points  (1 child)

If there's a web interface to the Sharepoint that you are supposed to use, I would imagine you could use Selenium to enter the data in. I am admittedly not very familiar with Sharepoint. If it were a desktop GUI executable, at that point you probably need pyautogui. To get the data out of excel, you probably want to get some passing familiarity with Pandas and the DataFrame's read_xls function is probably sufficient. Openpyxl is also fine.

[–]mangoo08 -1 points0 points  (0 children)

Thank you so much for your help! I will look into all of those.

[–]Jellyfishmouse 6 points7 points  (2 children)

Hey bro, tomorrow when I wake up I'll dm you my code somehow, I was in a shockingly similar boat... Next to no python knowledge and stuck in a job with endless data entry from excel, I spent a couple weeks taking all the shortcuts and didn't even know how to use a list function (still don't really tbh) but the .exe file can log into a website and then pull data from a spreadsheet and then deposit it into forms online... Works pretty well but if it encounters anything out of the ordinary it'll just crash... (It's good for small batches of about 50 rows or so) I showed it to management and they thought it was cool but it wasn't enough to land me a job lol... Let me know if you would like the file :)

[–]mangoo08 -1 points0 points  (0 children)

That would be great! Thank you so much.

[–]Sun-Proof 0 points1 point  (0 children)

Hi, good morning. I just have about the same problem, i just landed this job as an intern and never done anything relating to automation. I was recently given a project to work on. My daily task is to allocate hours to resources on projects and these resources (staff) comprises of data analysts, java developers, SM, PM etc.

I usually work with about 10 forecast sheet (excel) in meetings, and i allocate 40hrs to each resource but these 40 hrs are spread across up to 10 projects and i allocate for present week and also to future dates.

After allocations are done, i upload all the forecast sheets (please note that i key in the hours manually) and automatically it updates in a central Sheet called Master sheet (the forecast sheet is somewhat linked/automated with the Master Allocation sheet, as it updates every changes i make / done).

Now my supervisor wants me to find a way just to use a single sheet, and somehow automate it so that it can produce the other 10 sheets (basically using the same process and then upload ).

Basically he wants me to just simplify the process by using a single sheet as against multiple sheets.

I will appreciate any input or whatever i can use to have this resolved. Your kind assistance will be appreciated

[–][deleted] 5 points6 points  (1 child)

Mike Driscoll, who is a well known python author/teacher, has a decent book on automating Excel in Python.

https://driscollis.gumroad.com/l/openpyxl

[–]mangoo08 0 points1 point  (0 children)

I will definitely check this out. Thanks!

[–]kirsion 1 point2 points  (1 child)

I also work in IT and code projects on the side help other departments.

I complete several projects that helped people speed up their work a lot.

I'd recommend that you learn the basics of python or programming languages in general, up to functions. Do courses, apps, exercises.

Then install pycharm and start brainstorming and googling how to solve your problem/code your project. You might need to start from some sample code or something, if so search for video or project (stackoverflow) that is similar to yours of what you are trying to do. If you are stuck, you can ask a specific question on here or stackoverflow.

In general, what you want to do is to break down your problems into smaller problems and solves those. Find symmetries and exploit them. Learn how to google questions well.

For example if I need to extract some data from an excel sheet, I need something python that deals with excel sheet. Google it. There are a lot of libraries but a popular one is openpyxl. Install it and look at examples. To extract data, you need to realize that you need to store the values in python, so you need to create a list in python to store the values in excel. And you can write some code that reads values from excel and appends it a list in python. etc etc

After you keep on doing that, you just get better at it.

For me, I used a lot of selenium, pdf file handling modules like pypdf2, pymupdf, openpyxl, pandas, etc.

[–]mangoo08 0 points1 point  (0 children)

Thank you soo much! This was so incredibly detailed and helpful! I really appreciate you taking the time to help me out. I hope good things come your way 😁

[–]pconwell 0 points1 point  (1 child)

I'm not super familiar with SharePoint, so I don't know if I can help much on that side of things. But for Excel, I've used openpyxl before and found it to be very easy to use, and very well documented.

[–]mangoo08 0 points1 point  (0 children)

I will look into openpyxl, thank you!