C＃将csv转换为xlsx [英] C# convert a csv to xlsx

问题描述

C# - I want to convert a csv file to xlsx format on a server where office is not installed.

What I have tried:

//Using Interop
                //Application app = new Application();
                //Workbook wb = app.Workbooks.Open(Util.CSVFileName);
                //wb.SaveAs(Util.XLSXFileName, XlFileFormat.xlOpenXMLWorkbook, AccessMode: XlSaveAsAccessMode.xlExclusive);
                //wb.Close();
                //app.Quit();

推荐答案

使用替代方法： EPPlus - 在服务器上创建高级Excel电子表格 - 主页 [ ^ ]



这里有完整的教程： 使用C＃.Net创建/读取/编辑Advance Excel 2007/2010报告EPPlus [ ^ ]

Use alternative: EPPlus-Create advanced Excel spreadsheets on the server - Home[^]

A complete tutorial is available here: Create/Read/Edit Advance Excel 2007/2010 Report in C#.Net using EPPlus[^]

尝试关闭xml-csv以实现卓越 [ ^ ]

ClosedXML [ ^ ]

if (File.Exists(Util.XLSXFileName))
                {
                    File.Delete(Util.XLSXFileName);
                }
                //Save as xlsx using Spire
                Workbook workbook = new Workbook();
                workbook.LoadFromFile(Util.CSVFileName, ",", 1, 1);
                Worksheet sheet = workbook.Worksheets[0];
                sheet.Name = "csv to excel";
                workbook.SaveToFile(Util.XLSXFileName, ExcelVersion.Version2010);

                //Delete Evaluation Warning using EPPlus
                var workbookFileInfo = new FileInfo(Util.XLSXFileName);
                using (var excelPackage = new ExcelPackage(workbookFileInfo))
                {
                    var worksheet = excelPackage.Workbook.Worksheets.SingleOrDefault(x => x.Name == "Evaluation Warning");
                    excelPackage.Workbook.Worksheets.Delete(worksheet);
                    excelPackage.Save();
                }

这篇关于C＃将csv转换为xlsx的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！