Linked Questions
229 questions linked to/from How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
75
votes
7
answers
168k
views
Create Excel files from C# without office [duplicate]
I am writing a program that generates excel reports, currently using the Microsoft.Interop.Excel reference. My dev computer has Excel on it, but the end user may or may not have Office installed. ...
19
votes
1
answer
64k
views
Any open source / free library for handling Excel (both *.xls and *.xlsx) files? [duplicate]
I know of some open source libraries for handling with Excel files but these are for only *.xls or *.xlsx, for example NPOI is for *.xls, EPPlus and ClosedXML are for *.xlsx. I don't want to use ...
4
votes
2
answers
11k
views
How to export datatable to excel in c# windows application [duplicate]
I found some code through googling that allows me to export a data table to excel file. i successfully export the file from database table and save it in my document
My coding is:
using System;
...
-1
votes
2
answers
11k
views
How can I build an Excel file without Office or any 3rd party dependencies installed? [duplicate]
The Windows form app (C#) that we've already got imports files based on an .xlsx file. I've been tasked with writing a new section that automates the production of that spreadsheet. Creating the data ...
-3
votes
2
answers
12k
views
How to export data from c# console application to Excel [duplicate]
i have some rows and columns in c# console output, i want to export this to excel.any advice? Thanks
4
votes
4
answers
2k
views
The file name or path doesn't exist or used by other program while writing Excel file [duplicate]
I am trying to create an Excel file and write some data to it.
Here is the code I am using.
using excel = Microsoft.Office.Interop.Excel;
excel.Application xlapp;
excel.Workbook xlworkbook;
excel....
4
votes
2
answers
414
views
How to get short value using Double Function? [duplicate]
Possible Duplicate:
Create Excel (.XLS and .XLSX) file from C#
Rounding double values in C#
my double function generating values like this
56,365989365
i want just value like this 56,36
...
1
vote
4
answers
4k
views
Generate Excel Spreadsheet from CSV (ASP.NET C#) [duplicate]
Possible Duplicate:
Create Excel (.XLS and .XLSX) file from C#
I have some code that generates a zip file that contains multiple CSV files and streams it back to the user (no file is saved on the ...
7
votes
1
answer
2k
views
Linq to Excel with multiple tabs [duplicate]
I use Entity Framework together with Linq to fill my gridviews.
I would like to get the same data I get from the Linq in an excel.
Also a second tab in the same excel sheet should come from another ...
0
votes
2
answers
1k
views
. NET Creating Excel Files [duplicate]
In my application, I need to generate excel files on the fly. I have an option of using Excel library. But it is mandatory to have excel installed on the machine.
Is there any other .NET API to ...
0
votes
1
answer
424
views
DataSet To Excel [duplicate]
I do not have Excel installed on my server, it is installed on the PC that will be exporting. I am wanting to export the dataset to Excel, but am unsure of how to do such as we have Excel XP, Excel ...
-6
votes
1
answer
850
views
C# Writing to a excel file [duplicate]
I have Data stored in DataTables and I'm trying to write that data into a .xlsx file, with multiple sheets. I don't how to go about it. Thanks
-3
votes
2
answers
317
views
generate an excel file in C# [duplicate]
I'm developing an application on C#. This is a web application. As a part of this application, I need to generate an excel file that will be store into the DB. This mean that the user won't see/open ...
0
votes
0
answers
32
views
Generate excel sheet from ASP.NET [duplicate]
I just start working on asp.net. I would like to generate excel from database but it does not work. below is the function.
What I want is after creating my object using a form , export the filled ...
0
votes
0
answers
11
views
How can I write to some sheets of excel having multiple sheets using C# [duplicate]
I wanted to write to a specific sheet of an excel file having multiple sheets. How can I do so using C#.
This is the method that I have:
public void WriteCSV<T>(IEnumerable<T> items, ...