Python Program to extract data from multiple Excel Files

[@ishrathahamed6829]

Excellent Bro... Thank you so.....much. This is what I was searching for to learn and implement in my daily routine. Explained in a nut short way Appreciated, Hats off to you😊

[@AjayAnandXLnCAD]

My pleasure 😀

[@alexrosen8762]

Fantastic... Extremely useful tutorial. Thank you 🙏

[@abdullahmusheer4238]

Great video.How to load the summarized data in different columns of sqlserver table?

[@bzb23]

Amazing, from downloading the source to the results, awesome video 👍🏾

[@fateherbentah2029]

thank you very much, I have a column that contains 1700 rows with numbers. I would like to separate the numbers in this line after each 53 line then add up its lines. in a single line contains 53 line. please can you tel me how can I do this.

[@abhishekawari919]

I have an problem that having inconsistence header in multiple woeksheets and thoes header we have map then consolidate. Can you please guide on this problem statement

[@jayanthkumar8927]

Hi, If it is .csv file. how to run the code

[@dantr3302]

Hi Ajay, how to extract from excel files that stored in sub folders? For example, Each excel file stored in each sub folders but the main source folder is same. Thanks.

[@TheMaxKids]

Great tutorial!

[@souritkhamaru4393]

Hello! I am getting null values in my output excel sheet. What can I do?

[@HadiAli-m9u]

Sir i have a file i wanted to create a program i add another file for match some digits if some one match then highlights and add there new file Please guide

[@mo-xc5rv]

Hi Ajay, thanks for this nice peace of code. But I get an empty output file, I tripple checked, which cells I want to export, but yeah! No errors just an empty file🤷‍♂ Thank you

[@syedaneesdurez9880]

Pls do share more videos of doing xlookup and vlookup in python

[@Vushan108]

What if my data is in a table, but each excel file has different number of rows in the table.

[@beeaeey]

How about when I have a range of cells?

[@hartegane7202]

Ajay thank you so much for this. This is what i have been looking for! whew!! Question please. What if all the workbooks are not in uniform cell references? How do you manipulate the data?

[@nanbolkeza8296]

Good lecture Sir. Thanks so much

[@unbreakable3396]

Great video .. I hope you tech me math also : ) thanks and i have question .. How can I save this file with name from cells values ? I want for example the filename is CELL ['A2'] Is that possible ? Thanks again

[@hoangductran]

please share data input file. thanks so much

[@inbalajis1861]

Adipoli Bro ... can you post a video ... To read data from SQL and paste in Excel ... then that Excel data will be used to Excel Report

[@samaneeh7264]

Thanks

[@priyatamkamble6955]

Ajay sir You are Great. I was Looking for such a Solution. How to get in contact with you sir.

[@deepakjohnsk]

Traceback (most recent call last): File "C:/Users/DELL/Downloads/Excel Practice/Read From Excel File.py", line 2, in import openpyxl ModuleNotFoundError: No module named 'openpyxl' Please help with the error message

[@AjayAnandXLnCAD]

ModuleNotFoundError: No module named 'openpyxl' It means openpyxl module is not installed.

[@aakashniture]

​@@AjayAnandXLnCADHi Ajay, Fantastic tutorial. Great help. Just a quick question.. how do we specify which sheet to extract data from in the Excel file. There could be multiple sheets in a Excel workbook and if lets say this Student data in example is on Sheet 2, how to specify the sheet 2 in python code? Thanks in advance

[@theloudone2752]

@@AjayAnandXLnCAD but how is it not installed? I followed your process. Even on cmd it is showing that the module is installed

[@sampadetha]

Hi Ajay, first of all, well done! Today is my first time downloading, installing, and using Python. All thanks to you! I have a question. Can you do this from pdf files? So normally what I did, was convert pdf to excel, then transpose, then combine one by one, which is of course tedious. By using your Python way, I can save a lot of time, but still, I need to convert to excel. Mind you, there are hundreds of pdf which I need to convert to excel. Do you have a good solution to this? Again, many thanks!

[@AjayAnandXLnCAD]

Of course, we can extract data from PDF files using Python. Refer 'Al Sweigart's Automate the boring stuff with Python'

[@kavithapriyacj4868]

U are a malayali right.❤❤❤

[@Ryuken2721]

hi, how do i choose which sheet to execute from source file?

[@aakashniture]

Second that.

[@mohamedjamsheerk137]

how to extract excel datas to OPCUA using python

[@gamehub8068]

सर मेरे पास 4 लाख रो के 4 शीट है मुझे चारो शीट को कम्पाइल कर के pivot table बनाना है कैसे होगा??🙏🙏🙏