Creating csv files from Excel file

[Larz60+]

Thanks dean for format:
I only created an excel file with sheet1:
Spreadsheet:
   
code:

import pandas as pd
from pathlib import Path
import os 
  
  
class ExcelToCsv:
    def __init__(self):
        os.chdir(os.path.abspath(os.path.dirname(__file__)))
  
    def excel_to_csv(self, workbook, sheetname, csvfile, startrow=None, endrow=None, index=False):
        # Allows for selection start/end if sepecified 
        if startrow:
            skiprows = startrow
            if startrow > 1:
                skiprows = startrow-1
            nrows = endrow - startrow
            df = pd.read_excel(workbook, sheet_name=sheetname, skiprows=skiprows, nrows=nrows)
        else:
            df = pd.read_excel(workbook, sheet_name=sheetname)
        print(df)
        df.to_csv(csvfile, index=index)

def main():
    etc = ExcelToCsv()
    # You will need to adjust filenames and locations
    just1 = Path('../data/excel/JustFirstSheet.xlsx')
    csvfile = Path('./extocsv.csv')
    etc.excel_to_csv(just1, 'Sheet1', csvfile=csvfile)

if __name__ == '__main__':
    main()

results:

Output:
Segment,Country,Product,Discount Band,Units Sold Manufacturing Price,Sale Price,Gross Sales,Discounts Sales,COGS Profit,Date,Month Number,Month Name,Year,Unnamed: 13,Unnamed: 14,Unnamed: 15,Unnamed: 16,Unnamed: 17,Unnamed: 18,Unnamed: 19
Government,Canada,Carretera,None,1618.5,$3.00,$20.00,$32,370,$-,$32,370,$16,185,$16,185,01/01/2014,1,January,2014
Government,Germany,Carretera,None,1321.0,$3.00,$20.00,$26,420,$-,$26,420,$13,210,$13,210,01/01/2014,1,January,2014
Midmarket,France,Carretera,None,2178.0,$3.00,$15.00,$32,670,$-,$32,670,$21,780,$10,890,01/06/2014,6,June,2014
Midmarket,Germany,Carretera,None,888.0,$3.00,$15.00,$13,320,$-,$13,320,$8,880,$4,440,01/06/2014,6,June,2014
Midmarket,Mexico,Carretera,None,2470.0,$3.00,$15.00,$37,50,$-,$37,50,$24,700,$12,350,01/06/2014,6,June,2014
Government,Germany,Carretera,None,1513.0,$3.00,$350.00,$529,550,$-,$529,550,$393,380,$136,170,01/12/2014,12,December,2014
Midmarket,Germany,Montana,None,921.0,$5.00,$15.00,$13,815,$-,$13,815,$9,210,$4,605,01/03/2014,3,March,2014
Channel Partners,Canada,Montana,None,2518.0,$5.00,$12.00,$30,216,$-,$30,216,$7,554,$22,662,01/06/2014,6,June,2014
Government,France,Montana,None,1899.0,$5.00,$20.00,$37,980,$-,$37,980,$18,990,$18,990,01/06/2014,6,June,2014
Channel Partners,Germany,Montana,None,1545.0,$5.00,$12.00,$18,540,$-,$18,540,$4,635,$13,905,01/06/2014,6,June,2014
Midmarket,Mexico,Montana,None,2470.0,$5.00,$15.00,$37,50,$-,$37,50,$24,700,$12,350,01/06/2014,6,June,2014