LinqToExcel
LinqToExcel copied to clipboard
paulyoder
Use LINQ to retrieve data from spreadsheets and csv files
Add method to get worksheet names in the same order they appear in excel (for review/comments only)
This provides a method GetWorksheetNamesOrdered() to return the worksheet names in the same order as they would appear in excel. Works by extracting the contents of the excel file, finding...
Refactored IEnumerable calls to use 'yield return' for streaming data vs caching it all in a List and then returning it. This is the only way to use LinqToExcel w/...
I just ran across this and it looks promising for what I need. The only problem so far is it opens the file. All I have so far is: var...
I got InvalidOperationException when invoking your awesome library in transaction scope "ITransactionLocal interface is not supported". I can't solve this issue by extracting piece of code outside of transaction due...
Hi, I have to use LinqToExcel dll for read .csv file but when my any cell contain value F1,F2,F3 or F4 it is automatically replaced by 1,2,3,4(F1=1,F2=2,F3=3,F4=4). Kindly find below...
Hi, I've a requirement to filter out hidden rows in excel when it is uploaded to server. User wants to keep a lot of hidden data in excel and refer...
I met a confuse problem when I use the AddTransformation method. The problem is, in brief, I need to bind the transformation dynamically, which means the property name can be...
Hello, I am using your library and must say that it is wonderful. In one of my application I want to map the class in Class strict mode. All my...
Using LinqToExcel, I try to add custom column in excel sheet. I use this column to validate mapping and transaction status of row. For example in excel worksheet, there is...
