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
3
votes
1 answer
How to get the LinqToExcel 64 bit build
Can anybody please provide me with a link to a 64-bit build of linq-to-Excel? I see references to it in several posts and on the official site (https://github.com/paulyoder/LinqToExcel), but I am unable to locate a download of the 64 bit…
inkognito
- 33
- 4
3
votes
1 answer
LinqToExcel on Windows7 64 bit with office 64bit
I have created windows forms application using linqtoexcel to read excel files it runs fine on windows 7 32/64 bit with office 32 bit but on windows 64 bit with office 64 it throws 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local…
Ketan
- 43
- 1
- 6
3
votes
1 answer
LinkToExcel group by and Sum
I am trying to use LinqToExcel to solve an issue, and I am having some problems. We get this excel file that tells us the product that we will be receiving. I need to read that file and save the updates to the database. Everything is fine except…
BriceTRockindale
- 309
- 1
- 4
- 15
3
votes
1 answer
Extremely Slow Linq to Excel
I am trying to create an application that will extract some data out of an automatically generated excel file. This can be very easily done with Access but the file is in Excel and the solution must be a one button sort of thing.
For some reason,…
Hisham Saleh
- 45
- 6
3
votes
3 answers
linq "let" division, then orderby ascending
I have this data, and I'm using linqToExcel:
I'm trying to get inflation divided by GDP...then order them ascending, but I can't get it right.
var people = from x in excel.Worksheet("Sheet1")
let c =…
marseilles84
- 396
- 2
- 7
- 21
3
votes
2 answers
LinqToExcel blank rows
I am using LinqToExcel to easily import Excel data into SQL Server.
var fileName = ConfigurationManager.AppSettings["ExcelFileLocation"];
var excel = new ExcelQueryFactory(fileName);
var employees =…
monstro
- 6,254
- 10
- 65
- 111
3
votes
1 answer
LinqToExcel External table is not in the expected format
I've been using LinqToExcel to parse an exel document for a while and suddenly it's stoped working.
I'm getting the following error:
External table is not in the expected format.
Any ideas why this is happening? Or how to fix?
if…
Mantisimo
- 4,203
- 5
- 37
- 55
2
votes
2 answers
How to force delete a file used by another process in Asp.net core
I'm working on an ASP.NET Core 5 project. I have this action method:
public async Task CreateV3EnterCheckFile(IFormFile MarksFile)
{
var filesCount = Directory.GetFiles("Uploads").Length;
string path = Path.Combine("Uploads",…
JOCKH
- 339
- 4
- 15
2
votes
2 answers
Getting "Could not find an implementation of the query pattern for source type 'ExcelQueryable'. " Error
I am using LinqToExcel Nuget package to read excel file.
Below is my code
var excelFile = new ExcelQueryFactory("DeployQueues");
var tableData = from z in excelFile.Worksheet("Data")
select…
Ashutosh B Bodake
- 1,304
- 1
- 19
- 31
2
votes
2 answers
Using LinqToExcel to Create XML
I'm trying to build an XML file from an Excel spreadsheet (no header row). This will be part of a service on a server, so I really don't want to use the MS Office PIO files. I found LinqToExcel on google and tried this code:
var clientExcel = new…
EoRaptor013
- 1,735
- 4
- 18
- 31
2
votes
1 answer
GetColumnName() LinqToExcel for csv file throw error The Microsoft Jet database engine could not find the object 'Sheet1$.txt'
I am using linqToExcel dll from to read a csv file and query the csv file the data . I also neeed the names of columns (Header ) from csv .
when i try to run the following code as per the document mentioned
its throw an error message as follow :…
rahularyansharma
- 11,156
- 18
- 79
- 135
2
votes
1 answer
Check illegal characters on uploaded Excel file in asp.net mvc
I'm using asp.net MVC 4 to make a website where user can upload .xlsx file and save the data to MSSQL table. I want to make sure that there is no illegal characters such as SQL injection statements in the file before saving the datas. So far I…
Shihan Khan
- 2,180
- 4
- 34
- 67
2
votes
1 answer
LinQtoExcel using asp fileupload
im having problems with this function. so basically a user will upload an excel file .xls (2003 version) then once the import button is clicked it will read the excel file and import it into the sql database.
here is my code
protected void…
evil.toaster
- 45
- 5
2
votes
2 answers
Linq-To-Excel from CSV file, decimal separator missing
I'm using the Linq-To-Excel package to read a CSV file. I created a class for holding the results:
public class ReconciliationLineLinqToExcel
{
public string OperatingUnit { get; set; }
public Int64 CustomerTenantId { get; set; }
public…
Marc
- 89
- 6
2
votes
2 answers
Return a list of data from Excel
I have a data in Excel and I have written a method to return the data but I don't know how to return them in a list. Here is my method :
public List Excel(string sort, string sortDir, int rowsPerPage, int page, out int count, out string…
Beslinda N.
- 4,808
- 5
- 27
- 33