title: Python : Split 1 Excel File into multiple Excel files by rows
body: <p>For example u have 1 excel file and it consist of 10000 data in it. Later when we import that excel file in pycharm or jupiter notebook. If i run that file i will get an Index range also know as Row labels.  my python code should be able to read that ten thousand row labels and should be able to separate / split  into 10 different excel sheet files which will have 1000 data in each of the 10 separated sheet.
  Other example is, if there is 9999 data in 1 sheet/file then my python code should divide 9000 data in 9 sheet and other 999 in other sheet without any mistakes.{This is important Question}</p>
  <p>i am asking this because in my data there is not any unique values for my code to split the files using .unique</p>