Snapde 1.6 latest version

Snapde software introduction

If the CSV file exceeds 1.04 million lines and cannot be opened by Excel or WPS, what software should you use to edit the very large CSV file? Snapde is one of the best spreadsheet software for editing large CSV files. The kernel is all written in C language. , very lightweight and powerful for data editing and calculations; it can easily open large CSV files with a size of 2G and 10 to 20 million rows. In addition to common spreadsheet editing functions, it also has basic functions such as file splitting, merging, filtering, sorting, and deduplication; It also integrates Exprtk, C language, Python and other script executors. These three scripts can be written in the table to perform data processing, and the running speed can be faster than Java and C#.

Snapde software features

​​ 1. Running speed: The official version of Snapde can open CSV files four times faster than Excel and WPS. It only takes more than ten seconds to open a CSV file of hundreds of megabytes, and the sorting of tens of millions of rows can be completed in a few seconds.

​​ 2. Memory usage: All file contents are placed in memory. Pure C language pointers optimize memory usage to the extreme. In most cases, the memory is 2-3 times larger than the CSV file. In some cases, the memory is even smaller than the CSV file.

3. CSV size: It depends on the machine memory. Generally, a 8G memory machine can edit a 2G CSV file at a time.

​ 4. Maximum number of rows: The maximum number of rows in Excel 2007 and above is 1048576 rows. The number of rows that Snapde can edit is more than ten or twenty times that of Excel. Generally, an 8G memory machine can open 10 million to 20 million rows of CSV for editing.

5. Paging editing: For CSV big data larger than 2G, you can also perform paging editing to open 10 million rows for editing and saving, and then open the next 10 million rows for editing and saving. . .

6. Data calculation: The software integrates Exprtk, C, and python language executors; after testing, the execution efficiency of Exprtk is a little slower (20%) than C# and java, the C language is much faster than C# and java, and python is 10 times slower than Exprtk and C There are many resources available; not to mention Excel’s VBA, these three languages ​​​​can directly kill it.

7. Operating environment: windows

Snapde function introduction

1. File function

1. Create a new spreadsheet. The default is 299 rows and 25 columns. If you want to increase the number of rows, you can double-click the left mouse button in the bottom blank space to add 300 rows at a time. If you want to increase the number of columns, you can double-click the left mouse button in the right blank space to add 300 rows at a time. 26 columns; if you want to precisely control the number of rows and rows, you can set the specific number of rows and rows in the Edit Rows and Rows menu under Edit.

2. Open CSV, TXT, and smd files. CSV is a comma-delimited text file, TXT is a tab-delimited text file, and smd is a file format defined by Snapde itself (the opening and saving speed is twice as fast as CSV and TXT). The software can Automatically recognize GBK, UTF8, and UNICODE encoding, and can only save in GBK encoding.

3. Open in pages. If the CSV file is too large, it can be opened in a special way. Specify whether to retain the first row title, starting row number, and the number of rows opened at one time.

​​ 4. Save files, create, open, and save files opened in paging

5. Save as, the current file can be saved as a new file or a new format file

​​ 6. Append, append and open many sub-files into this file. If the first line title is the same, the new file title line will be automatically filtered out.

​​ 7. Split, split and save this file into multiple sub-files, including: whether to retain the first line of headers, split by the number of lines or split by the number of files

​ ​ 2. Editing function

​​ 1. Flexible selection set: all selection, row selection, column selection, frame selection

​​ 2. Cell has excellent multi-line editing function. Cell supports editing of multi-line text ranging from several megabytes to tens of megabytes.

3. Editing supports sequence changes containing numbers: Select the cells that need to be changed for editing, hold down the Ctrl key and then complete the edit. If there are numbers in the editing content, these cells will get the sequence change content, otherwise the content will be the same

4. Powerful undo and redo functions

5. Supports cutting, copying, and pasting selection sets

​ 6. Clear content

7. Delete: delete selected rows and columns

8. Select all

9. Insert row/column: You can insert a row or column in front of the selected row or column

10. Restore width and height: Restore the selected row or column to the default width and height

11. Hide: Hide the selected rows or columns

12. Unhide: Display the hidden rows and columns in the middle of the selected row or column

13. Zoom in and out: Zoom in or out on the spreadsheet

14. Jump: Jump to the specified row

15. Set filtering: Set filtering on the selection set (if only one cell is selected, all are filtered), and only the data within the filtering conditions are displayed.

16. Delete duplicates: Delete duplicate data in the selection set (including deletion of entire rows by expanding the selection)

17. Sort in ascending order: Sort the selection set in ascending order (including expanded selection of entire rows)

18. Descending sort: Sort the selection set in descending order (including expanded selection of entire rows)

19. Interlaced color: Set single and double row backgrounds to display different colors

20. Add 300 lines: Add 300 lines to the back

21. Add 26 columns: Add 26 columns to the back

22. Set the number of rows and columns: Accurately set the number of rows and columns of the spreadsheet

3. Search

​​ 1. Search: search forward, backward, counting

2. Replace: replace next, replace all

4. Script

​​ 1. Set Exprtk script: Set the cell as Exprtk script, and you can edit and run the script in the cell

2. Set TCC script: Set the cell as a C language script, and you can edit and run the script in the cell

3. Set Python script: Set the cell as a Python script, and you can edit and run the script in the cell

4. Set normal text

5. Run the selection script: Run the selection script cells from left to right and top to bottom

​ 6. Run all scripts: Run the desired script cells in the spreadsheet from left to right and top to bottom.

5. Script interface

​ 1. Exprtk script interface

A. Exprtk syntax

B. Expr interface encapsulated by Snapde:

The numerical variable of the cell, such as: A1, represents the numerical variable of the cell in the first row and column. You can use it to obtain the value of this cell, or you can directly assign a number.

The string variable of the cell, such as: A1_, represents the cell string variable of the first row and first column. You can use it to get the string of this cell, or you can directly assign the string value.

​ ​​a.to_lower(str), convert the string into lowercase

          b. to_upper(str), convert the string into uppercase

​​ ​c, to_string(num), convert numbers into strings

      d. to_number(str), convert string into number

e, get(row,col), get the number of the cell specified by row and col, if it is a non-numeric string, return 0

F, set (row, color, num), set row, color, specified cells to digital num

g, get_(row,col), get the string of the cell specified by row and col, if it is a number, convert the number into a string

h, set_(row,col,str), set row, col, and the specified cell to the string str

i. set_progress(n), set the progress bar progress n, n ranges from 0 to 100

j, sleep(n), hang for a period of n milliseconds, n is an integer

k, get_tick_count(), get the number of milliseconds that have passed since the operating system was started.

l. save(), saves the current file, returns 1 if successful, and 0 if failed.

m, save_as(file), save the current spreadsheet as the file specified by file (file must be a full path with a name), returns 1 if successful, and 0 if failed.

n. get_row_count(), get the number of rows in the current spreadsheet

o.get_col_count(), get the number of columns of the current spreadsheet

p, resize(nRow,nCol), reset the number of rows and columns of the current spreadsheet, both nRow and nCol need to be greater than 1

2. C language script

a.get(int row, int col, double *num), get the number of the cell specified by row and col, put the result in num, if it is a non-numeric string, return 0

b. set(int row, int col, double num), set row, col, and the specified cell to the number num

C, get_ (int Row, int color, char, char **data), get the string of the cell specified by row and col, put the result into data, if it is a number, convert the number into a string, note: the *data pointer does not need to be released manually, this will be called next time Automatically released after the function or this script is run

      d. set_(int row, int col, char *str), set row, col, and the specified cell to the string str

e. set_progress(int n), set the progress bar progress n, n ranges from 0 to 100

                f. get_tick_count(), get the number of milliseconds that have elapsed since the operating system was started.

g, save(), save the current file, return 1 if successful, return 0 if failed

h, save_as(char *file), save the current spreadsheet as the file specified by file (file must be a full path with a name), returns 1 if successful, and 0 if failed.

i. get_row_count(), get the number of rows in the current spreadsheet

​​​j.get_col_count(), get the number of columns of the current spreadsheet

k, resize(int nRow, int nCol), reset the number of rows and columns of the current spreadsheet, both nRow and nCol need to be greater than 1

3. Python script

Before using the Snapde function, you need to introduce the Snapde module: import Snapde

a. Snapde.get(int row, int col), get the number of the cell specified by row and col, if it is a non-numeric string, return 0

b. Snapde.set(int row, int col, double num), set row, col, and specified cell to number num

c. Snapde.get_(int row, int col), get the string of the cell specified by row and col. If it is a number, convert the number into a string.

      d. Snapde.set_(int row, int col, char *str), set row, col, and specified cell to string str

e. Snapde.set_progress(int n), set the progress bar progress n, n ranges from 0 to 100

f. Snapde.get_tick_count(), get the number of milliseconds that have passed since the operating system was started.

g. Snapde.save(), saves the current file, returns 1 if successful, and 0 if failed.

h、Snapde.save_as(char *file), save the current spreadsheet as the file specified by file (file must be a full path with a name), returns 1 if successful, and 0 if failed.

i. Snapde.get_row_count(), get the number of rows in the current spreadsheet

​​​j. Snapde.get_col_count(), get the number of columns of the current spreadsheet

​​​k, Snapde.resize(int nRow, int nCol), reset the number of rows and columns of the current spreadsheet. Both nRow and nCol need to be greater than 1

​ ​ 6. Script performance

Open a 910M CSV file: london_crime_by_lsoa.csv. There are a total of 13490605 rows, 7 columns, and 94434235 cells. Use three scripts to perform simple sum operations:

​ ​ 1. Exprtk script cost: 4.343 seconds

2. C language cost: 1.203 seconds

3. Python language cost: 52.468 seconds

Snapde installation steps

​ 1. Download the latest version of Snapde installation package from Huajun Software Park. After unzipping, double-click the "exe" file to enter the installation wizard, select the installation location, and click Next

​ ​ 2. Click "Browse" to select the start menu folder and click Next

3. Select additional tasks, check the tasks you need, and click Next

4. The software information is ready, click Install to install

5. The software is being installed, please wait patiently.

​ 6.Snapde installation is complete, click Finish to exit the installation wizard

Snapde update log

​​ 1.Fix BUG, ​​the new version has a better experience

​ 2. Some pages have been changed