Free C# library to save as Excel file

[patrick]

Hello.

In ASP.NET C# ,
There is free library to save as excel file?
The Data type to saved as excel file is Datatable(DataRow).

ASP.NET = C# Free library

using Microsoft.Office.Interop.Excel is Excluded.

 

[Skydiver]

Does it really have to be an Excel file? I hope you know that Excel can open up .CSV files.

 

[patrick]

Does it really have to be an Excel file? I hope you know that Excel can open up .CSV files.

please aske for free excel library.

i need to excel free library.

 

[patrick]

please aske for free excel library.

i need to excel free library.

Can not download from Nuget.

 

[cjard]

Can not download from Nuget.

What does this mean?

 

[cjard]

I hope you know that Excel can open up .CSV files.

Yeah but everything around CSV is just.. Nasty.

At least Excel files can have data typing applied to the values so it's not guesswork on the behalf of the reader..

 

[kareninstructor]

Look at SpreadSheetLight which is a free to use library for .xlsx Excel

public static void ExportToExcel(DataTable table, string fileName, bool includeHeader, string sheetName)
{
    using var document = new SLDocument();

    // import to first row, first column
    document.ImportDataTable(1, SLConvert.ToColumnIndex("A"), table, includeHeader);

    // give sheet a useful name
    document.RenameWorksheet(SLDocument.DefaultFirstSheetName, sheetName);

    document.SaveAs(fileName);
}

 

[cjard]

@kareninstructor OP says they cannot (incapable? prohibited?) download from Nuget

 

[Skydiver]

As as aside, it's been years since I last had fun and was laughing while reading an FAQ. I hope that the author is also part time stand-up comedian.

Frequently Asked Questions | SpreadsheetLight for .NET Framework

Frequently asked questions about SpreadsheetLight

spreadsheetlight.com

 

[kareninstructor]

@kareninstructor OP says they cannot (incapable? prohibited?) download from Nuget

I wonder about this and what stopping them from downloading but alas even know that I still find value in posting it.

Perhaps if this is because of a company policy they might ask for an exception to the rule.

 

[Skydiver]

Some companies are under the belief that just downloading binaries instead of building from source will lead to code that cannot be maintained in the future should the need arise. They don't understand that downloading binaries are okay, as long as the developers also take a snapshot of the source code that should match the binaries.

It was reading the FAQ. On the positive side, when you download the Nuget package, you also get the source as part of the package (instead of going to GitHub or contacting the author). On the negative side, you quite literally get the source code, and only the source code. (The author claims that this complies with the definition of "open source", but as I understand things, the way thr OSF defines "open source" is that the necessary build scripts/files should also be supplied. He makes a snarky remark that if you are incapable of being able to make a build project with just the source code, then you probably are not yet skilled enough to be touching the code.)

So if need be the OP can get the NuGet package by simulating all the HTTP requests that NuGet does under the covers, and they can technically not have used NuGet to get the library.

 

[mashispano]

Hello.

In ASP.NET C# ,
There is free library to save as excel file?
The Data type to saved as excel file is Datatable(DataRow).

ASP.NET = C# Free library

using Microsoft.Office.Interop.Excel is Excluded.

Probably too late, but have you tried CloseXML --> GitHub - ClosedXML/ClosedXML: ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
You can create and save as Excel file format.

Happy coding