Python Excel Automation: Split Data Using xlwings Just Like VBA #5

In the lecture you will learn about how we can split data using xlwings just like VBA. Xlwings is one of the most popular Python package by which you can easily automate the spreadsheets and reports.

What you'll learn:

1.) Open a raw data file.
2.) Get the unique value from a specific column
3.) How to remove the duplicates values from a column?
4.) How to apply the filter?
5.) How to copy the visible cells data from Excel sheet?
6.) How to insert a sheet with specific name?
7.) How to use PasteSpecial?
8.) How to AutoFit Excel column?
8.) How to disable Cut-Copy mode?
9.) How to navigate the spreadsheet?
10.) More.....

Last Tutorial:

[anjurawat]

All vedios are very helpful to learn python .

[dhivyalakshmid]

How to filter two columns using Autofilter in xlwings?