Retrieve data from spreadsheets and csv files by using LINQ
Project Home Page: https://github.com/paulyoder/LinqToExcel
Questions tagged [linq-to-excel]
145 questions
0
votes
1 answer
Reading columns from excel file using linq
I am reading an excel file but not all the files have the same column headers but the column order are always the same. I want to read the excel file using linq but not specifying specific column names but could i use just columns based on their…
Masriyah
- 2,445
- 11
- 49
- 91
0
votes
2 answers
How to skip one (maybe more) columns of data in a list in linq
I'm reading input from two excel worksheets (using Linq-To-Excel) into two lists. One of the worksheets has an unwanted column of data (column name is known). The other columns in both worksheets however contain exactly the same type of data.
First…
InoWotImDoin
- 1
- 2
0
votes
1 answer
Can we use LinqToExcel on Shared Hosting Env like GoDaddy
I am planning to use LinqToExcel for reading of my excels files but i am not sure whether it will work on Shared Hosting env like GoDaddy?
TalentTuner
- 17,262
- 5
- 38
- 63
0
votes
1 answer
LinqToExcel Error when using DISTINCT keyword
I am trying to pull distinct values from an Excel Worksheet using the LinqToExcel library.
I keep getting an error
"{"Syntax error (missing operator) in query expression '(MOD)'."}"
I have tried everything and can't seem to pull the distinct…
Stacie Bartley
- 23
- 2
0
votes
4 answers
How to enumerate an excel file using http://code.google.com/p/linqtoexcel/ in c#
Basically what I need is the contents of an excel file (non blank cells) copied in a structure like IEnumerable> contents;
The first IEnumerable would be for rows and the second one for columns.
What I've already got working is…
nicoabie
- 2,684
- 1
- 20
- 19
0
votes
1 answer
LinqToExcel "String was not recognized as a valid DateTime" - how to capture the details?
I am using LinqToExcel to import large Excel data sheet into SQL Server database table Employees2. I am using EF4. The Date field in Excel (DOB and many other) is in "MMddyyyy" format. I have many fields in Excel, I just show 1 mapping here.
var…
monstro
- 6,254
- 10
- 65
- 111
0
votes
2 answers
LinqToExcel: How do I exclude certain rows?
I've been struggling with this for a few days now and I'm stumped. I'm hoping that someone can provide an alternate suggestion.
Basically, I'm reading data from excel using LinqToExcel. But I want to exclude all rows with a "Rating" of "NR". …
inquisitive_one
- 1,465
- 7
- 32
- 56
-1
votes
1 answer
LinqToExcel with Generic Type not return blank rows
I am using LinqToExcel to extract all rows to a list, but in this case i dont want any empty rows. I have searched for any solution here in stack but with no success to my problem.
var excelSheetLst = excel.Worksheet(sheetName).Where(s =>…
Pl4tinum
- 123
- 15
-1
votes
2 answers
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. c#
I am trying to use linq_to_excel
http://www.softinterface.com/DL/DL_UserData_Proc.ASP
This is my code:
var data = new LinqToExcel.ExcelQueryFactory();
data.FileName= @"FRM_DTA.xlsx";
data.AddMapping(x =>…
Anastasie Laurent
- 877
- 2
- 14
- 26
-3
votes
1 answer
why is my math resulting in a wrong bool?
I calculate a value out of 3 values to make a selection from a list:
var applicable = from b in discounts.ToList() where
(b["Interest Rate"].Cast() +
(-b["Discount/Premium"].Cast()) +
…
Julian Bechtold
- 167
- 1
- 12