Wenwei Lin

← All projects

Work

WPS spreadsheet import add-in

A WPS add-in: factories keep recording orders in their own spreadsheets and import them into the system in one click, without retyping. It ended up in use at over a thousand factories.

When
2024
Context
Black Lake Technologies
My role
Designed and built from scratch
Built with
React · TypeScript · WPS add-in · Design patterns
客户订单产品工序数量法兰盘车削120轴套铣削80端盖钻孔45导入系统✓ 产品✓ 工序✓ 工单

Background

Many small factories keep their orders and records in spreadsheets, or receive spreadsheet orders from their customers. Once they adopted our system, they had to type everything in again, and as I put it then, “there’s no need to waste so much time for the sake of going digital.”

The first version was an Excel add-in. When I went to South China to roll it out, I found that most factories used WPS, where the Excel add-in couldn’t be installed. Back in Shanghai I rebuilt it as a WPS add-in that installs with one click from a web page.

How it’s used

Factories keep filling in the spreadsheets they already know. We set up a template, and one click imports the sheet into the system. Later it could also import bills of materials (BOM) and assembly work orders, along with the images in a spreadsheet.

Looking back

Every factory’s spreadsheets are different, so a template has to be set up before use, and that setup is still fairly complex.