Scroll row in excel through C#

Question

0.00/5 (No votes)

See more:

Hello,
I have excel sheet created via Interop (C#)
having 2 sheets,sheets 1 has customername(say 1000) as hyperlink,after click on link it moves to 2nd sheet.
I want the cell to moved(of sheet2) to display on top(first row)
My code is like this

C#

strCol = (char)(asciiChar) + rowNumber.ToString();
range = sheet.get_Range(strCol, strCol);
sheet.Hyperlinks.Add(range, "#" + sheet1.Name + "!C" + moveToRow, Type.Missing, "Go to", dsCustomer.Tables[0].Rows[i][1].ToString());0].Rows[i][1].ToString());

lets see.
in sheet 1 i have 1k customerlist with link, i have to fill sales data for items assigned to customer which i placed in sheet2 ,now if items are 100 for each customer cust1 displayed on row1 then 100 items rows and 2nd customer on row 103 and so on.
When i click on 2nd customer from sheet1 it goes to 103rd row in sheet2 and it display in middle or below in the screen and user wants to scroll it for inserting data.
My requirement is my 103rd row should displayed on top of the sheet so no need to scroll.
Your help is appreciated.
Thanks in advance

Posted 21-Mar-13 18:20pm

Pramilak

Updated 21-Mar-13 19:26pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prakash Thirumoorthy · Answer 1 · 2013-03-21T20:09:00

Solution 1

hi,

It is simple to using set cursor on that specified cell. U know that which cell u want to show on the top.

For an example u have select the range of the cell

strCol="A103";

range = sheet.get_Range(strCol, strCol);
ranse.select();

Try this it will work.

Regards,
Prakash.T

Posted 21-Mar-13 20:09pm

Prakash Thirumoorthy

Comments

Pramilak 22-Mar-13 6:12am

Hello,
It will not work,the row is not shifting at top,it will remains where it is.
Any other solution?