how to save xls file as xlsx file using NPOI c#?

c# export-to-excel npoi
Yacino picture Yacino · Apr 8, 2015 · Viewed 7.5k times · Source

I'm using NPOI to open XLS file, then add some modifications to the XLS file. at the end i want to save it as XLSX file.

i'm using this code to save it as XLS file: 

using (var fs = new FileStream(Name, FileMode.Create, FileAccess.Write))
{
     wb.Write(fs);
}

Is it possible to save this XLS file as XLSX file using NPOI in C#?

Thanks in advance for your response

Answer

Andy Korneyev picture Andy Korneyev · Apr 10, 2015

It is possible in general, but not quite easy, rather it is significantly complicated task.

XLS file format is handled by HSSFWorkbook class (and according HSSFSheet and so on).
XLSX file format is handled by XSSFWorkbook class (and XSSFSheet and so on).

So in order to save your file as XLSX after you opened and modified it using NPOI, you need to create new XSSFWorkbook, then for each worksheet of your source file you need to create appropriate XSSFSheet, copy data to it from your original worksheet and so on until you will get full copy of your data, and then save workbook to file.

Related questions

CellStyle applied to all cells in the Worksheet unexpectedly - NPOI?

I don't understand why this can happen, first I tried applying a bold text to my column headers in the first row, then I want to set my header cells' borders to MEDIUM, but this MEDIUM border style is applied …

Read More
Download Excel file via AJAX MVC

I have a large(ish) form in MVC. I need to be able to generate an excel file containing data from a subset of that form. The tricky bit is that this shouldn't affect the rest of the form and …

Read More
Format an Excel column (or cell) as Text in C#?

I am losing the leading zeros when I copy values from a datatable to an Excel sheet. That's because probably Excel treats the values as a number instead of text. I am copying the values like so: myWorksheet.Cells[i + 2, …

Read More