How to connect to SharePoint Online with IP address

Question

I would like to know how to successfully connect to spo service url with a IP address.

Connect-SPOService https://13.xxx.xxx.9-admin.sharepoint.com

Answer 1

How about triggering the Excel export manually on button click using kendo.ooxml.Workbook combined with kendo.saveAs?

I have made up a Kendo Dojo example. Let me know if this is what you need. Additionally, if you need to retrieve the name of your screen, there are some examples of how to do this here

EDIT

Below is an example of the export generated by the Dojo example when the "Click to Export" button is pressed. Note that the title is custom.

Not sure why this would not work for you, but try the following example with your code and see what happens. Basically, you can hook up the custom function to handle the export button click as follows:

$("#exportButton").kendoButton({
    click: function () {
       var grid = $("#yourGrid").getKendoGrid();

       // declare `rows` and supply your own column names
       var rows = [{
           cells: [
               { value: "ContactTitle" },
               { value: "CompanyName" },
               { value: "Country" }
           ]
       }];                        
       var trs = grid.dataSource;
       // will get any filters applied to grid dataSource
       var filteredDataSource = new kendo.data.DataSource({
           data: trs.data(),
           filter: trs.filter()
       });

       filteredDataSource.read();
       var data = filteredDataSource.view();

       for (var i = 0; i < data.length; i++) {
           var dataItem = data[i];
           rows.push({
               cells: [ // dataItem."Whatever Your Attributes Are"
                   { value: dataItem.ContactTitle },
                   { value: dataItem.CompanyName },
                   { value: dataItem.Country }
               ]
           });
       }                
       excelExport(rows);            
    }
});

This sets up the rows to be exported, and the excelExport function carries out the export:

function excelExport(rows) {
    var workbook = new kendo.ooxml.Workbook({
        sheets: [
            {
                columns: [
                  { autoWidth: true },
                  { autoWidth: true }
                ],
                title: "Name of Tab",
                rows: rows
            }
        ]
    });
    var nameOfPage = "Test-1"; // insert here however you are getting name of screen
    kendo.saveAs({ dataURI: workbook.toDataURL(), fileName: nameOfPage + " Export.xlsx" });

}

Let me know the outcome.