Vsto.Technology将为Excel单元格右键菜单增加额外功能按钮。
- 生成 将用户所选单元格应用至模板生成新的工作簿。 模板路径由app.config中
TemplatePath指定。 - 生成子表 Split user selection range by distinct values at Column B into different children sheets and update the origin sheet linking with these children sheets. Then add headers for each child sheet. The header is specificied as the top 4 rows of the origin sheet with a column width the same as user selection range. You can split the whole origin sheet or just split part of that, while the link will only be generate if it has been split.
- 编辑hosts (这不是必须的。) 如果你无法打开https://raw.githubusercontent.com ，请在本机上使用文本编辑器打开
C:\Windows\System32\drivers\etc\hosts并添加151.101.4.133 raw.githubusercontent.com。 - 安装证书 下载Release页面中的 JetSnail.cer 。 安装方法见 https://jingyan.baidu.com/article/f0e83a255ab90222e59101ea.html 。
运行Release页面中的setup.exe。
- System.ArgumentOutOfRangeException: 指定的参数已超出有效值范围 清空
C:\Users\%Username%\AppData\Local\Apps\2.0内文件.
Vsto.Technology is an excel add-in for generating quotation related excel sheets. It works by providing one or more commandbar controls on the right click menu of cell.
- Generate quotation workbook. Create a new quotation workbook using template then add user selection range to each sheets. Workbook template can be specified by
TemplatePathin app.config. - Generate children sheets. Split user selection range by distinct values at Column B into different children sheets and update the origin sheet linking with these children sheets. Then add headers for each child sheet. The header is specificied as the top 4 rows of the origin sheet with a column width the same as user selection range. You can split the whole origin sheet or just split part of that, while the link will only be generate if it has been split.
- Install certification. Download JetSnail.cer in release page. See https://jingyan.baidu.com/article/f0e83a255ab90222e59101ea.html for installtion.
Run setup.exe.
- System.ArgumentOutOfRangeException: Argument is out of range. Please clear files inside
C:\Users\%Username%\AppData\Local\Apps\2.0.