# ExcelLibrary
Business processes often involves reading/writing/modifying data in Excel. Excel library helps the developers to create bots using excel based functions. Using Excel library developers can effortlessly perform various operations such as create/delete/update etc over any row/column/range in an Excel sheet
# Constructor - #ctor()
# Methods
- BreakTable(System.String)
- CloseWorkBook()
- ColumnAutoFit()
- CreateWorkBook(System.String)
- CreateWorkSheet()
- CreateWorkSheet(System.String)
- DeleteCellData(System.Int32, System.Int32)
- DeleteCellData(System.String)
- DeleteCurrentWorkBook()
- DeleteRangeData()
- DeleteRangeData(System.String, System.String)
- DeleteWorkSheet()
- DeleteWorkSheet(System.String)
- InsertRow(int selectrownumber)
- DeleteRow(int selectrownumber)
- InsertColumn(int selectColumnnumber)
- DeleteColumn(int selectColumnnumber)
- CopyandPaste(string CopyCellRange, string CopyEndCellRange, string PasteEndCellRange)
- CopyandPaste(string CopyCellRange, string PasteCopyCellRange)
- DeleteWorksheet(int sheetNumber)
- DeleteWorksheet(string sheetName)
- InsertNewWorksheet(string sheetname)
- InsertNewWorksheet(int sheetnumber)
- MakeRangeofCellsBold(string CellIndex)
- MakeRangeofCellsItalic(string CellIndex)
- MakeRangeofCellsUnderline(string Columnrow)
- MakeSpecificCellBold(int rowcelldata, int columncelldata)
- MakeSpecificCellItalic(int rowcelldata, int columncelldata)
- MakeSpecificCellUnderline(int rowcelldata, int columncelldata)
- BorderSpecificCell(int row, int column)
- AllBorders(string StartColumnrow, string EndColumnEndrow)
- OutsideBorder(string StartColumnrow, string EndColumnEndrow)
- CellBackgroundColor(string StartColumnrow, string EndColumnEndrow, string Color, int fontsize)
- CellBackgroundWordsColor(string StartColumnrow,string EndColumnEndrow, string Color, int fontsize)
- CellBackgroundColorSize(string StartColumnrow,string FontColor,string CellColor)
- InsertImage(string ImagePath,float left,float Top, float Width, float Height)
- ConvertCellValueintoText(string Startcolumnrow, string EndColumnrow)
- FormatCellCurrency(string Startcolumnrow, string EndColumnrow)
- PivotMethod(string ExistingWorksheetName, string NewWorksheetName,string PivotTablestartIndex)
- PivotTableMethod(string ExistingWorksheetName,string NewWorksheetName,string PivotTablestartIndex
- Dispose()
- GetApplicationInstance()
- GetCellData(System.Int32, System.Int32)
- GetCellData(System.String)
- GetCompleteData()
- GetRangeData(System.Int32, System.Int32, System.Int32, System.Int32)
- GetRangeData(System.Int32, System.Int32, System.String)
- GetRangeData(System.String, System.Int32, System.Int32)
- GetRangeData(System.String, System.String)
- GetSheetName()
- GetWorkBookInstance()
- GetWorksheetInstance()
- MergeCells(System.Int32, System.Int32, System.Int32, System.Int32)
- MergeCells(System.Object, System.Object)
- NumberOfColumns()
- NumberOfRows()
- OpenWorkBook(System.String)
- OpenWorkSheet(System.Int32)
- OpenWorkSheet(System.String)
- RenameWorkSheet(System.String)
- RenameWorkSheet(System.String, System.String)
- SaveAndCloseWorkBook()
- SaveAsWorkBook(System.String)
- SaveWorkBook()
- SetCellData(System.Int32, System.Int32, System.Double)
- SetCellData(System.Int32, System.Int32, System.Object)
- SetCellData(System.Int32, System.Int32, System.String)
- SetCellData(System.String, System.String)
- SetCellFormula(System.String, System.String)
- SetCellFormula(System.String, System.String, System.String)