No announcements
Found 751821 threads
-
2 VotesLooping Through Excel Filtered Range.
But this is not very efficient. Can anybody make a suggestion on how to loop through just the visible rows? I was thinking of using a range ...Answered | 5 Replies | 20801 Views | Created by Mr Chubbsy - Monday, July 23, 2012 3:17 PM | Last reply by hafeez esmail - Thursday, June 27, 2013 2:22 AM
-
0 Votes
Excel 2010 - filtered range - VB
Using Excel 2010 and VB I am having trouble figuring out how to address a filtered range. When the user filters the rows on a sheet, I want to recalculate using the ...Answered | 5 Replies | 4859 Views | Created by rgold20 - Thursday, March 31, 2011 3:22 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, March 31, 2011 8:00 PM -
0 Votes
Looping through rows filtered by FilterExpression
on the filtered rows. How can I retrieve the table/rows from the filtered rows only? I know that I can get the Table from the RowDataBound event ...Answered | 2 Replies | 7 Views | Created by Anonymous - Tuesday, April 7, 2009 6:02 PM | Last reply by Anonymous - Friday, April 10, 2009 3:34 AM -
0 Votes
Looping through an excel spreadsheet
Steve, When looping through tables, I assume that you will want to use "Table name from variable" in the Excel Source, When ...Answered | 41 Replies | 20646 Views | Created by Steve Furby - Thursday, February 23, 2006 8:20 PM | Last reply by dedbeat - Monday, January 19, 2009 6:19 PM -
0 Votes
Looping through an excel spreadsheet
I think you can simplify your loops. Store the required ranges in an array/list, loop through the array/list and then loop through the cells of the ...Answered | 4 Replies | 11395 Views | Created by Spawn10 - Tuesday, November 23, 2010 5:18 PM | Last reply by Mike Dos Zhang - Sunday, November 28, 2010 11:22 AM -
1 Votes
Excel "Filtered Range Copy to Word" bug
OK. So there is a difference in behavior of Excel 2003 and 2007/2010. Excel 2003 reduces the size of object when the cells are hidden (RowHeight set to zero). Any ...Answered | 4 Replies | 2835 Views | Created by Abhimanyu Sirohi - Tuesday, February 14, 2012 5:36 AM | Last reply by Abhimanyu Sirohi - Wednesday, February 15, 2012 12:31 PM -
0 Votes
Looping Through Excel Columns (256 columns)
thats if i wanted to extract the whole excel sheet, wht i want to do is looping on the columns(256), loop on each column and extract it where i want.Answered | 6 Replies | 5288 Views | Created by Moussa El-Annan - Wednesday, September 19, 2007 9:17 AM | Last reply by Moussa El-Annan - Wednesday, September 19, 2007 3:08 PM -
2 Votes
Avoiding looping through Dictionary
construct? Either you loop through the Dictionary, or you loop through the string, but in any case, you're looping somewhere. What are you trying to optimize ...Answered | 6 Replies | 4326 Views | Created by Bhakti Abhyankar - Thursday, March 24, 2011 7:40 AM | Last reply by Bhakti Abhyankar - Thursday, March 24, 2011 12:24 PM -
0 Votes
Looping through Excel 2007 tables in SSIS?
, however I need to loop through Excel 2007 tables, which is not supported via the .Net Connection. Is there a way to loop through the 2007 sheets without ...Answered | 4 Replies | 5530 Views | Created by Steve_Walker - Wednesday, September 1, 2010 11:03 PM | Last reply by COZYROC - Thursday, September 2, 2010 10:20 PM -
0 Votes
looping through excel cells using VBA
Code Snippet Dim datRng As RangeAnswered | 3 Replies | 4384 Views | Created by Born2Achieve - Monday, October 6, 2008 9:58 AM | Last reply by Born2Achieve - Tuesday, October 7, 2008 5:25 AM -
0 Votes
Reading From an Excel, looping through rows
I was wondering if you could help me with this. What I am trying to achieve is to open a excel sheet and loop through each row in the ...Answered | 13 Replies | 118 Views | Created by Anonymous - Thursday, March 5, 2009 9:31 AM | Last reply by Anonymous - Thursday, March 5, 2009 12:29 PM -
0 Votes
Looping through Excelsheet records
). There is a way to do what you need inside excel whether you can do this from .NET depends if you have Excel running. Let me know how you looping through the ...Answered | 1 Replies | 3031 Views | Created by Mario_lem - Saturday, August 4, 2007 12:25 PM | Last reply by Derek Smyth - Saturday, August 4, 2007 2:38 PM -
0 Votes
Loop Through Excel Named Range in C#
Hi - I'm developing a excel application using VSTO and C#. So I have a named range ("myRange", rows count =1000, ...Answered | 2 Replies | 4653 Views | Created by Mark from NJ - Wednesday, February 25, 2009 6:10 AM | Last reply by Mark from NJ - Wednesday, February 25, 2009 2:56 PM -
0 Votes
GEOMEAN filtered on Date range
I belive I have a working prototype the filters to a date range! Finally figured out a way to filter the log10 expression to the date range I wasAnswered | 1 Replies | 4752 Views | Created by Chad - TSP - Tuesday, February 15, 2011 4:30 PM | Last reply by Chad - TSP - Tuesday, February 15, 2011 8:06 PM -
0 Votes
Looping through a PlaceHolder
User-406581649 posted This is my code for the looping through a placeholder control but doesn't quite work. If someone could help or tell me where I have ...Answered | 5 Replies | 10 Views | Created by Anonymous - Sunday, February 26, 2012 6:29 PM | Last reply by Anonymous - Monday, February 27, 2012 5:54 PM -
0 Votes
Looping through CTE
No, since you can only use cte in one statement, so I'm not sure what exactly can you do (what kind of looping to be just one statement)?For every expert, there isAnswered | 3 Replies | 8346 Views | Created by DaveDB - Wednesday, March 2, 2011 10:13 PM | Last reply by --CELKO-- - Thursday, March 3, 2011 3:51 AM -
0 Votes
Looping through a gridview
User-627724879 posted You will not be able to get the rest of the dataset by looping through the rows in the datagrid or gridview, or even the repeater or datalist ...Answered | 1 Replies | 17 Views | Created by Anonymous - Friday, July 27, 2007 2:15 PM | Last reply by Anonymous - Friday, July 27, 2007 2:59 PM -
0 Votes
Looping through Variables
)) they will have another window pop up with all the records from the original table but filtered on the county that they clicked on. This is what I have so far which seems to ...Answered | 1 Replies | 1194 Views | Created by Scott Bachman88 - Wednesday, August 29, 2012 10:03 PM | Last reply by Stefan Hoffmann - Thursday, August 30, 2012 7:11 AM -
0 Votes
Looping Through A Table
http://stackoverflow.com/questions/20463365/looping-through-column-names-with-dynamic-sql With Regards, Krunal ParekhAnswered | 7 Replies | 7 Views | Created by Anonymous - Friday, October 23, 2015 9:05 AM | Last reply by Anonymous - Sunday, October 25, 2015 10:52 PM -
0 Votes
Looping through DataTable
regarding the "Foreach" cycle realization details - certainly method is not called each time when you need row for the second variant - only enumerator is saved by reference ...Answered | 5 Replies | 4 Views | Created by Anonymous - Monday, January 25, 2010 9:30 AM | Last reply by Anonymous - Monday, January 25, 2010 2:10 PM - Items 1 to 20 of 751821 Next ›
No announcements
