3 ms·
I worked at a logistics company once where Excel was one of the main programs in use. It's used to pass around data, e.g., lists of shipments. The shipment prog
by qiqitori 10y ago
I worked at a logistics company once where Excel was one of the main programs in use. It's used to pass around data, e.g., lists of shipments. The shipment programs and business intelligence programs give you Excel files when you press export. People then filter out the unneeded information, maybe highlight stuff, maybe make a PivotTable, add extra information from other Excel files or other sources, and submit it as a report.
If you want to automate this, and you (the dev) cannot access the servers with the raw data either, you would normally write tedious VBA code. With SQL, it may get a bit more comfortable. (You can use SQL to query Excel sheets in VBA, but the boilerplate code for that is tedious too.)
I'm not sure if my previous company would be a great fit, because the automated reports are usually run by the users themselves. Per-seat licenses would be very expensive.