需求背景

我经常会忘记关闭excel然后就执行程序，程序执行半天准备写入表格时候，结果因为表格是打开中报错了，就很难受

在写入excel的时候，如果此时需要写入的excel已经被其他软件打开占用了的话，那就会写入失败。

那在日常编写程序或者使用的时候可能会存在一个问题，我们在启动程序之前编辑或者打开查看了表格，但是忘记关闭了，然后此时开始执行程序，暂时是不会报错的。然后比如是去某处抓取一些数据处理，比如耗费了1分钟时间，然后开始执行写入操作，结果报错了，因为文件被占用了。

这个指令就是去提前预防这个问题的，在开始前就去做一个检测处理

自定义指令

9287568986cad3f1507156107b2dfc2dccb5e3ebf58a5df8b8043bd220f82170104cd438b6b5cca74e1e426904f6939a5dced8edecaae63431a6c2fa12bca93241d189c175b2b548ac8761a01163e57b7eaa1423d48d381f9dbe76c763a7136628e7208f7ab8ad8b53598d16d5fa62a326c77feb946e941b16b6d4d1651552d0ad384997e19554fd56b7ff65114293b2797b75f74ef91c34ae3a96b58789ba1662716c27a361fa048c95aa329840ffe834f52633ccc2cb773831eb0d78072edf0586c2b56833c56e05c3dd8ff4a9595205c249c3e04de8866af949be2ade33481685ff402eae7484cce5baad97bb0ab6c79bb74bbd6fe6b1461fece139bc7bcef3fc497a12793b504e958916d53c0c867dc03ea70710fe76ad7850613f37f5605d7576e87bd5ccc3634933dee84d3df0ccae2db20abc776ec52977aec4035fae7307aaf9562baa98185ed5e1bcb8047d2f9d2e3973fbaafbb7e17a5a80843e41063ad854f0cb54afd50f1563c2ac7dca8189b946176276a3fa31730a154f430d95ec5fbefb01c8aff4e77d4f626918fac9504782c53ca70946df61fa18778710cd387487ee4bcd052caa19f4e7f250bde013e080ffb4a3fe99655c186aff8915172e7a588e6a61b01167c9414ac762d7d3812200ea7b9c2a8a0a4e1f2c0931806593f6414bdb5e13e3d2768b5fa070d1c568a546f677a5e0c4b7d76d0e1f86a7c3e169f05279b42d89c136faa6046ad21488b5cde4568261d9742c33b923e3bbd05a07144b184990c096f594affb578f2f39709a127fdd8c5cfd808422eab60fe9f785d6704218fb79c59a252868a07b03c546f6d6e25c567f905526d5d3114ce3e3f68b4fb80beafbd83c591cf72de3ec0419e93ad7dff76c2415f83cb1612c7da9b38a8f844e9d4905db6a8694935381aa55904525bc5a627473272a23f8d6629a128ced51f407d3d085cc4b1cb132df836739a467748432771e2bfd13ebc3e1b9829920d00bfc7392ad70ede9fdb693202e7aac085beb381df01ff3e70cfee1f28dcc3102ab2ff9345389d074ee78a9bd0d9ac3f8365aa351c7468f0e554f14eee1eb25047f0fa73d4b922384ca6899448b7253393e2e14aa6fd481d2b82cf85af58abda8e9da991f52d51a5044fa56db86c6125911462c550d985964b06450b8235417af6acf9d99d9fe91fc648b2d1347d4282d97e897549c7b986ba48e7ce1fc79ad6379352d8ca58208fbcda9e3aee106870da2630a5426601d94ac5b87a9e42b95df06cdedfb9f0d133bd70f27d68261292d57d6fa3cd8530f75f7f988813bf4eecfb6cb1e4c2e5375cba358400b740cc78505bd02375b2c4f4d8318c5c67d5625868472d455088980f4795681945cccc4bc1b23afc22d5e0acd39aed5785343c7943526f4abeb57cba772549b6d33145a0449e2635720b3324aa45d53058d639bf76be9cdabb2bdddc8234e66701f2a33308e0aa7b977cadaf0da80606342b4122398987f84e6bdae5444dd9711af1548e6fc23ff54837eba12d21f72e08052ef3eec4d6f3b22f5d53ef5292d9ec79553ac8b3a0f9540fa8d6ea6df055a518bf236578b17df1471027f69f70260be8069681bd7e7b2fe8b2e866d666c6f688e7fab4f1dc746aa3ca49c4b5dea6e6c4814d330885eda18134715bff974dde0549e0ad871636e3a300ddb9e4076bd02f1fc9d718844534b41d6a766f370050f7b075f0ef484da657f4d320b28cad9280b28d8f799678fb88568e324101954d13daac9cf02203e4f74b6a37cd8e8083d26f948cd2a8895049608196a7ae55c054f7b19c0a35d04a156b2bed830b6641172435ea89722192fbaca9f2745d99c887cb975d7015448e69594af84312da025956f6794a6210baa8e80a9a7f382a8e9f843b590b55fd92b6208a5021a03e7d934bab1fd5f546cd02ccf19bf653d33b62f74469bbdee3621cf1d894d22d71e76530e9fa9671783bf8c725760d07de92972bcba01a5dd1d4f1e4ac065ab1635979957973834a90c6c7bcb8222b4b2d8f9df0c373eece3b3d60cab00c5f8a4079b621e92019aa19835dc6e7a0db6f0199d93d4b9b5f421a663fca300129826926b285eb95adaec890f88012491218158903eec12de39a7342f5fb99d6bfb06e3360bbfa0cc925ebbb4db6084e836568675ded48f539efcfda3b0a1d3ca95102d197e08fe6b83b4d3f4842d818c03ebf6d85b71a38ab54dcc8cf7e539c0b2806398eb153fe176f76d4425a98cec0522de2b1270661f11b65def22d665d3932d570566f2e49093833f0c2c0b61bb3248f7835267cc8940940d7f28e44bf5880064a8042318894f339636319c706f70479c80f00f2b30cb7d0c8cb92708a79503622a939100be7d2d1aec618de5864fe6eef884f0c3b517e46e2919f241c8e250c678758c507ceaae4840f39492c08393c350f2ecdb85a8c2b07498d608aed6208247668a9bb79f18792cde0368fad9290b51dac41b4430c236afb3c685d1f1e9f669287122026f8feddc7999aa2011b4b890c2f75827760040eabf7857d666065fe42e50e620d8a5bc0665823f3663bce879ae15221f534f4f907380dd0e5a52697dcce35b4deb48a5553efd477de01263b679da9233af2e518dd7334c4e40d20a21c1ca1e7b118bbb140094ac0451a4f90d0168ba5860138ec121d98e4f83339c6b42f9585b90aa5dfb5a1ad0da801dd82468f2d294286421c11aca50816597b2a2ca96b05965a366927c5ff59e0f531791d9bd92cfe66b8a84759f5fc80ca95ae2214d43b01f3dd3d9f1d5b188ee3ca168b8b98fc0f06d658869c5d3245ead058948297e8bb3e87ed1fda2511f89e120a8964f04f6f9ce9147cf6fb5fb1802c11fbd00b06106b6f15938ba6ae190e2646cbd7bf2a7a5cbfea0759f717d64f4f6

只需要在程序开始之前插入该指令，然后传入后续准备操作的表格（其他文件格式也支持的）路径即可

如果此时文件被其他软件打开了或者文件路径不正确，那就会直接报错处理，然后终止程序，这样我们也无需后面的一些耗时操作就提前规避了文件占用的问题