SSIS - Skipping rows and stripping subtotals in Excel

re: SSIS - Skipping rows and stripping subtotals in Excel

Asha — Thu, 12 Nov 2009 22:48:42 GMT

This was an awesome site.. It really saved time versus some of the other things that people were suggesting to do...

re: SSIS - Skipping rows and stripping subtotals in Excel

Chamara — Wed, 11 Nov 2009 21:15:44 GMT

Murray,

That is simply awsome! You saved my day.

re: SSIS - Skipping rows and stripping subtotals in Excel

Madan — Mon, 02 Nov 2009 13:49:36 GMT

How to skip TOP 2 OR 3 rows in Excel using c#

re: SSIS - Skipping rows and stripping subtotals in Excel

Murray — Thu, 17 Sep 2009 21:58:51 GMT

To answer a couple of the questions posted:

1) To change the OpenRowSet property in SSIS, right click the OLEDB source and select "Show Advanced Editor". Go to Component Properties tab. It's the last property. Set it like this: MySheet$A1:X10

2) To use an entire column, and not hve to count the records, use this syntax: MySheet$A5:X

This example starts on row 5 and process all records in columns A thru X.

Murray

re: SSIS - Skipping rows and stripping subtotals in Excel

zinou92 — Wed, 25 Mar 2009 15:52:13 GMT

Great, thank 's a lot for this magic property

re: SSIS - Skipping rows and stripping subtotals in Excel

Nutshell — Tue, 24 Mar 2009 22:53:21 GMT

Thanks - this worked out perfectly for what I was needing (skipping first 4 rows - and ignoring column A)

re: SSIS - Skipping rows and stripping subtotals in Excel

anoopmms — Tue, 10 Mar 2009 08:38:41 GMT

Thanks a lot..... this solved my prblm

re: SSIS - Skipping rows and stripping subtotals in Excel

Pete — Tue, 20 Jan 2009 06:32:27 GMT

I tried using a large number (4000) that would probably cover the upper bound of possible rows. And then used the table(0).row.count function to find the number of actual data rows returned but the count number didn't always have the correct number of data rows. If I had 5 data rows the count would be 5. If I had 7 data rows the count would be 95

re: SSIS - Skipping rows and stripping subtotals in Excel

Pete — Mon, 19 Jan 2009 23:27:13 GMT

Is there a way to just skip the first five lines. I'm using the "Sheet1$B15:Z2000" which works great. The problem I am having is I know where the data starts and how many columns but the number of rows I'll be pulling is unknown. Is there a way to just specify only the first cell "Sheet1$B15:*"

re: SSIS - Skipping rows and stripping subtotals in Excel

narsi — Tue, 30 Dec 2008 19:36:42 GMT

it worked, earlier i have tried many other ways but unsuccessful, this worked