开发者

Automate Spreadsheet Transformations

开发者 https://www.devze.com 2023-01-06 23:00 出处：网络

Every month I process a vendor\'s MS Excel spreadsheet for my work.I have to remove columns, rename columns, re-format columns, and then email the resulting spreadsheet to colleagues.

相关专题：macos spreadsheet

Every month I process a vendor's MS Excel spreadsheet for my work. I have to remove columns, rename columns, re-format columns, and then email the resulting spreadsheet to colleagues.

Is there a way, in Excel or Numbers or programmatically, to automate this extre开发者_如何学Cmely repetitive process?

Thanks, Sergio

Excel for Mac supports Applescript so you could script the process. RealBasic can automate Excel. Excel for Mac used (5+ years ago) to ship with a reduced version of it. Don't know if it still does.

Applescript support in iWork Numbers is rather good so if you have Numbers I would suggest importing into Numbers and running the script there.