{"id":349,"date":"2025-10-25T10:03:54","date_gmt":"2025-10-25T08:03:54","guid":{"rendered":"https:\/\/www.silverice.it\/IpercubeTechWP1\/?page_id=349"},"modified":"2025-10-27T19:35:38","modified_gmt":"2025-10-27T18:35:38","slug":"excel-functions","status":"publish","type":"page","link":"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/","title":{"rendered":"Excel Functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Functions to manipulate Microsoft Excel objects, the required Imports:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Geist-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-Geist-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#D4D4D4;--cbp-line-number-width:calc(2 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 10px 16px;margin-bottom:-2px;width:100%;text-align:left;background-color:#2b2b2b;color:#c7c7c7\">VB<\/span><span role=\"button\" tabindex=\"0\" style=\"color:#D4D4D4;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>Imports System.Data\nImports System.IO\nImports Microsoft.Office.Interop\nImports Microsoft.Office.Interop.Excel\nImports Microsoft.Office.Interop.Excel.Constants\nImports Microsoft.Office.Interop.Excel.XlDirection\nImports Microsoft.Office.Interop.Excel.XlFindLookIn\nImports Microsoft.Office.Interop.Excel.XlLookAt\nImports Microsoft.Office.Interop.Excel.XlSearchDirection\nImports Microsoft.Office.Interop.Excel.XlSearchOrder\nImports Microsoft.Office.Interop.Excel.XlSortDataOption\nImports Microsoft.Office.Interop.Excel.XlSortMethod\nImports Microsoft.Office.Interop.Excel.XlSortOn\nImports Microsoft.Office.Interop.Excel.XlSortOrder\nImports Microsoft.Office.Interop.Excel.XlYesNoGuess<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M4.5 12.75l6 6 9-13.5\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M16.5 8.25V6a2.25 2.25 0 00-2.25-2.25H6A2.25 2.25 0 003.75 6v8.25A2.25 2.25 0 006 16.5h2.25m8.25-8.25H18a2.25 2.25 0 012.25 2.25V18A2.25 2.25 0 0118 20.25h-7.5A2.25 2.25 0 018.25 18v-1.5m8.25-8.25h-6a2.25 2.25 0 00-2.25 2.25v6\"><\/path><\/svg><\/span><pre class=\"shiki dark-plus\" style=\"background-color: #1E1E1E\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #D4D4D4\">Imports System.Data<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports System.IO<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.Constants<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlDirection<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlFindLookIn<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlLookAt<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSearchDirection<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSearchOrder<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSortDataOption<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSortMethod<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSortOn<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlSortOrder<\/span><\/span>\n<span class=\"line\"><span style=\"color: #D4D4D4\">Imports Microsoft.Office.Interop.Excel.XlYesNoGuess<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The Functions list:<\/p>\n\n\n<ul class=\"wp-block-page-list\"><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlt2b_returnfirstemptycellrow\/\">Column Scanning &#8211; Return First Empty Cell Row (Top to Bottom)<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlt2b_returnfirstnotemptycellvalue\/\">Column Scanning &#8211; Return First Not Empty Cell Value (Top to Bottom)<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlt2b_returnlastnotemptycellvalue\/\">Column Scanning &#8211; Return Last Not Empty Cell Value (Top to Bottom)<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlconvertlistobject2table\/\">Data Import\/Export &#8211; Convert ListObject to DataTable<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlloadexceltable\/\">Data Import\/Export &#8211; Load Excel Sheet to DataTable<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlreadexcelsheettodatatable\/\">Data Import\/Export &#8211; Read Excel Sheet to DataTable<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlwritedatatable2sheet\/\">Data Import\/Export &#8211; Write Datatable to Sheet<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xll2r_returnfirstnotemptycellvalue\/\">Row Scanning &#8211; Return First Not Empty Cell Value (Left to Right)<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xll2r_returnlastnotemptycellvalue\/\">Row Scanning &#8211; Return Last Not Empty Cell Value (Left to Right)<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetsheetcustompropertiestocsvstring\/\">Sheet Custom Property &#8211; Get Sheet Custom Properties To CSV String<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetsheetcustompropertiestodatatable\/\">Sheet Custom Property &#8211; Get Sheet Custom Properties To Datatable<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetsheetcustomproperty\/\">Sheet Custom Property &#8211; Get Sheet Custom Property<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlclearsheetallcustomproperties\/\">Sheet Custom Property &#8211; Remove All Custom Properties from a Sheet<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlsetsheetcustomproperty\/\">Sheet Custom Property &#8211; Set Sheet Custom Property<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlpropertyexists\/\">Sheet Custom Property &#8211; Sheet Custom Property Exists<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlwritesheetcustomproperties\/\">Sheet Custom Property &#8211; Write Sheet Custom Properties<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetlistobject\/\">Table Manipulation &#8211; Get ListObject<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xllistobjectfirstblankrow\/\">Table Manipulation &#8211; ListObject First Blank Row<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xllookuplistobjectvalue\/\">Table Manipulation &#8211; Lookup List Object Value<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlsetlistobjectheaders\/\">Table Manipulation &#8211; Set ListObject Headers<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlsorttable\/\">Table Manipulation &#8211; Sort Table<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xladdcomment\/\">Utility &#8211; Add Comment<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlcolumn2index\/\">Utility &#8211; Column to Index<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlfirstblankrow\/\">Utility &#8211; Get First Blank Row<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetrowrangeinterval\/\">Utility &#8211; Get Row Range Interval<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlindex2column\/\">Utility &#8211; Index to Column<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetfirstsheetname\/\">Workbook Access &#8211; Get First Sheet Name<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlisexcelfileopened\/\">Workbook Access &#8211; Is Excel File Opened<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlopenworkbook\/\">Workbook Access &#8211; Open WorkBook<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlfindtextcoordinates\/\">Worksheet Search &#8211; Find Text Coordinates<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlgetelementstartrow\/\">Worksheet Search &#8211; Get Element Start Row<\/a><\/li><li class=\"wp-block-pages-list__item\"><a class=\"wp-block-pages-list__item__link\" href=\"https:\/\/www.silverice.it\/IpercubeTechWP1\/ipercube-utilities\/excel-functions\/xlissheetsuitable\/\">Worksheet Search &#8211; Is Sheet Suitable<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>Functions to manipulate Microsoft Excel objects, the required Imports: The Functions list:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":155,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-349","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/pages\/349","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/comments?post=349"}],"version-history":[{"count":6,"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/pages\/349\/revisions"}],"predecessor-version":[{"id":673,"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/pages\/349\/revisions\/673"}],"up":[{"embeddable":true,"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/pages\/155"}],"wp:attachment":[{"href":"https:\/\/www.silverice.it\/IpercubeTechWP1\/wp-json\/wp\/v2\/media?parent=349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}