Export C# datatable to Excel split in 2 sheets

Platform: Windows Programming Language: C# to be used as library in a windows application Goal: Export all ranking results to Excel file split in 2 sheets Description: To automate steps to create an offer for potential clients: export ranking results to an existing Excel template file (depending on the language of client), split in 2 Excel sheets: those with ranking and those without ranking. Function parameters DataTable dtRankingResults: contains all ranking result rows to be inserted into the Excel file ([login to view URL]). String Lang: language of the offer. Is used to determine which Excel template file to use. String ExcelTemplateFileDir: directory of the Excel template files. String ExcelResultFilePath: full path to save new Excel file (dir + filename). Function Determine Excel template file path: ExcelTemplateFileDir + "Keywords-" + Language + ".xltx" If Excel template file path not exists: use ExcelTemplateFileDir + "[login to view URL]" Create a new Excel file (save as ExcelResultFilePath) based on the Excel template file with the following content: Loop through every ranking result row in dtRankingResults. Insert the first 7 columns of the ranking result row in the Excel file (starting from row 6) in 1 of 2 sheets: IF ranking result column ‘Ranking’ <= 30 THEN in 1st sheet ELSE in 2nd sheet. (see example result xlsx file) NOTE1: column 'Ranking' can be NaN. NOTE2: Make sure the totals in row 4 are calculated properly. NOTE3: ExcelTemplateFileDir can be provided with or without trailing slash (eg: "c:\dir" or "c:\dir\")