epplus Questions
6
System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets.
I am using EPPlus Version 3.1.3.0
We do the following in code.
We loop through
...
Madelaine asked 6/11, 2014 at 19:5
3
Solved
I am looking for a way to create, modify, read .xlsx files in C# without installing Excel or creating files on the server before giving to the user to download.
I found NPOI http://npoi.codeplex.c...
Gelatinous asked 5/3, 2012 at 15:37
2
Solved
I am working on dynamic Excel creation with the help of EPPlus library and I have an excel which data looks like:
Name EmpCode Department attendance
Prashant 111 CSE 70% for Sep
Prashant 111 CSE 9...
3
I would like to add comments at one cell, So.. I did:
...
ExcelPackage package = new ExcelPackage(new MemoryStream());
var ws = package.WorkBook.WorkSheet[1];
ws.Cells[1, 1].AddComment("Lot P...
Phyllis asked 26/1, 2017 at 22:55
4
Solved
In Excel you can format numbers in the following format:
I'd like to format a cell with this format in EPPlus, but I don't see that property available:
I've looked a number of other formats,...
3
Solved
I am using EPPlus v4.1 to generate an excel file in C#.
Is there a way to set a specific worksheet as the default worksheet? (when the user is opening the exported file, that sheet should be shown...
5
Solved
I'm using asp.net MVC 4 and epplus as a nuget package for exporting my data into an excel file. I do that as the following:
var excel = new ExcelPackage();
var workSheet = excel.Workbook.Worksheet...
Abundance asked 13/10, 2016 at 22:47
2
I need help. How can i add a drop down in excel using Epplus? No need for validation. I just need to add this to my template.
Records in the drop down are not dynamic.
5
Solved
I would like to convert the value in to 2 decimal places. I am using EPPlus
if the value is 66.6666667 and I would like to show it as 66.66%
I tried the following code but its not working.
for...
7
Solved
I am trying to open an XLSX file as a template (I have even used a blank XLSX file), using EPPLUS 4.0.3.
If I do not open the template file (blank or the real one) and just create a new workbook a...
Literatim asked 21/4, 2015 at 14:27
4
Using .net core & c# here.
I have a UI from which user can upload the Excel or CSV files. Once they upload this goes to my web api which handles the reading of the data from these files and re...
Calkins asked 12/11, 2018 at 17:56
3
Solved
I use the following Code:
using (var package = new ExcelPackage()) {
var worksheet = package.Workbook.Worksheets.Add("Test");
var cell = worksheet.Cells[1, 1];
var r1 = cell.RichText.Add("Te...
4
Solved
I have tried the below C# CODING:
wsDt.Cells["A10:G10"].AutoFilter = false;
but the filter is not removed from my excel.
Any other way to remove it.
Thanks...
2
I am facing an issue while trying to stream out an excel file which I generated with EPPlus OfficeOpenXml package.
My WCF service contact as below,
[WebInvoke(UriTemplate = "getengagementfeedf...
Alameda asked 18/8, 2022 at 8:16
6
Solved
I'm using the 3.1 release of EPPlus library to try to access a worksheet in an Excel file. When I try either of the following methods I get a System.ArgumentException : An item with the same key ha...
5
Solved
5
Solved
I'm having difficulty setting up EPPlus in Visual Studio 2012.
using OfficeOpenXML;
The type or namespace name 'OfficeOpenXML' could not be found(are you missing a using directive or an assembly r...
Bovine asked 9/7, 2013 at 14:38
2
Solved
I am using the below code for updating excel data format, here I want the heading to be in bold and entire data in italics format but when I run the code all the features in it seems to be working ...
4
Solved
I'm using the EPPlus library to read/write Excel files: http://epplus.codeplex.com/
I'm trying to simply merge some cells when writing a document:
using (ExcelPackage pck = new ExcelPackage())
{
...
11
Solved
I'm having trouble with format my cells to Date.
FileInfo info = new FileInfo(path);
using (ExcelPackage package = new ExcelPackage(info))
{
ExcelWorksheet ws = package.Workbook.Worksheets.Add(sh...
3
I am using Epplus library to convert dataTable in Excel. I am using a textarea in my front end site. In which a line break is also there. But, the problem is when I convert this file to Excel, text...
2
I am getting 0 worksheet count when the excel file (.xls) has 4 worksheets. I dont know why its not working for me. Please help.
Excel file last in Excel Version 1908 Office 365
EPPlus Version : 4...
4
Solved
I would like each cell in the header to contain an autofilter. Below is the code I'm trying to use however the autofilter only gets set on the last cell specified.
For example, if I comment out t...
5
Solved
So i'm using EPPlus to read and write excel documents.
Workflow
User generates populated excel document
Opens document and adds a row
Uploaded and read
The dates that are generated when I crea...
1
I have created an Excel Pivot Table in a worksheet using the EPPlus toolkit, version 3.1. I am able to sort the resulting table on the row field but would like to be able to do it on the Data Field...
Abb asked 13/8, 2014 at 20:53
1 Next >
© 2022 - 2024 — McMap. All rights reserved.