Excel Functions
Functions to manipulate Microsoft Excel objects, the required Imports:
VB
Imports System.Data
Imports System.IO
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Interop.Excel
Imports Microsoft.Office.Interop.Excel.Constants
Imports Microsoft.Office.Interop.Excel.XlDirection
Imports Microsoft.Office.Interop.Excel.XlFindLookIn
Imports Microsoft.Office.Interop.Excel.XlLookAt
Imports Microsoft.Office.Interop.Excel.XlSearchDirection
Imports Microsoft.Office.Interop.Excel.XlSearchOrder
Imports Microsoft.Office.Interop.Excel.XlSortDataOption
Imports Microsoft.Office.Interop.Excel.XlSortMethod
Imports Microsoft.Office.Interop.Excel.XlSortOn
Imports Microsoft.Office.Interop.Excel.XlSortOrder
Imports Microsoft.Office.Interop.Excel.XlYesNoGuessThe Functions list:
- Column Scanning – Return First Empty Cell Row (Top to Bottom)
- Column Scanning – Return First Not Empty Cell Value (Top to Bottom)
- Column Scanning – Return Last Not Empty Cell Value (Top to Bottom)
- Data Import/Export – Convert ListObject to DataTable
- Data Import/Export – Load Excel Sheet to DataTable
- Data Import/Export – Read Excel Sheet to DataTable
- Data Import/Export – Write Datatable to Sheet
- Row Scanning – Return First Not Empty Cell Value (Left to Right)
- Row Scanning – Return Last Not Empty Cell Value (Left to Right)
- Sheet Custom Property – Get Sheet Custom Properties To CSV String
- Sheet Custom Property – Get Sheet Custom Properties To Datatable
- Sheet Custom Property – Get Sheet Custom Property
- Sheet Custom Property – Remove All Custom Properties from a Sheet
- Sheet Custom Property – Set Sheet Custom Property
- Sheet Custom Property – Sheet Custom Property Exists
- Sheet Custom Property – Write Sheet Custom Properties
- Table Manipulation – Get ListObject
- Table Manipulation – ListObject First Blank Row
- Table Manipulation – Lookup List Object Value
- Table Manipulation – Set ListObject Headers
- Table Manipulation – Sort Table
- Utility – Add Comment
- Utility – Column to Index
- Utility – Get First Blank Row
- Utility – Get Row Range Interval
- Utility – Index to Column
- Workbook Access – Get First Sheet Name
- Workbook Access – Is Excel File Opened
- Workbook Access – Open WorkBook
- Worksheet Search – Find Text Coordinates
- Worksheet Search – Get Element Start Row
- Worksheet Search – Is Sheet Suitable