LinqToExcel
LinqToExcel copied to clipboard
paulyoder
Use LINQ to retrieve data from spreadsheets and csv files
Hello, I am getting the following exception: System.AccessViolationException: 'Attempted to read or write protected memory. This is often an indication that other memory is corrupt.' This is my code: ```...
I am getting this error System.Runtime.InteropServices.SEHException: 'External component has thrown an exception.' When accessing xlsx files. No changes to the code, it just stopped working. ```cs var excel = new...
Hi, Is anyone know, how i can get the real value of a cell and not the formattedValue? Thanks for your help PS: With interop is good, but i can't...
I get the following error most of the times and sometimes it works with one file but then it doesn't work anymore and I get the same error. Can anyone...
I'm reading data from an .xlsx file. But it seems that all cell values are truncated after 255 characters: `return row[colIndex].Value.ToString();` Is there anything I can do to get all...
Is it possible to have the implementation returns each row using yield rather than filling a List in memory and returning that? This would really help me out as I...
Hello, How can I set my class property with other value instead null, if corresponding cell in excel file is null?
The following Linq query works: ``` Dim Res = (From x In oExcelFile.Worksheet(Of clsWLFeatureRec)(WorksheetName) Where x.FeatDesc.StartsWith("Credit for") Select x).ToList ``` This does not: ``` Dim Res = (From x In...
It's telling me `'HasValue' is not a valid column name`. when I'm targeting the **HasValue** property of my **IncludeInFlex** header property of my class (which is nullable). ``` public class...
I have a complicated multi-worksheet spreadsheet that I need to custom import. Headers are in the first row, but some sheets have pretty long text for the headers, and they...
