SpreadJS is combined with Java to implement template upload and download functions (steps)

The content of this article is to introduce the combination of SpreadJS and Java to realize the upload and download functions of templates (steps). It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

Installation and deployment:

Development environment:

1. The background server uses Java and SpringMVC.

2. Data is stored in the \demo_web\WEB-INF\FileDatabase.txt file, no need to rely on DB.

3. Using Eclipse Java EE IDE for Web Developers, Eclipse Version: Photon Release (4.8.0).

4. Server: tomcat-7.0.90.

Import the project into eclipse:

demo_web.zip is a compressed package that directly compresses the eclipse project.

You can directly unzip it to the workspace of eclipse and import the Existing Projects into Workspace project.

Deployment method:

Configure tomcat to associate with eclipse, add the project to the tomcat application list, and start tomcat.

Operation steps:

Access:

When deployed locally, you can use http://127.0.0.1:8080/ demo_web/view?path=index Visit the home page.

Create templates:

1. Create templates are divided into three template types: form binding, cell binding, and table binding.

2. demo_web The compressed package also contains three template SSJSON files: form binding example, cell binding example and table binding example, which can be used by users to create templates.

3. Form binding preview area description: If you select the template type drop-down menu, the preview area will change with different template types. There is only one ssjson template preview for cell binding and table binding. area. As shown in the figure:

Figure 1: Create form binding template page

4. After the form template is uploaded successfully, the preview page The effect is as follows:

Figure 2: Preview effect after uploading the form binding template

5. If you need to upload a cell binding template or table binding To define a template, you need to click the "Type" drop-down menu first, select the corresponding type, and then perform the upload operation.

6. After uploading the template and filling in the basic information of the template, click the Save button.

Management templates:

1. The management template list displays template information that has been created in the system.

2. Click the download button of the corresponding template to download the ssjson file of the template, which can be directly imported into the SpreadJS Designer for modification.

3. Click the fill button of the corresponding template to enter the form filling page.

Fill in:

1. Take the form binding template as an example, as shown in the figure:

Figure 3: Example of form binding template filling page

2. New: Reload the current template without retaining all the data that has been filled in.

3. New row: Add a new row for the reported data, corresponding to one more data element for the bound dataSource (the cell binding template does not have this button).

4. Save: Save the completed data to the background file.

5. History: The historical data submitted by the current template.

Historical data list:

As shown in the picture: Click to view to query the historical data reported this time.

Figure 4: Fill in historical data list page

Historical data:

Figure:

Figure 5: Filling in historical data page

QA:

Q: The LAN is not accessible?

A: The SpreadJS control used in this demo is unauthorized and can only be operated locally.

Q: How to customize the binding fields in the form binding template?

A: You can import the form binding template example.ssjson into the designer to view. The first line of the form binding template is the field name corresponding to the dataSource, and the second line is the displayed field name. The third line is the style corresponding to the table.

Q: Cell binding template, how to customize the binding fields?

A: You can import the cell binding template example.ssjson into the designer to view. The field name corresponding to the bound dataSource is defined in the corresponding cell in the form of [field]. .

Q: How to customize the binding fields in the table binding template?

A: In the first line below the table header in the table template, the column name can be defined in the form of [field], and new GC.Spread.Sheets.Tables.TableColumn( can be created in the code ) example, used to map the relationship between column names and bound fields. For specific methods, please refer to the demo of table binding in the study guide on the official website. The demo address is: https://demo.grapecity.com.cn/SpreadJS/TutorialSample/# /demos/tableBinding

This method is also used in this demo.

Q: When filling in the form, the style of the new row does not match the previous row?

A: Since the table template design style is very flexible and diverse, this demo only uses the method of copying the previous row style to set the new row. In specific applications, you can set the table style according to your needs.

Download SpreadJS Combined with Java Used Demo address: https://demo.grapecity.com.cn/SpreadJS /Java/demo_web.zip

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's learning. For more related tutorials, please visit Java video tutorial, java development graphic tutorial, bootstrap video tutorial!

The above is the detailed content of SpreadJS is combined with Java to implement template upload and download functions (steps). For more information, please follow other related articles on the PHP Chinese website!