Spreadsheet_uniuniver.hashnode.dev·Jan 27, 2025📊Univer Go: AI combined with spreadsheets to automate the entire process of data collection and fillingFrom now on, say goodbye to manually filling in data： Hi👋, I would like to recommend an intelligent template developed based on the Univer Go platform - AI Data Enrichment. This template deeply integrates the Phidata API and provides users with thre...AI
Spreadsheet_uniuniver.hashnode.dev·Jan 27, 2025📊Univer Go: Perfectly combining AI with spreadsheets to extract database data in one secondBecome your exclusive data processing assistant: Hello 👋! I would like to recommend a smart template developed based on the Univer Go platform - Load Database, which is a powerful assistant for data processing! It deeply integrates the Phidata API a...Python
Spreadsheet_uniuniver.hashnode.dev·Jan 26, 2025📧Univer Go: Spreadsheet combined with AI, automatically extract information and send emailsUnlock the spreadsheet that will automatically send emails： Hi👋, I’d like to introduce a template developed based on Univer Go —AI Email. By integrating the Phidata API, it can intelligently access AI services, automatically extract key information ...Python
Spreadsheet_uniuniver.hashnode.dev·Jan 24, 2025Easily improve efficiency by translating spreadsheet cell content with AI in just one click.Unlock the spreadsheet for one-click translation: Hi 👋, let me introduce a template based on Univer Go — AI Cell Translator. This template uses the GLM-4 API to automatically translate selected cell content in Univer Sheets. It supports batch transl...JavaScript
Spreadsheet_uniuniver.hashnode.dev·Jan 21, 2025AI-Powered Translation for Univer Sheets: Automating Cell Content TranslationBackground With the globalization of work and study, communication across languages has become increasingly important. For users who work with spreadsheets containing multilingual data, the need to translate content in cells becomes a common requirem...JavaScript
Spreadsheet_uniuniver.hashnode.dev·Jan 16, 2025How to Implement Worksheet or Range Protection in UniverBackground In collaborative spreadsheet editing scenarios, there is often a need to protect certain worksheets or specific ranges to prevent accidental modifications. For instance, in a financial report, administrators may want to lock formula areas ...permissions
Spreadsheet_uniuniver.hashnode.dev·Jan 16, 2025Facade API — How Univer Enhances the Development ExperienceIn this post, we will discuss the Facade API, the interface layer of the Univer SDK, and how it improves usability and serves a broader audience of developers. Design Goals of Univer From the outset, the architecture of the Univer SDK was built with...JavaScript
esProc Desktopesproc-desktop.hashnode.dev·Dec 4, 2024#110 — Sorting of Row-Based Data — by ExpressionProblem description & analysis: Here below is a data table: Task: Sort in reverse order by the sum of three columns, Maths, English, and PE. Solution: Use SPL XLL and enter the following formula: =spl("=E(?).sort(Maths+English+PE:-1)",A1:E12) The r...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 15, 2024#97 — Count Duplicates of Simple MembersProblem description & analysis: Here below is a data table of names: Task: Count the number of duplicate names. Solution: Use SPL XLL and enter the formula in cell B2: =spl("=?1.conj().select(~==?2).count()",A$2:A$6,A2) Download esProc Desktop fo...10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 1, 2024#87 — Merge Data of The Same GroupProblem description & analysis: Here below is an annual and quarterly sales data table: Task: In this table, column A is ordered and has duplicate values. Now we want to clear the data from all rows in the same group except the first row. Solution: ...10 likesexcel
