.NET library for Excel files manipulation
Native .NET solution to create, read and modify Excel files without using COM interop or OLEDB connection.
Project page: https://code.google.com/p/excellibrary/
Questions tagged [excellibrary]
67 questions
0
votes
1 answer
Using GetVstoObject and HasVstoObject
I have a console app that creates an excel worksheet using the Interop Library, and then tries to get the vstoObject using the GetVstoObject to use the Microsoft.Office.Tools.Excel Library. When running the code below the HasVstoObject always…
AC25
- 413
- 1
- 7
- 23
0
votes
2 answers
Linq results to dataset
I use the entity framework together with Linq to get my data out of the database.
I would like to download this data in to an excel. The ExcelLibrary works with datasets.
is it possible to get the Linq data in an dataset, so I can easily get the…
Freddy
- 960
- 1
- 20
- 46
0
votes
1 answer
Issue generating an excel file from a SP with a column datetime using ExcelLibrary c#
I'm using the ExcelLibrary to export the result from a SP to Excel following Mike Webb's example at: Create Excel (.XLS and .XLSX) file from C#
But one of the columns of the SP returns a DateTime field, and every time I generate the excel File that…
Somebody
- 2,667
- 14
- 60
- 100
0
votes
1 answer
Missing Reference when using the Excel Library with Microsoft visual studio 2012
I am using Visual studio 2012 with MySql database .. I am trying to generate simple report using Forms. When click on button the reports will generate in EXCEL sheet. The problem that I am facing is using this library: using Excel =…
Ismail Saifo
- 53
- 1
- 11
0
votes
1 answer
C# Excellibrary - how to get cell content?
I need some quick help.
How do I get the content of a cell using excellibrary? The documentation is very thin.
I don't really get the example code:
// traverse cells
foreach (Pair, Cell> cell in sheet.Cells)
{
…
ChristopherSirén
- 139
- 1
- 19
-2
votes
1 answer
How do I convert Excel to DAX Formula?
In my current project I am migrating Excel reports to Power BI, I need help converting the Excel formulas to DAX
Excel
COUNTIFS($K:$K,"*",$L:$L,E$31,$CS:$CS,1$D:$D,$E$15)
SUMIFS($AU:$AU,$L:$L,E$31,$CI:$CI,…
elakiya selva
- 11
- 1
- 2
-2
votes
1 answer
Conditional formatting Excel 2010, as per attached sheet how can I apply conditional formatting in column b?
10 9
20 10
30 25
40 18
50 27
60 50
70 55
80 40
90 30
100 150
I want conditional formatting in Column b Colosseum less the a column
RAJ
- 1