How to import part of a page into excel or google sheets?

Question

WPF

Hello!
Please help me set up a permanent upload of this data from the site https://www.bitfinex.com/ to a spreadsheet (Google Sheets or MS Excel). Tried in G.Sheets importhtml but it's not a list or a table. In Excel I tried Data - From the Internet, the necessary part was also not unloaded

Answer 1

DataTable Table{get; set;}
DataAdapter dataAdapter;

private void DeleteMethod(object obj)
{

    var indexDataTable= //получаете здесь индекс из колонки "индекс"(например) выбранной строки
    var indexDataGridRow = //тут индекс самой строки, чтобы удалить ее из DataTable, либо вообще DataTable заново получать

    using (SqlCommand cmd = new SqlCommand())
    {
        cmd.Connection = new SqlConnection(connectionString);
        cmd.CommandText = "DELETE FROM YourTableName where id=" + indexDataTable;

        cmd.Connection.Open();
        cmd.ExecuteNonQuery();
        cmd.Connection.Close();
    }

    Table.Rows[indexDataGridRow].Delete();
    Table.AcceptChanges();
    dataAdapter.Update(Table);
}

Answer 2

www.planetaexcel.ru/techniques/13/129