C# - I want to convert a csv file to xlsx format on a server where office is not installed.
Dont know the work sheet name and data of csv
Dont know the work sheet name and data of csv
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kamal KPosted Sep 27, 2016, 8:23 AM
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();
}
Lokesh KumarPosted Sep 27, 2016, 1:15 AM
Please follow C# example:
ExcelWorkbook wrkBook = ExcelWorkbook.ReadCSV(@"..\input.csv");
// For (Excel 97/2003) xls
wrkBook .WriteXLS(@"..\output.xls");
// For (Excel 2007) xlsx
wrkBook .WriteXLSX(@"..\output.xlsx");
alice yangPosted Sep 26, 2016, 9:25 PM
Guest UserPosted Sep 26, 2016, 9:14 AM