Linked Questions
227 questions linked to/from How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
4
votes
1
answer
17k
views
How to use ExcelDataReader nuget for creating Excel File and Write [closed]
can we use ExcelDataReader for creating excel sheet and writing into excel template. Or suggest any tool for the same
1
vote
3
answers
16k
views
Export to Excel, Lotus notes domino
I have a view which is displaying 9 lines of information per every document. In this view I have Export to Excel functionality using the below code to Export document to excel.
Data isn’t exporting ...
4
votes
1
answer
12k
views
How to set value of Excel cell by name instead of using coordinates with EPPlus?
I am able to set cell values using EPPlus:
var template = new FileInfo(Server.MapPath("~/App_Data/my_template.xlsx"));
var pck = new ExcelPackage(template);
var ws = pck.Workbook.Worksheets.First();
...
15
votes
2
answers
1k
views
How to interpret a collection when exporting to Excel (XLSX) using Telerik?
SCENARIO
I'm using the Telerik UI For Windows forms.
I have a RadGridView on which I'm representing a custom type named MarketInfo:
Public NotInheritable Class MarketInfo
...
Public ...
1
vote
2
answers
11k
views
How do I run an Excel Macro from a .Net web system?
I'm trying to run an Excel Macro called Sheet1.Workbook_Open from a .NET web system.
Below is my current code.
xlApp = New Excel.Application
xlWorkBook = xlApp.Workbooks.Open("C:\Testing\TempFile....
2
votes
1
answer
11k
views
Output to Excel using ExcelLibrary in c#
The following code outputs to a csv file using controller.file. I want to change it to input to an excel sheet (.xls) instead of a csv file. I a using this library from here to do this.. http://code....
4
votes
2
answers
3k
views
ASP.NET Export to Excel - Lock Cells
I'd like to export a table I have on my webpage to an Excel file and lock some cells in the new file. Here is my current code:
Protected Sub btnExportToExcel_Click(ByVal sender As Object, ByVal e As ...
3
votes
6
answers
1k
views
Can I import INTO excel from a data source without iteration?
Currently I have an application that takes information from a SQLite database and puts it to Excel. However, I'm having to take each DataRow, iterate through each item, and put each value into it's ...
5
votes
6
answers
3k
views
Open a single worksheet (single tab) from a huge excel file on a web browser using c# asp.net / MVC
I have huge excel files that I have to open from web browser. It takes several minutes to load huge file. Is it possible to open a single worksheet (single tab) at a time from excel file that contains ...
1
vote
3
answers
13k
views
How to export to excel in windows app C#?
I am new in Windows Application development, Trying to write code for exporting dataset to excel. I have read several examples on the internet regarding this but all are exporting the file to a ...
1
vote
2
answers
8k
views
Convert xml to excel
As I am trying to convert xml file to excel.
I am able to do this with .xls file extensions only. When I try to convert xml file to excel with .xlsx extension I am able to create the excel file, but ...
3
votes
3
answers
1k
views
Create an *.xlsb in linux
Does anyone know how to create or export data to an xlsb file (Binary File Format) in a Linux OS from any programming language?
My idea is to execute it from R, but any suggestion in Python, Perl or ...
1
vote
2
answers
6k
views
How to use excel in MS visual C++
I want to make a windows form app. You can write text in textBox'es and when you press a button, the app would create an excel file and write the text from the boxes. I got only the UI done, I know ...
1
vote
3
answers
9k
views
how to write list array to Excel file
I have a list array which contains some data. Currently I can see the output in the console and now trying to add to an excel file. Can anyone explain me how to do that. Here is the code to create an ...
4
votes
5
answers
2k
views
How to Create an XLS from a CSV, List, or DataSet using C#?
I currently have a CSV that I have built using StringBuilder in C#.
This CSV is generated by:
Querying the Database using LINQ
Dumping the Resulting entries into a List
Looping through the List and ...