Data Managementផ្ទាំងអន្តរកម្ម
Apply Excel Edits
អាន workbook ដែលបង្កើតដោយ Edit in Excel រួចរុញតម្លៃដែលបានកែ ត្រឡប់ចូល feature class ដើមវិញ។
ទិដ្ឋភាពទូទៅ
This is step 3 of the Excel round trip. It cannot be used on its own — it requires an active editing session started by Edit in Excel, and reports "No active Excel editing session found." otherwise.
ការប្រើប្រាស់
- Save and close the workbook in Excel before applying. An open workbook may be locked or hold unsaved changes, and the apply step reads the file from disk.
- Rows are matched back to features by
OBJECTID. If the workbook's columns were added, removed, or reordered, or theOBJECTIDvalues were altered, the match fails or — worse — writes values to the wrong features. Edit values in place only. - Two Settings options govern how the apply step behaves, and both are worth setting before you rely on this tool:
| Setting | Effect |
|---|---|
| Create backup before applying edits | Backs up the feature class first. Leave this on — it is the only straightforward way back from a bad apply. |
| Skip invalid rows (otherwise abort all) | Decides whether a bad row is skipped or the whole apply is abandoned |
- Skip invalid rows is a real trade-off: Leave it unchecked when the edit must be all-or-nothing; check it when a few known-bad rows should not block a large legitimate edit.
- Checked — valid rows are written and invalid ones are reported and skipped. You get most of the edit, but the data ends up partly updated, and you must act on the skipped rows.
- Unchecked — the entire apply aborts on the first invalid row, leaving the feature class exactly as it was. Nothing is half-done, but nothing is applied either.
- Review the report after the run. It states what was applied and what was skipped.
ប៉ារ៉ាម៉ែត្រ
This tool has no dialog. It acts on the active Excel editing session, using the options in Settings.
| ទិន្នន័យបញ្ចូល | ការពិពណ៌នា |
|---|---|
| Active editing session | The session started by Edit in Excel. Required. |
| Create backup before applying edits | From Settings. Backs up the feature class first. |
| Skip invalid rows (otherwise abort all) | From Settings. Skips bad rows, or aborts the whole apply. |
របៀបប្រើ
- Confirm Create backup before applying edits is enabled in Settings.
- In Excel, save the workbook and close it.
- In ArcGIS Pro, on the KGA Toolbox tab, in the Necessary Edit Tools group, open the Edit in Excel menu and click Apply Excel Edits.
- Read the report. Note any rows that were skipped.
- Check the attribute table and confirm the values are as intended.
- If rows were skipped, correct them in the workbook and apply again.
ព័ត៌មានអាជ្ញាបណ្ណ
Requires an active KGA Toolbox license. The tool validates the license before running.