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
0
votes
1 answer

How to retrieve column names from a excel sheet?

Using EPPlus I'm writing data to multiple sheets. If a sheet is not created I'm adding a sheet else I'm retrieving the used rows and adding data from that row and saving it FileInfo newFile = new FileInfo("Excel.xlsx"); using (ExcelPackage…
Ajay A
  • 127
  • 7
0
votes
1 answer

How to include a condition to check if cell value in column is empty?

How can I include a condition to check a excel cell column value to see if it is empty or not? I've already mapped the column using linq mapping. When I go to grab the value whether it is null or not in the excel file, i'm getting object not set to…
NewKidOnTheBlock
  • 91
  • 1
  • 13
0
votes
0 answers

How to fetch a Linq to Excel Query?

Here is my code , for fetching an Microsoft Excel file from my desktop , the name of the file is: testExcel.xls and the name of the sheet is : feuil1 An exception occur when the fetching step begin here is my code: string pathToExcelFile =…
Ismail Addou
  • 383
  • 1
  • 2
  • 17
0
votes
1 answer

Input string was not in correct format error in LINQ to Excel query

I'm getting a input string was not in correct format when parsing an excel file with LINQ to Excel: var excel = new ExcelQueryFactory(ExcelFileURI); excel.DatabaseEngine = DatabaseEngine.Ace; var items =…
ConnorU
  • 1,379
  • 2
  • 15
  • 27
0
votes
1 answer

How to validate errors for items in IQueryable collection?

Let's say I have a class TmpClass, I use this class for returning data from Excel sheet using LinqToExcel ExcelQueryFactory. In this class I need to implement some logic to check data correctness. When I retrieve data from Excel sheet using…
Prokurors
  • 2,458
  • 3
  • 40
  • 65
0
votes
3 answers

LinqToExcel returns null

I have an excel sheet of xls format, I am using LinqToExcel to read it and then import it to my DB. This sheet consist of about 3K row and only 6 cols. I am using .addmapping to map my class properties to the column names The problem i have is: the…
alsafoo
  • 778
  • 4
  • 18
0
votes
0 answers

System.Format Exception. in LINQToEXCEL

in my MVC 5 application, i am using LinqToExcel to import data from Excel file to SQL Server Database table. Following is the code for getting the data and saving to the database. var dataDirectory = new…
Mustafa Sattar
  • 181
  • 3
  • 5
  • 18
0
votes
1 answer

linq to excel not ignoring blank sheet

I have been using linq to excel on one of my projects and it works great ! Its throwing a System.Data.DataException if a sheet in my excel file is blank.This is how i am querying var excelInfo = new ExcelQueryFactory(excelFileName); var…
cableload
  • 4,215
  • 5
  • 36
  • 62
0
votes
2 answers

Linq to Excel and publish to godaddy issue

All works fine on my machine , but after publishing to godaddy, I got this error : [5/28/2014 3:54:41 AM ]: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. , System.Data , at…
AMH
  • 6,363
  • 27
  • 84
  • 135
0
votes
1 answer

Entering value into Excel sheet at particular location only thru linq to excel in c#

My Excel sheet is as below: Id Name Status 1 XYZ 2 ABC 3 BB 1 Yz What I am trying to do is to write Checked in the status column whose Id is 1 from my C# application. I thought of doing this through Linq to Excel. But I am not…
Vipin Nair
  • 517
  • 4
  • 9
  • 33
0
votes
1 answer

c# Reading Excel cannot work on server which excel not installed on

I have writeen a software which some part's process is reading data from excel file. I have used linqtoexcel for this. But ı can't run this app on machine not installed office. And I don't want to install…
Aykar Kr.
  • 21
  • 5
0
votes
3 answers

Linq: select where in List

Struggeling with some LinqToExcel filtering here... Ive got a List columnsToFilter that contains 9 strings, and with that i want to filter out the data for certain columns in a List, where Row contains the properties…
stefjnl
  • 732
  • 3
  • 14
  • 31
0
votes
1 answer

C# removing and re-adding rows to excel sheet

Simple question. I have an excel sheet that I want to use as a database. I use linq-to-excel and it works wonderfully except it only works if the header row is the first row in the sheet and the spreadhseets I need to run on have other (important to…
ConnorU
  • 1,379
  • 2
  • 15
  • 27
0
votes
1 answer

Linq to Excel ignoring header rows and using subheaders

I'm looking at Linq to Excel tutorials and they all seem pretty simple and straightforward excpet all of them assume the excel table being used has all column headers neatly placed on row 1 and starting at column A. I need to query data from excel…
ConnorU
  • 1,379
  • 2
  • 15
  • 27
0
votes
0 answers

How to use Linq-To-Excel for excel cell which includes newline

I am trying to use linq-to-excel library, my excel file includes a photo in it and a header about the excel file. I have some new lines in header cells and when I try mapping for my model and excel headers I always get NULL values. Should I do…
ibrahim yılmaz
  • 1
  • 2
1 2 3
…
9
10