GridJs Multi-Language Configuration Guide

Aspose.Cells GridJs Multi-Language Configuration Guide

Overview

This tutorial will guide you through configuring multi-language support in your Aspose.Cells GridJs project. It covers both frontend and backend configurations.

The tutorial is based on the demo project, please adjust according to the actual situation

Frontend Configuration

In your frontend pages, set the interface language using the local option.

In the demo project, you need to modify the uidload.html file

Here’s an example:

const loadNormalContext = (sheet) => {
    const option = {
        updateMode: 'server',
        updateUrl: '/GridJs2/UpdateCell',
        showToolbar: true,
        mode: 'edit',
        // Supported languages: en/zh/es/pt/de/ru/nl/pl
        local: 'pl', // Set to Polish in this example
    };
    loadWithOption(jsondata, option);
};

Backend Configuration

In the backend code, you need to set the appropriate CultureInfo before processing Excel data.

In the demo project, you need to modify the Application file

set locale settings in main method

public static void main(String[] args) {
		
	// Set Polish locale for current thread
        Locale polishLocale = new Locale("pl", "PL");
        Locale.setDefault(polishLocale);
        
        // Demonstration of locale settings
        System.out.println("Current Locale: " + Locale.getDefault());
 
		 ApplicationContext context  = 	SpringApplication.run(GridjsdemoApplication.class, args);
		 
		 MyConfig myConfig = context.getBean(MyConfig.class);
		
		 //set license for Aspose.Cells
		 com.aspose.cells.License  lic=new com.aspose.cells.License();
			if ((new File(myConfig.asposeLicensePath)).exists()) {
				lic.setLicense(myConfig.asposeLicensePath);
			}
 
 
	}

Important Notes

1. Frontend and backend language settings must be consistent.
2. CultureInfo must be set before processing Excel data.
3. Supported languages: en(English), zh(Chinese), es(Spanish), pt(Portuguese), de(German), ru(Russian), nl(Dutch), pl(Polish).
4. The example uses Polish (pl-PL), but you can change it to any other supported locale.