Convert CSV file to specific excel template

See more:

C#

Hello,

i am new in c#. I have found code to convert the CSV file to Xls. Now i need to set the cells color and font size for my output the (Xls) file.

Is there any easy way to do it ?

Thanks

static void Main(string[] args)
{
 string csvFilePath = @"D:\sample.csv";
 string excelFilePath = @"D:\sample.xls";
 
 string worksheetsName = "TEST";
 bool firstRowIsHeader = false;
 
 var excelTextFormat = new ExcelTextFormat();
 excelTextFormat.Delimiter = ',';
 excelTextFormat.EOL = "\r";
 
 var excelFileInfo = new FileInfo(excelFilePath);
 var csvFileInfo = new FileInfo(csvFilePath);
 
 using (ExcelPackage package = new ExcelPackage(excelFileInfo))
 {
  ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(worksheetsName);
  worksheet.Cells["A1"].LoadFromText(csvFileInfo, excelTextFormat, OfficeOpenXml.Table.TableStyles.Medium25, firstRowIsHeader);
  package.Save();
 }
 
 Console.WriteLine("Converted!");
 Console.ReadLine();
}

What I have tried:

i have tried to find easy way to do it