Editing Table Data Like a Spreadsheet
An easy approach to editing your data.
Arctype enables users to interact with tables in intuitive ways. One powerful feature Arctype provides is the ability to directly edit table data, just like a spreadsheet.
After opening Arctype and setting up your connection, use the left-hand navigation menu to find the Table tab. After selecting the Table tab, click on the table you’d like to work with. This will open your data in the
By default, your data is displayed in a table form, with rows and columns. However, not all data is displayed on the screen at once. Instead, Arctype paginates data to keep the application fast and snappy. To view additional pages of data, you can use the pagination buttons along the bottom of the app window, or type in the page number you want to jump to. To increase the number of rows rendered on each page, right-click on the context menu in the upper right and modify the
Rows per pagevalue to whatever number you prefer. Then click
Changing pagination settings
You can insert a row of data directly from the Table view. To do this, select the
Insert Rowbutton in the top right. You can also remove a row by selecting any cell in it and hitting the
Confirming a deletion
Be sure you actually want to remove the row and its data before accepting the confirmation prompt.
To add or remove a column, right-click on the context menu in the upper right corner of the application, as shown below. Then, select the
Editing the table
To add a column, select the
Add Columnbutton in the top right. This will bring up a highlighted column configuration entry. Provide your column with a name, choose its type, and provide a default value. You can also configure any constraints, keys, and checks here.
Adding a new column
When you’re satisfied with your changes, choose the
Reviewbutton in the top right and verify that the changes fit your expectations. If everything looks good, accept the changes by clicking
Confirming your changes
To remove a column, simply return to the
Edit tablewindow and choose the
Xnext to the column in question. Review the changes and choose
Applyto complete the deletion.
Arctype goes beyond spreadsheet tools like Excel and Sheets by providing you with a powerful cell inspection tool. To access the cell inspector, simply double-click on the cell. The cell inspector will appear on the right-hand side of the application.
The Cell Inspector
Double-clicking on a cell also allows you to edit it. You can type in the cell itself, or change the cell value in the Cell Inspector. If you edit the cell directly, pressing
Returnwill save your changes. If you edit the cell in the Cell Inspector, choosing
Updateat the bottom of the window will save your changes.
Cancelwill discard them.
You can also copy a cell. Pressing
Cntrl+Cwhile highlighting the cell will copy it to your clipboard. You can also copy the cell from the Cell Inspector by choosing the
Copy Cell Contenticon.
Copying a cell
To paste a cell’s contents, simply edit a cell and use your paste shortcut (
The Cell Inspector described above is particularly useful for interacting with JSON data. It allows you to view a large number of characters (typical of JSON table cells) in a clean manner.
JSON is automatically formatted in the Cell Inspector, allowing you to quickly diagnose problems, modify values, or study your data's structure.
Viewing JSON data
Arctype allows you to resize columns for easy reading. Select the column you want to expand and double-click the right-most column boundary to expand the column to be the same width as its widest cell. You can also drag the column dividers to manually resize them.
Resizing a row
Resize your entire view Arctyp supports app-wide zoom levels. Press
+to zoom in, and
-to zoom out. Export to CSV or Excel Arctype allows you to export your data to either CSV or Excel format. Select your table and choose
Exportin the top right, then choose your target data format. Arctype will prompt you for a destination. Choose your destination and download your data.