Geeks With Blogs

News
Łukasz Kuryło's blog
  1. How to hide the tab with sheets in the bottom of the workbook.
  2. How to hide the headings.
  3. How to use a build-in function.
  4. How to send a keybord shortcut to the Excel.
  5. How to merge all cells in the sheet.


1. How to hide the tab with sheets in the bottom of the workbook.

             this.Application.ActiveWindow.DisplayWorkbookTabs = false;

2. How to hide the headings.

             this.Application.ActiveWindow.DisplayHeadings = false;

3. How to use a build-in function.

            Excel.WorksheetFunction func = this.Application.WorksheetFunction;
            string dec2bin = func.Dec2Bin(13, 8);


4. How to send a keybord shortcut to the Excel.

            SendKeys.Send("%cm");
or
             SendKeys.Send("{HELP}");

where

Key

Argument

ALT

 %
 CTRL
 ^

 SHIFT
 +


BACKSPACE


{BACKSPACE}, {BS}, or {BKSP}

BREAK

{BREAK}

CAPS LOCK

{CAPSLOCK}

DEL or DELETE

{DELETE} or {DEL}

DOWN ARROW

{DOWN}

END

{END}

ENTER

{ENTER} or ~

ESC

{ESC}

HELP

{HELP}

HOME

{HOME}

INS or INSERT

{INSERT} or {INS}

LEFT ARROW

{LEFT}

NUM LOCK

{NUMLOCK}

PAGE DOWN

{PGDN}

PAGE UP

{PGUP}

PRINT SCREEN

{PRTSC}

RIGHT ARROW

{RIGHT}

SCROLL LOCK

{SCROLLLOCK}

TAB

{TAB}

UP ARROW

{UP}

F1 throught F16

{F1}through {F16}


5. How to merge all cells in the sheet.

            this.Application.Cells.Select();
            this.Application.Cells.Merge(System.Type.Missing); Posted on Thursday, September 10, 2009 2:16 PM useful snippets , VSTO | Back to top

Copyright © Łukasz Kuryło | Powered by: GeeksWithBlogs.net