How to convert an csv sheet to excel(.xlsx) sheet using openxml??

Hi @Krishankumar6401,

If you're asking how to create an .xlsx workbook programmatically, then you may be interested in the following resources:

• https://github.com/EricWhiteDev/Open-Xml-PowerTools
• https://github.com/OfficeDev/Open-XML-SDK
• https://video2.skills-academy.com/en-us/office/open-xml/open-xml-sdk

These are libraries and documentation for creating and manipulating Office Open XML documents using C# (or VB.net) and .Net. There are other libraries and tools out there but these are widely used.

For specific instructions on how to convert a .csv to .xlsx besides having Excel do it, the Open XML SDK does not contain a function for such conversion and I don't think the PowerTools does either. You would need to find another third party library to help with that or do the work yourself using something like the Open XML SDK.

The following StackOverflow thread contains some discussion on this:

https://stackoverflow.com/questions/16732343/converting-excel-file-from-csv-to-xlsx[converting-excel-file-from-csv-to-xlsx][4]

I hope this helps.

Best regards,
Tom Jebo
Sr Escalation Engineer
Microsoft Open Specifications Support

You will need to use a third party library to achieve the conversion.

The following is a code sample shows how to save csv to excel xlsx format based on spire.xls library:

using Spire.Xls;

    namespace CsvtoExcel
    {
        class Program
        {
            static void Main(string[] args)
            {
             //Load a csv file
             Workbook workbook = new Workbook();
             workbook.LoadFromFile(@"D:\Files\Input.csv", ",", 1, 1);

             //Get the first worksheet
             Worksheet sheet = workbook.Worksheets[0];
             sheet.Name = "csv to excel";

             //set background color for specific cell ranges
             sheet.Range["A1:E1"].Style.Color = Color.Chocolate;
             //set the backgroundcolor=LightBlue of Range["A2:E6"]
             sheet.Range["A2:E6"].Style.Color = Color.SpringGreen;
             //set the backgroundcolor=Silver of Range["A7:E12"]
             sheet.Range["A7:E12"].Style.Color = Color.SkyBlue;
             //set the backgroundcolor=Silver of Range["A13:E19"]
             sheet.Range["A13:E19"].Style.Color = Color.Yellow;

             //Save as .xlsx format
             workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013);        
            }
        }
    }

For more information, you can visit this link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/CSV-to-Excel-Convert-CSV-to-Excel-with-C-VB.NET.html

Hope it's helpful.