Comments (4)
Query a specific worksheet by index
A specific worksheet can be queried by its index in relation to the other
worksheets in the spreadsheet.
The worsheets index order is based on their names alphatically; not the
order they appear in Excel. For example, if a spreadsheet contains 2
worksheets: "ten" and "eleven". Although "eleven" is the second worksheet
in Excel, it is actually the first index.
var excel = new ExcelQueryFactory("excelFileName");
var oldCompanies = from c in repo.Worksheet(1) //Queries the
second worksheet in alphabetical order
where c.LaunchDate < new DateTime(1900, 1, 1)
select c;
https://github.com/paulyoder/LinqToExcel#apply-transformations
On Thu, Feb 27, 2014 at 4:01 AM, ABC [email protected] wrote:
Is it possible to grab the first worksheet in the excel file irrespective
of its name?This will select sheet by name.
var excel = new ExcelQueryFactory("excelFileName");
var oldCompanies = from c in repo.Worksheet(1) //Queries the second
worksheet in alphabetical order
where c.LaunchDate < new DateTime(1900, 1, 1)
select c;Reply to this email directly or view it on GitHubhttps://github.com//issues/37
.
from linqtoexcel.
I am talking about the order they appear in Excel
from linqtoexcel.
you can try repo.Worksheet(0), but that might return the first
worksheet based on alphabetical order and not necessarily the order they
appear.
Unfortunately if it does sort it by alphabetical order, then you won't be
able to do what you want with LinqToExcel because it's a limitation of the
OLEDB engine that LinqToExcel uses.
On Fri, Feb 28, 2014 at 7:09 AM, ABC [email protected] wrote:
I am talking about the order they appear in Excel
Reply to this email directly or view it on GitHubhttps://github.com//issues/37#issuecomment-36348801
.
from linqtoexcel.
Related pull request: #51
from linqtoexcel.
Related Issues (20)
- Numbers returned as formatted value HOT 6
- İmpersonator Connection
- Start WorkSheet cast at desired row
- OleDbException when opening modified spreadsheet HOT 8
- Mapping Unmapped columns HOT 1
- Failure to map columns with square brackets in the header row HOT 1
- Read Zipped data
- Reading file returns only first record and only one property value HOT 1
- The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters...
- .NetCore 3.1 support? HOT 6
- Microsoft Access Database Engine Redistributable 2010 vs 2016 HOT 1
- How to map the merged columns ?
- New nuget package HOT 1
- WorksheetRangeNoHeader returning blank for cells with values
- Hangs on excelFile.GetWorksheetNames();
- DotNet 5 support HOT 2
- "Unspecified Error" when reading multiple files sequentially.
- Will the 'Microsoft.ACE.OLEDB.12.0 problem happen in azure?
- Log4Net dependency HOT 1
- Support for ListObjects (Excel Tables) ?
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from linqtoexcel.