一种凭证生成方法以及相关装置

• Format: Patent
• Language: Chinese
• Published: 14.06.2024
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

本申请实施例公开了一种凭证生成方法以及相关装置，用于满足凭证模板能从EXCEL表格中灵活获取单元格数据的需求。本申请实施例方法包括：获取EXCEL表格以及凭证模板；确定所述EXCEL表格中待关联的目标区域；确定所述凭证模板中需关联的科目、以及所述科目对应的科目填充区域；将所述目标区域与所述科目进行关联；接收对所述凭证模板中所述科目的选择操作；接收对所述科目关联的所述目标区域中目标数据的选择；用所述目标数据填充所述凭证模板中的所述科目填充区域，生成凭证。 The embodiment of the invention discloses a voucher generation method and device. The method and the device are used for meeting the requirement that a voucher template can flexibly obtain cell data from an EXCEL table. The method provided by the embodiment of the invention comprises the following steps: acquiring an EXCEL table and a certificate template; determining a target area to be associated in the EXCEL table; determining subjects needing to be associated in the voucher template and subject filling areas corresponding to the subjects; associating the target area with the subject; receiving a selection operation on the subject in the voucher template; receiving selection of target data in the target area associated with the subject; and filling the subject filling area in the v