Is there a way to create/read a LibreOffice Spreadsheet just like MS Office Excel with C#?

c# .net excel libreoffice libreoffice-calc
Christos Karapapas picture Christos Karapapas · Jul 12, 2011 · Viewed 11.5k times · Source

In a program that creates an excel file, i wonder if i could give the chance to the users that don't have MS Office to create an .xls file with only LibreOffice installed. What should i use instead of "using Excel = Microsoft.office.interlope.excel;" and the rest of the commands ? TnX!

Answer

Icemanind picture Icemanind · Jul 12, 2011

LibreOffice uses the ODF (Open Document Format). ODF is not a hard format to grasp because all it basically is is a collection of XML files that are zipped into one file, called an ODF file. You can read here on how to read and save ODF files. Also, you can check here for a real example in C#

Related questions

How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?

How can I create an Excel spreadsheet with C# without requiring Excel to be installed on the machine that's running the code?

Read More
Reading Excel files from C#

Is there a free or open source library to read Excel files (.xls) directly from a C# program? It does not need to be too fancy, just to select a worksheet and read the data as strings. So far, I've …

Read More
How to read data from excel file using c#

My application needs to read data from an excel file. I am using .Net and c# for development. I cannot install MS office in the system. Because of that the my application fails to read excel file and throws an …

Read More