convert .csv to .xlsb programatically c#

Question

Is it possible to convert a .csv file to .xlsb programatically ? (Preferrably C#)

shows how to convert XLS to XLSB , can I use the same to convert it from.csv? Won't there be any formatting issues? I am doing this on the server side because the .xlsb file size is very small compared to a .csv file, and I don't have an option of zipping my file.

Randy Minder · Accepted Answer · 2014-07-31 12:35:54Z

3

Take a look at EPPlus. I have used this extensively with great success. Fantastic Excel library and it's open source.

And, yes, there certainly will be formatting issues. You cannot go from XLS to CSV and maintain any of the original formatting because .CSV is pure text.

answered Jul 31, 2014 at 12:35

Randy Minder

48.8k55 gold badges221 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Ujjwal Vaish Over a year ago

I don't think excelpackage has the capability to do this, I am already using it in my application.

Randy Minder Over a year ago

It can be done. Here is an example: codejournal.blogspot.com/2012/03/…

Ujjwal Vaish Over a year ago

That shows the conversion from xlsx to csv , I need it for csv to xlsb. The thing is , while converting a file to xlsb , we get some errors. For the rest of the conversions , it's fine. Thanks for your interest though , appreciate it. :)

shakeel · Accepted Answer · 2018-08-28 08:46:33Z

0

Aspose.Cells File Format API can convert your CSV file to XLSB format. Please see the following sample code and screenshots for your reference.

C#

// Directory path for input and output files.
string dirPath = "D:\\Download\\";

// Load your sample CSV file inside the Workbook object.
Aspose.Cells.Workbook wb = new Aspose.Cells.Workbook(dirPath + "sampleConvertCSVToExcelFormats.csv");

// Save CSV file to XLSB format.
wb.Save(dirPath + "outputConvertCSVToExcelFormats.xlsb", SaveFormat.Xlsb);

Screenshots of Sample CSV and Output XLSB files

Sample CSV File:

Output XLSB file

Thank you and regards.

edited Aug 28, 2018 at 8:46

answered Aug 9, 2018 at 13:57

shakeel

1,72510 silver badges15 bronze badges

Collectives™ on Stack Overflow

convert .csv to .xlsb programatically c#

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related