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?
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.
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😊
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.
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
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
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
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
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
@@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
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!
![[#2024MAMA] ROSÉ (로제), Bruno Mars - APT. | Mnet 241122 방송](http://i.ytimg.com/vi/dgGqD28J6aQ/mqdefault.jpg)
![[LIVE] : ONE ลุมพินี 88 | คู่เอก "ป้อมเพชร vs อัสลามจอน"](http://i.ytimg.com/vi/1ZqTVVbMgbo/mqdefault.jpg)
Fantastic... Extremely useful tutorial. Thank you 🙏
Amazing, from downloading the source to the results, awesome video 👍🏾
Great tutorial!
Good lecture Sir. Thanks so much
Great video.How to load the summarized data in different columns of sqlserver table?
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?
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.
Hi, If it is .csv file. how to run the code
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😊
My pleasure 😀
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.
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
Hello! I am getting null values in my output excel sheet. What can I do?
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
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
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
Pls do share more videos of doing xlookup and vlookup in python
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
please share data input file. thanks so much
What if my data is in a table, but each excel file has different number of rows in the table.
Thanks
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
ModuleNotFoundError: No module named 'openpyxl'
It means openpyxl module is not installed.
@@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
hi, how do i choose which sheet to execute from source file?
Second that.
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!
Of course, we can extract data from PDF files using Python. Refer 'Al Sweigart's Automate the boring stuff with Python'
how to extract excel datas to OPCUA using python
U are a malayali right.❤❤❤
सर मेरे पास 4 लाख रो के 4 शीट है मुझे चारो शीट को कम्पाइल कर के pivot table बनाना है कैसे होगा??🙏🙏🙏