OSTUM Desktop:離線比對兩個 Excel 活頁簿
Reconciling two Excel workbooks offline with a local Windows AI assistant
OSTUM Desktop 透過本機活頁簿讀取器離線比對兩個 Excel 活頁簿,並在預覽中列出新舊值及兩邊的來源儲存格地址。5.7.0 比較引擎在測試中找出 3 項差異,沒有把兩個調換位置但數值不變的產品誤判為變更。基本本機聊天免費且毋須帳戶;Excel 工作區屬 Pro 功能,須一次性核驗對開發者 Telegram 頻道的訂閲。
What should a local language model do when a user asks, “What changed in these two spreadsheets?” A plausible answer is easy to produce. A result that survives a row reorder and points back to both source cells takes a different implementation.
In OSTUM Desktop, the chat routes that request to a local workbook reader. The user chooses the original file, the revised file and a key column on each sheet. A price such as 90 or 100 comes from the spreadsheet cells. The model doesn't have to infer a price from a text excerpt.
A four-product test
The two downloadable workbooks have the same sheet, called Прайс (price list). Column A is Артикул (product code), column B is the price. Row 2 contains a code that happens to look like a cell reference: A17. Its price is actually in B2.
- A17 went from 90 to 100 RUB. Check B2 in both books.
- D42 was removed. Check A5 in the original.
- E53 was added. Check A5 in the revision.
Two other products, B24 and C31, exchanged positions. Their values stayed the same. We ran these exact files through the 5.7.0 comparison engine and obtained three differences. A row-by-row comparison would also have reported changes against the two moved products.
Put the reviewer before the write
The review window shows the old value, the new value and both source addresses. Saving produces a separate report workbook. The operation also checks the revisions of the input files before writing. If someone changes a source after the preview, the comparison must be refreshed.
For a weekly report, a named recipe remembers which sheets and key columns to use. The next run still asks for a fresh pair of files. This lets the user review this week's inputs without maintaining a folder of hard-coded source paths.
Reproduce it
Download the two sample XLSX files and follow the walkthrough. The Windows interface is in Russian, and the English guide spells out the relevant controls. Basic local chat is free and works without an account. The Excel workspace is a Pro feature with a one-time check of a subscription to the developer's Telegram channel. The app code is MIT-licensed. Source and Windows release
This is a maintainer article prepared with AI assistance. The sample data is synthetic. The workbook comparison above was checked with the project's own engine.
來源:DEV Community · dev.to