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
how to use ExcelColumn in LinqToExcel c#?
I had added Attributes to model I want my xls file to be bind. Like:
[ExcelColumn("Id")]
public string Id{ get; set; }
But after all I need to specify mapping anyway, because there is no AddMapping overload without any arguments:
var excel = new…
Arkadiusz
- 51
- 7
0
votes
1 answer
LinqToExcel Not Parsing Date
I am working with a client to import a rather larger Excel file (over 37K rows) into a custom system and utilizing the excellent LinqToExcel library to do so. While reading all of the data in, I noticed it was breaking on records about 80% in and…
Scott Salyer
- 2,165
- 7
- 45
- 82
0
votes
1 answer
LinqToExcel to EPPlus
I am moving a project to Azure. The project is using LinqToExcel, to read data from an Excel file.
LinqToExcel has a couple of dependencies, which is not supported in a Azure WebApp. So, i am migrating the code to EPPlus.
But, how could a lookup…
brother
- 7,651
- 9
- 34
- 58
0
votes
0 answers
LinqtoExcel trouble reading Dates
I have a CSV where one of two of the columns are dates, "Due Date" and "Review Date" and both have the format dd/MM/yyyy HH:mm
In my row to use for LinqToExcel these two columns are:
[ExcelColumn("Due Date")]
public DateTime DueDate { get; set;…
Omar.Ebrahim
- 862
- 1
- 10
- 30
0
votes
1 answer
LinqToExcel Is it possible to read the formula as a string
I've encountered a problem. I'm trying to read data from xlsx document using LinqToExcel. The data is retrieved but the document has cells which are interpreted as formulas with text like "=- Something". Is it possible to get those cells text and…
AOY
- 355
- 3
- 22
0
votes
1 answer
Import Excel Sheet Using LinqToExcel and not getting data propare read from excel to database in Asp.net Mvc c#?
I am trying to import excel data using LinqToExcel in my asp.net mvc project. I am importing an Excel that has 2 columns, 1 is Itemcode and other is Quantity.
It has 1 row.
Quantity column has value 0.8. When the Excel is uploaded, the value…
coder
- 39
- 8
0
votes
2 answers
LinqToExcel Header Mapping
I am using LinqToExcel to get the content of the excel file out.
With header mapping class like the following I can map the property of my class to a column in the excel:
public class Transaction
{
[ExcelColumn("Trans Id")]
public string…
Jin Tiger
- 1
- 1
0
votes
1 answer
I am trying to read a excel using linqToexcel. But i am not able to read when the headers are not in the first row.
LinqToexcel works only when the headers are in the first row.
How can i read by header names instead of first row .
Can any one help ?
Abhinav
- 1
0
votes
1 answer
Importing Excel Data(using LinqToExcel) Only works If worksheet is open C# MVC
I am importing excel data into my DB, which works perfectly fine, but only if the spreadsheet is open. If it is not open, it gives an error of "Expected table not in correct format", any ideas why ? Thanks in advance for any help!
[HttpPost]
…
AxleWack
- 1,801
- 1
- 19
- 51
0
votes
1 answer
Trying to get a worksheet names from an excel with LinqToExcel
I trying to load worksheet names from an excel using LinqToExcel.
using the following line of code
excelQueryFactory.GetWorksheetNames();
The worksheet names are ["$2,00","$5.00"].
but load ["2,00" , "5,00"]. The $ sign is missing.
What i do…
0
votes
1 answer
LinqtoExcel: Not able to send value from excel
First of all below is my Excel file.
+-----------------+-----------------------------+
| Data | Output |
+-----------------+-----------------------------+
| URL | http://www.gmail.com …
user1208480
0
votes
2 answers
Linq: is there any specific way to run the query?
I would like to know is if I have an excel file and I am trying to get data via linq query will this be posible?
Excel file format
+-----------------+-------------+
| Inputlocation | Inputvalue |
+-----------------+-------------+
| 1 …
user3338497
0
votes
0 answers
LinqToExcel Rounding decimal numbers when reading in data
I'm using LinqToExcel to read in data from an excel spreadsheet. However, when reading in data with numbers decimal places, it will round to the second decimal place. How do i stop this?
E.G excel data = 12.1552456
But LinqToExcel will only read the…
Tom
- 1
0
votes
1 answer
LinqToExcel Can't read all rows
I use LinqToExcel to read an Excel file in my C# console app. However it only reads the first 254 rows and ignores the rest. How to troubleshoot what's wrong?
PerlDev
- 437
- 1
- 5
- 15
0
votes
2 answers
How to read column names of Excel using LinqToExcel generated by EPPlus?
I want to read the column names of an excel file generated using EPPlus with LinqToExcel. This is what I have done so far
var excelFile = new ExcelQueryFactory(excelPath);
IQueryable excelSheetValues = from workingSheet in…
D Rao
- 41
- 2
- 8