We are pleased to announce the release of Spire.XLS for Java 14.3.0. This version adds the XLSAI feature to the original Spire.XLS for Java product. By sending requests to the AI model, it is possible to achieve functions such as document calculation, range merging, image generation, file upload, questioning and translation with the help of AI. More details are listed below.
Here is a list of the main AI functions and their APIs
| Function | API |
| Calculate document | public String excelGenerate(List<CellRange> ranges) |
| Merge ranges | public String excelMerge(CellRange descRange, List<Cellrange> srcRanges, CellRange titleRange) |
| Generate images | public InputStream imageGenerate(String description) |
| Generate images with specified size | public InputStream imageGenerate(String description, ImageGenerationModel model, ImageGenerationSize size) |
| Upload files | public String uploadFile(String fileName, InputStream stream) |
| Upload workbooks | public String uploadWorkbook(Workbook workbook) |
| Ask a question about the document | public String documentSearch(String question, String file_server_path, boolean enableHistory) |
| public String documentSearch(String question, String file_server_path, Map<String, String> options, boolean enableHistory) | |
| Search | public String search(String question, String language, boolean enableHistory) |
| Translate worksheets | public String excelTranslate(List<Worksheet> srcWorksheets, String language, boolean translateSheetName) |
| Translate ranges | public String excelTranslate(List<CellRange> srcRanges, String language) |
| Fill out Excel worksheets | public String excelFill(CellRange dataRange, CellRange descRange, boolean containTitle, List<Integer> fillColumnIndexs) |
| public String excelFill(CellRange dataRange, CellRange descRange, boolean containTitle, List<Integer> fillColumnIndexs, List<String> keys) | |
| Question | public String ask(String question, boolean enableHistory) |
| Clear user history | public String resetUserHistory() |
| Clear history sessions | public String resetChatHistory(String sessionid) |
Click the link below to download Spire.XLS for Java 14.3.0:
