Stack Overflow
Stack Overflow

Questions tagged [linq-to-excel]

Retrieve data from spreadsheets and csv files by using LINQ

Project Home Page: https://github.com/paulyoder/LinqToExcel

145 questions
2
votes
1 answer

Retrieve last column has value in excel

I have a sheet which have many columns. suppose I have below 6 columns. Number of real columns are more x temp 1 temp 2 temp 3 temp 4 temp 5 temp 6 101 22 102 23 34 103 56 104 …
user3073682
  • 97
  • 5
2
votes
2 answers

Why LinqToExcel is returning null when encounters "-" character?

I'm using LinqToExcel to retrieve some information and I can get the data from all my columns except from one. This is the Scenario: I have 3 columns: Code Name LastName 89 test1 test2 89-2 test3 test4 90 test5 test6 and to get…
Goca
  • 1,743
  • 2
  • 15
  • 36
2
votes
2 answers

Use LinqToExcel in dll, when main executable uses old log4net version

I am writing an extension (dll) for a 3rd party program. The main program is using log4net version 1.2.10. I want to use LinqToExcel to read Excel files, which also depends on a newer version of log4net. When I use the log4net.dll from the main…
Fabian S.
  • 909
  • 6
  • 20
2
votes
1 answer

linq to excel exception IErrorInfo.GetDescription

This is my code var data = new LinqToExcel.ExcelQueryFactory(); data.FileName = @"FRM_DTA.xlsx"; var result = from x in data.Worksheet() select…
Anastasie Laurent
  • 877
  • 2
  • 14
  • 26
2
votes
0 answers

Linq to Excel mapping with Data Lists enabled Excel cell

I am able to parse the huge set of data from the excel file using the below LinqtoExcel mapping concepts. My requirement: How to do LinqtoExcel Mapping when a particular cell in spreadsheet is provided with DataLists options. Is it possible to do…
Shrivatsan
  • 105
  • 1
  • 18
2
votes
1 answer

Reading formula calculated value from excel cell in c#

I am using linqtoexcel for reading from a excel sheet. the problem i face is that i can't read the formula calculated value from a cell, instead i get the actual value of the cell. Is there any way to read the end value of the cell from the excel…
user1811801
  • 679
  • 3
  • 7
  • 14
2
votes
1 answer

64 bits alternatives to linq to excel

I have an ASP.NET MVC 3 application in which I want to import excel files. I managed to do this using the linq-to-excel library. But when I deployed the application on IIS I got an error which turned out to be caused by IIS being running on 64bits…
kbaccouche
  • 4,575
  • 11
  • 43
  • 65
2
votes
1 answer

Read first row of excel sheet using OpenXML and LINQ

I want to read first row of the excel work sheet using Open XML sdk with LINQ. Is there any way I could get it with out using following code: WorkSheetPart.Worksheet.Descendants().FirstOrDefault(); The above code is taking long time (almost 1…
gee'K'iran
  • 431
  • 2
  • 7
  • 21
2
votes
3 answers

LinqToExcel: Distinct values in excel column

This might be a very simple thing for you gurus, but I'm not familiar with C#4 and INTEROP. Therefore, I'm stumped. Here's my problem. I have a excel column that has duplicate data and I want to trim it down to only unique values. Here's what the…
inquisitive_one
  • 1,465
  • 7
  • 32
  • 56
1
vote
1 answer

Define a worksheet name and a WorksheetRange

Im trying to use the Linq to Excel library, and i get stucked into this problem. I have an excel with a worksheet name, and i need to define the range of the colums that i need to get. The problem is: how to use these two classes at the same time on…
Otuyh
  • 2,384
  • 5
  • 22
  • 40
1
vote
2 answers

Sub-Select Using LinqToExcel

I'm trying to figure out how to perform a sub-select using Linq. I have an excel sheet with a 'debit' and a 'credit' column. I need to filter out any rows which have a debit column value (> 0.00) that matches up with a credit column value further…
backdesk
  • 1,781
  • 3
  • 22
  • 42
1
vote
2 answers

I am trying to convert csv into xlsx fileI am getting an error "No columns to parse from file"

My code : df=pd.read_csv("File.csv",header=None,delim_whitespace=True) df.to_excel("output.xlsx",sheet_name=sheet.name,index=False) i can see File.csv has no data.How to avoid this error.(Data was extracted as csv format and saving in it as…
Sparrow
  • 15
  • 6
1
vote
4 answers

How to set change Linq to excel Null string values?

I have a model to cast an object list using LINQ to excel. public class Model{ public string Name { get; set; } public string Date { get; set; } } and I am using var result = excelQueryFactory.Warksheet(0); But my excel has Null test in…
barteloma
  • 6,403
  • 14
  • 79
  • 173
1
vote
3 answers

Linq to excel not working , when upgrading .net core 2.1 to .net core 2.2

> I was using .Net core 2.1 for my project. I used LINQ to excel to get read data from excel file. When i upgrade by my project to .Net core 2.2. it is not working. my code to read data from excel file is string pathToExcelFile = "path to excel…
user12483436
1
vote
1 answer

Program using LinqToExcel works on my computer but after publishing and installation on another one it does not

Published and installed program using LinqToExcel throws an "Exception has been thrown by the target of an invocation" exception. Inner exeption is not displayed but on my computer if I run exe file separately w/o another source files there is Could…
Jan Daliba
  • 29
  • 5
1 2
3
…
9 10