nu-command 0.113.0

Nushell's built-in commands
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

use nu_test_support::prelude::*;

#[test]
fn from_excel_file_to_table() -> Result {
    let code = "
        open sample_data.xlsx
        | get SalesOrders
        | get 3
        | get Rep
    ";
    test()
        .cwd("tests/fixtures/formats")
        .run(code)
        .expect_value_eq("Gill")
}

#[test]
fn from_excel_file_to_table_select_sheet() -> Result {
    let code = r#"
        open sample_data.xlsx --raw
        | from xlsx --sheets ["SalesOrders"]
        | columns
        | get 0
    "#;
    test()
        .cwd("tests/fixtures/formats")
        .run(code)
        .expect_value_eq("SalesOrders")
}

#[test]
fn from_excel_file_to_date() -> Result {
    let code = r#"
        open sample_data.xlsx
        | get SalesOrders.3.OrderDate
        | format date "%Y-%m-%d"
    "#;
    test()
        .cwd("tests/fixtures/formats")
        .run(code)
        .expect_value_eq("2018-02-26")
}

#[test]
fn fill_in_missing_headers() -> Result {
    let code = "
        open sample_headers.xlsx
        | get Sheet1
        | columns
    ";
    test()
        .cwd("tests/fixtures/formats")
        .run(code)
        .expect_value_eq(vec!["header0", "column1", "header2", "column3"])
}