LinqToExcel
LinqToExcel copied to clipboard
paulyoder
Use LINQ to retrieve data from spreadsheets and csv files
I have a string column that has 3 cells with numbers in string format, and then 2 cells that contain strings that start with an N followed by some numbers....
See this stackoverflow case https://stackoverflow.com/a/28862382/4516125
There are two changes in this PR: 1. If the class implements IContainsUnmappedCells, then initialize the collection UnmappedCells, so the user has to only implement the interface. Otherwise, the user...
Hello, Today I have problem while trying to map the merged colums like the example image (from Internet) Does any ways to map that ? Best regards,
I have installed the 64 version of "AccessDatabaseEngine_X64.exe" however for file .xlxs I m getting the error The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. But file .xls...
Does the library only work with Microsoft Access Database Engine 2010 Redistributable? Or for Office 365 can I use Microsoft Access Database Engine 2016 Redistributable? Thanks.
Hi, I have an issue reading the attached file. The records variable has only one record even though there are 100+ records in the Excel file. [Report.xlsx](https://github.com/paulyoder/LinqToExcel/files/4689752/Report.xlsx). I had to...
Hello. I excute my App in local server and this work fine. but when I run this in web host windows server 2016 64bits, the app run one time and...
  ```cs var worksheetName = excel.GetWorksheetNames().FirstOrDefault(); columns = excel.GetColumnNames(worksheetName).ToList(); var named=excel.GetNamedRanges(worksheetName); if (worksheetName != null) { records = excel.Worksheet(worksheetName).ToList(); } ``` this should be pretty self explanatory. its skipping...
