# Worksheet Methods
# Method: BreakTable(System.String)
Parameters:
| Fields | |
|---|---|
| tablename | String- name of the table |
# Method: ColumnAutoFit()
Automatially fits the column according to the given data
# Method: NumberOfColumns()
return- Returns the number of columns present in the excel worksheet
# Method: NumberOfRows()
return- Returns number of rows present in the excel sheet
# Method: MergeCells(System.Int32, System.Int32, System.Int32, System.Int32)
Parameters:
| Fields | |
|---|---|
| startrow | Number- specifies the starting row |
| startcolumn | Number- specifies the starting column |
| endrow | Number- specifies the ending row |
| endcolumn | Number- specifies the ending column |
# Method: MergeCells(System.Object, System.Object)
Parameters:
| Fields | |
|---|---|
| startcell | Object- specifies the starting cell |
| endcell | Object- specifies the end cell |
# Method: InsertRow(int selectrownumber)
Inserts a row in the excel sheet
Parameters:
| Fields | |
|---|---|
| selectrownumber | Number- selects the row number in the excel to insert the row |
# Method: DeleteRow(int selectrownumber)
Deletes a row in the excel sheet
Parameters:
| Fields | |
|---|---|
| selectrownumber | Number- selects the row number in the excel to delete the row |
# Method: InsertColumn(int selectColumnnumber)
Inserts a column in the excel sheet
Parameters:
| Fields | |
|---|---|
| selectcolumnnumber | Number- selects the column number in the excel to insert the column |
# Method: DeleteColumn(int selectColumnnumber)
Inserts a column in the excel sheet
Parameters:
| Fields | |
|---|---|
| selectcolumnnumber | Number- provide the column number to insert a column |
# Method: CopyandPaste(string CopyCellRange, string CopyEndCellRange, string PasteCopyCellRange, string PasteEndCellRange)
Copies the data and paste in a specific range
Parameters:
| Fields | |
|---|---|
| CopyCellRange | string- provides the start cell to copy |
| CopyEndCellRange | string - provide the end cell until you wish to copy |
| PasteCopyCellRange | string- provides the start cell to paste |
| PasteEndCellRange | string- provide the end cell until you wish to copy |
# Method: CopyandPaste(string CopyCellRange, string PasteCopyCellRange)
Copies the data and paste in a specific range
Parameters:
| Fields | |
|---|---|
| CopyCellRange | string- provides the start cell to copy |
| PasteCopyCellRange | string- provides the end cell to paste |
# Method: DeleteWorksheet(int sheetNumber)
Deletes the specified worksheet
Parameters:
| Fields | |
|---|---|
| sheetNumber | number- provides the sheetnumber to delete the worksheet |
# Method: DeleteWorksheet(string sheetName)
Deletes the specified worksheet
Parameters:
| Fields | |
|---|---|
| sheetNumber | string- provides the sheetnumber to delete the worksheet |
# Method: InsertNewWorksheet(string sheetname)
Specifies the Sheetname to be insert in the worksheet
Parameters:
| Fields | |
|---|---|
| sheetname | sheetname- provides the sheetname to insert in the worksheet |
# Method: InsertNewWorksheet(int sheetnumber)
Specifies the Sheetnumber to be insert in the worksheet
Parameters:
| Fields | |
|---|---|
| sheetnumber | int- provides the sheetname to insert in the worksheet |
# Method: MakeRangeofCellsBold(string CellIndex)
Converts the range of cells into bold
Parameters:
| Fields | |
|---|---|
| CellIndex | String- selects range of cells to convert as bold |
# Method: MakeRangeofCellsItalic(string CellIndex)
Converts the range of cells into Italic
Parameters:
| Fields | |
|---|---|
| CellIndex | String- selects range of cells to convert as italic |
# Method: MakeRangeofCellsUnderline(string Columnrow)
Converts the range of cells into underline
Parameters:
| Fields | |
|---|---|
| Columnrow | String- selects range of cells to convert as underline |
# Method: MakeSpecificCellBold(int rowcelldata, int columncelldata)
Converts the selected cells into bold
Parameters:
| Fields | |
|---|---|
| rowcelldata | Number- select the specified cell in the row |
| columncelldata | Number- select the specified cell in the column |
# Method: MakeSpecificCellitalic(int rowcelldata, int columncelldata)
Converts the selected cells into italic
Parameters:
| Fields | |
|---|---|
| rowcelldata | Number- select the specified cell in the row |
| columncelldata | Number- select the specified cell in the column |
# Method: MakeSpecificCellunderline(int rowcelldata, int columncelldata)
Converts the selected cells into underline
Parameters:
| Fields | |
|---|---|
| rowcelldata | Number- select the specified cell in the row |
| columncelldata | Number- select the specified cell in the column |
# Method: BorderSpecificCell(int row, int column)
Provides border for the specified cells
Parameters:
| Fields | |
|---|---|
| row | Number- select the specified row |
| column | Number- select the specified column |
# Method: AllBorders(string StartColumnrow, string EndColumnEndrow)
Provides border for selected range of rows and columns
Parameters:
| Fields | |
|---|---|
| StartColumnrow | string- Specifies the starting row and column |
| EndColumnEndrow | string- Specifies the End row and column |
# Method: OutsideBorder(string StartColumnrow, string EndColumnEndrow)
Provides outside border for selected range of rows and columns
Parameters:
| Fields | |
|---|---|
| StartColumnrow | string- Specifies the starting row and column |
| EndColumnEndrow | string- Specifies the End row and column |
# Method: CellBackgroundColor(string StartColumnrow, string EndColumnEndrow, string Color, int fontsize)
Provides background color to the selected range of rows and columns
Parameters:
| Fields | |
|---|---|
| StartColumnrow | string- Specifies the starting row and column |
| EndColumnEndrow | string- Specifies the End row and column |
| Color | string- Specifies the background color |
| fontsize | Number- Specifies the size of the font |
# Method: CellBackgroundWordsColor(string StartColumnrow, string EndColumnEndrow, string Color, int fontsize)
Provides background color to words in the selected range of rows and columns
Parameters:
| Fields | |
|---|---|
| StartColumnrow | string- Specifies the starting row and column |
| EndColumnEndrow | string- Specifies the End row and column |
| Color | string- Specifies the background color |
| fontsize | Number- Specifies the size of the font |
# Method: CellBackgroundColorSize(string StartColumnrow, string EndColumnEndrow, string FontColor, int fontsize, string CellColor)
Provides background color and size to words in the selected range of rows and columns
Parameters:
| Fields | |
|---|---|
| StartColumnrow | string- Specifies the starting row and column |
| EndColumnEndrow | string- Specifies the End row and column |
| FontColor | string- Specifies the color of the font |
| fontsize | Number- Specifies the size of the font |
| CellColor | string- Specifies the color of selected cell |
# Method: InsertImage(string ImagePath, float left, float Top, float Width, float Height)
Inserts a image in the Excel
Parameters:
| Fields | |
|---|---|
| Imagepath | string- Specifies the path of the image |
| left | string- adjust the left position |
| Top | string- adjust the position to top |
| Width | string- adjust the width |
| height | string- adjust the height |
# Method: ConvertCellValueintoText(string Startcolumnrow, string EndColumnrow)
Converts the cell value from general to text
Parameters:
| Fields | |
|---|---|
| Startcolumnrow | string- Specifies the starting row and column |
| EndColumnrow | string- Specifies the ending row and column |
# Method: FormatCellCurrency(string Startcolumnrow, string EndColumnrow)
Converts the cell value from general to currency
Parameters:
| Fields | |
|---|---|
| Startcolumnrow | string- Specifies the starting row and column |
| EndColumnrow | string- Specifies the ending row and column |
# Method: PivotMethod(string ExistingWorksheetName, string NewWorksheetName, string PivotTablestartIndex, string PivotTableendIndex, string PivotTableName, string RowField, string ColumnField, string FliterField, string ValueField)
A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information. Pivot tables are particularly useful if you have long rows or columns that hold values you need to track the sums of and easily compare to one another.
Parameters:
| Fields | |
|---|---|
| ExistingWorksheetname | string- Specifies the existing worksheet |
| NewWorksheetName | string- Specifies the new worksheet |
| PivottablestartIndex | string- specifies the starting index of table |
| PivotTableendIndex | string- specifies the ending index of table |
| RowField | string- specifies the Table row |
| ColumnField | string- specifies the table column |
| Filterfield | string- specifies the filter value |
| ValueField | string- specifies the table data |
# Method: PivotTableMethod(string ExistingWorksheetName, string NewWorksheetName, string PivotTablestartIndex, string PivotTableendIndex, string PivotTableName, List(string) RowField, List(string) ColumnField, List(string) FilterField, List(string) ValueField)
A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information. Pivot tables are particularly useful if you have list of rows field or columns field or filter field and value field that hold values you need to track it easily.
Parameters:
| Fields | |
|---|---|
| ExistingWorksheetname | string- Specifies the existing worksheet |
| NewWorksheetName | string- Specifies the new worksheet |
| PivottablestartIndex | string- specifies the starting index of table |
| PivotTableendIndex | string- specifies the ending index of table |
| RowField | string- specifies the list of rows in the table |
| ColumnField | string- specifies the list of columns in the table |
| Filterfield | string- specifies the list of filter value |
| ValueField | string- specifies the list of table datas |