DEV Community: leen

Create with JavaScript "Excel JSON conversion application"

leen — Tue, 23 Jan 2018 08:01:18 +0000

Author:@yama_cqw
Source:Qiita

Introduction

For development, use "script editor" which is included as standard in Mac (OS X Yosemite or later).

It's a very simple editor.

Launch the script editor.
Select "JavaScript" in the language menu in the upper left. (You can choose AppleScript or JavaScript)
Write the code.
File -> Export (file format: application).
You can create an application by this alone. Easy.

Application

The code of the created application is here.
When you drag and drop an Excel file, the JSON file is exported.
(Note: Microsoft Excel must be installed for execution.)

function analyzeExcel(path) {
  var app, worksheets;
  app = Application('Microsoft Excel');
  app.includeStandardAdditions = true;
  app.activate();
  app.open(path);
  worksheets = app.worksheets;

  // Create JSON for each worksheet.
  for (var i = 0; i < worksheets.length; i++) {
    makeJSON(worksheets[i]);
  }

  function makeJSON(ws) {
    var data = {};
    var title = [];
    var first_row = ws.rows[0];
    var worksheet_name = ws.name();

    // Acquire line 1 as heading.
    for (var col_i = 0; ; col_i++) {
       var check = first_row.columns[col_i].value();
       if (!check) {
          break;
       }
       title.push(check);
    }

    // Acquire as data from the second line
    for (var row_i = 1; ; row_i++) {
       var row = ws.rows[row_i];
       var row_data = {};
       // Determine the presence or absence of data in the first column.
       var id = row.columns[0].value();
       if (!id) {
          break;
       } else {
          data[id] = {};
       }
       // Combine data row by row.
       // If it has the same heading, put it in an array.
       for (var i = 1; i < title.length; i++) {
          if (row_data[title[i]]) {
             // 配列化
             if (!Array.isArray(row_data[title[i]])) {
                row_data[title[i]] = [row_data[title[i]]];
             }
             // Add
             if (row.columns[i].value()) {
                row_data[title[i]].push(row.columns[i].value());
             }
          } else {
             row_data[title[i]] = row.columns[i].value();
          }
       }
       data[id] = row_data;
    }

    // Export settings
    var filePath = app.chooseFileName({
       defaultName: worksheet_name + '.json',
       defaultLocation: app.pathTo('desktop')
    });

    // Write JSON data (convert character code to UTF-8)
    ObjC.import('Cocoa');
    var text = JSON.stringify(data, null, '  ');
    string = $.NSString.stringWithString(text);
    string.writeToFileAtomicallyEncodingError(
      filePath.toString(),
      true,
      $.NSUTF8StringEncoding,
      $()
    );
  }
}

// Processing when dragging and dropping a file to an application.
var SystemEvents = Application("System Events");
var fileTypesToProcess = ["ELSX"];
var extensionsToProcess = ["xlsx"];
var typeIdentifiersToProcess = [];
function openDocuments(droppedItems) {
  for (var item of droppedItems) {
    var alias = SystemEvents.aliases.byName(item.toString());
    var extension = alias.nameExtension();
    var fileType = alias.fileType();
    var typeIdentifier = alias.typeIdentifier();
    if (
       fileTypesToProcess.includes(fileType) 
       || extensionsToProcess.includes(extension)
       || typeIdentifiersToProcess.includes(typeIdentifier)
    ) {
      var path = Path(item.toString().slice(1));
      analyzeExcel(path);
    }
  }
}

// Describe how to use when double-clicking the application icon
function run() {
  var sys = Application("System Events");
  sys.includeStandardAdditions = true;
  sys.displayDialog("Please drag and drop the Excel file (xlsx). Convert to JSON file.");
}

Here is the conversion rule.

Create a JSON file for each Excel worksheet.
Heading the first line, treat the second and subsequent lines as values.
Use the value of the first column as the key and group the data for each row.
If the headings are the same, make it an array.
Convert to UTF-8 (garbled characters if not converted).

For example, if you drag and drop such an Excel file...

Such JSON will be exported!

{
  "a": {
    "name": "John",
    "num": [
      11,
      12,
      13
    ]
  },
  "b": {
    "name": "Paul",
    "num": [
      21,
      22
    ]
  },
  "c": {
    "name": "George",
    "num": [
      31
    ]
  },
  "d": {
    "name": "Ringo",
    "num": ""
  }
}

Tried "Hello World" using Android Studio

leen — Wed, 17 Jan 2018 07:00:27 +0000

Author:@kengo_kuwahara
Source:Qiita

Introduction

I will show you how to develop Android application using Android Studio.

What's Android studio?

It is familiar to those who have used the integrated development environment, except that there is a preview screen on the right side.

You can open and close the menu from the bottom and the left and right bars. Basically, as with the image above, the menu other than the necessary minimum (code and preview) is closed.

How to implement

In development using Android Studio, we will implement it by editing the xml file and the java file.

xml file

It is a file for setting appearance, such as the position of buttons and text boxes. For those who have experience developing with JavaScript, it may be easier to understand as html files in JavaScript development.

java file

It is a file for setting the operation, such as processing when pressing the button. If you have experience developing with JavaScript, it may be easier to understand if it corresponds to js file in JavaScript development.

Implement

This time we will edit activity_main.xml and MainActivity.java. After loading the completed image (or the result after completion), write the actual code.

Complete image

The setting is as follows.

xml

Label: "Hello World !!"
Button: "Change label"

Java

Method that puts label "change text" when pushing "change label" button.

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.ConstraintLayout...
　　<!--(略)-->
    <TextView
        android:id="@+id/chage"
        android:text="Hello World!!"
        android:textSize="32sp"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintLeft_toLeftOf="parent"
        android:layout_marginLeft="101dp"
        android:layout_marginTop="81dp" />

    <Button
        android:id="@+id/mybottun"
        android:onClick="changeLabel"
        android:text="Change text"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintLeft_toLeftOf="parent"
        android:layout_marginLeft="138dp"
        android:layout_marginTop="160dp" />
</android.support.constraint.ConstraintLayout>

<TextView ...

It is setting of a label.

<Button ...

It is the setting of the button.

android: id = "@ + id / hoge"

Specify the id of the object.

android: layout_width = "wrap_content"

Specify the size of the object. By specifying "wrap_content" it automatically adjusts the size according to the object to be displayed (for example, if you increase the character "change label" displayed on the button, the button will become larger accordingly).

app: layout_constraintLeft_toLeftOf = "parent"

It is a setting about the placement of the object. This sets the object on the left side of the screen.

layout_constraintLeft_toLeftOf is set based on the position of the right side = "hoge". The left edge of the screen is set by specifying parent. Also, by setting app: layout_constraintLeft_toLeftOf = "[object id]", it can be left aligned with the specified object.

android: layout_marginLeft = "101 dp"

layout_constraintLeft_to Set the number of dp margins to be set from the position specified by LeftOf and others.

By the way, if you put the mouse on the object in Preview of Andoroid Studio, you can see from what position to what dp position. It is also possible to change the position by dragging the object.

MainActivity.java

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    /**
     *
     * @param view
     */
    public void changeLabel(View view) {
        TextView tv = (TextView) findViewById(R.id.chage);
        tv.setText("changed text");
    }

}

onCreate()

If you make xml at all, it will be meaningless unless be read it. This method describes which xml is called when invoked, in setContentView. Here, activity_main.xml is set up.

changeLabel()

Describe the operation when pressing the button. In order to fetch an event from the screen, take a variable of type view as an argument. After that, obtain the ID of the label you want to change and set the value with setText.

4 choices of "educational toys" to acquire the ability to create

leen — Thu, 11 Jan 2018 09:42:54 +0000

I gathered a toy that children can remember creativity.

1.Cubetto

Cubetto is a British-born toy that raises programming ability "without using a digital screen.

2.KOOV

Children can build robots with colorful KOOV blocks, then bring them to life with sensors, actuators & amazing coding skills.

3.BLOXELS

You don’t need to understand fancy code and own super expensive computer programs to make video games anymore. All it takes is your Bloxels Gameboard, some blocks and a mobile device and, of course, your imagination to take the guesswork out of building your own video games!

4.Cuboro

It is also a play that rolls a ball, but it is also a game to "draw drawings of the course in the head, organize it and shape it".
Of course, rather than making it conscious, when kids get accustomed to playing, you do it unconsciously.