手机扫码
扫码微信交谈
Excel文件批量套打股东股权证书打印方案(软件)
适用软件版本:V5.0及以上版本
最后修改日期:
随着社会的进步,以及相关法律的规定,公司应该为股东发放股权证书
某些类型公司股东人数众多,如农业合作社
股东信息保存于Excel文件
要将股东信息打印到可折叠的股权证上
有时股东信息中包含股东间的关系
股东信息成百上千,甚至更多,
如果人工打印,耗时多,人力成本高
可为每种批量打印方案编写专用脚本
如果您有这类问题需要解决，请联系我司，了解定制化解决方案
非标准格式Excel文件种类非常多，不一一例举
售价:3000元起
股权证信息通常存储于多个格式相同的Excel文件中
实现股权证批量打印，需要为每一种格式的Excel文件编写脚本
股权信息Excel示例文件
股权证
为解析包含股权信息特定格式的Excel文件编写的脚本
function UI_INIT() {
UI.SetText('0C261BB9FF8AAB529E11BE6EE77BED0D', '');
UI.SetText('E7B79865230FBD2B28C84CFA4B682873', '');
UI.SetText('A883E33D449FB9CE21FA0C05EF7AB9D8', '');
UI.SetText('7289A8E6FA3C7B3B6075C528B4F479B1', '');
UI.SetText('9966751A80AA6BA929749F1915190E24', '');
UI.SetText('7E9A6FDF9BCFD180399EC76290F13337', '');
UI.SetText('516DE63A2CCFD5E3750985305BCA564C', '');
UI.SetText('6F854AF7C5969ACA33A2B0EBCA3569CA', '');
UI.SetText('BE3FFE6D6592F578833EE3AED1E07B30', '');
UI.SetText('21E27823F9229C77E7585CAC0267DFD6', '');
UI.SetText('937E7C096525EF4AFAFF78D4CD29E1F0', '');
UI.SetText('17A58E104A05DABF26AFF57607A114E6', '');
UI.SetText('0EC7A6886E860B5A7F936104139799AF', '');
UI.SetText('4A211A7A583D52353A3D76C2B3EDF989', '');
UI.SetText('1C98422FF1B3B77CD29F9C4C9D9CC458', '');
UI.SetText('9AD5A12BEB4F729B459CEC1DD8E5AD0A', '');
UI.SetText('33844FEA3321D45CB2CA13E708E632E8', '');
UI.SetText('2541E18DC666770B18E123E62234266D', '');
UI.SetText('6C3098E2785BB7FDA45A8E506E0DB3D3', '');
UI.SetText('E8803DA58FA91EA4678014A28AC207A9', '');
UI.SetText('B4E19F19DFF4AE84315709C0AC617158', '');
UI.SetText('1B76ED0AA22AC0B16BF98CC19C02B099', '');
UI.SetText('1820A034B8E8D99060CDA78076FF0249', '');
UI.SetText('9A68DE7293C5924A509EA5A8E46DE7F7', '');
UI.SetText('66BE5BF4360E5AD6FECEBD069E03AE72', '');
UI.SetText('B39D8A1768818CE7C293DAF2EBCE3D22', '');
UI.SetText('EB548D196822CA8C1FAA07E173A585DD', '');
UI.SetText('C1742476E514D9196A275E6514914477', '');
UI.SetText('800BE6B74D7B5E9968A05CFDE493ED0F', '');
UI.SetText('2A62F5E7B0136572CDF136B454D34807', '');
UI.SetText('3AC92206A4431F907EEBB9A62051AE7C', '');
UI.SetText('0C9B3D31A1DA72A09FE70DB3739CED9E', '');
UI.SetText('6B54CEAD468FB42874F467C7638AC5D4', '');
UI.SetText('AC5E33A6E115C3B5E94942FEF24F8A55', '');
UI.SetText('D0CB30F42D58CCC051713D982E3098B2', '');
UI.SetText('28C2C9B571D91AD80FC7FBECCD978991', '');
UI.SetText('C4CFC9DBE003916504216F9B8E0DB184', '');
UI.SetText('9699A3058085E965EBBDD1F340E2704B', '');
UI.SetText('AC214649586947781DDC6ED01B2849FF', '');
UI.SetText('E7D4AAC268439B2F332446CCF3FD912E', '');
UI.SetText('0D9F9F783E0F3595CF8544B1DB99CE69', '');
UI.SetText('DEA968CADC81774AEAC0D669F1A63EDB', '');
UI.SetText('ACB43D3D8C97900AFCCD64EABDC38A03', '');
UI.SetText('E0C3028D1B5178E01C9733A031990468', '');
UI.SetText('C73FBC69BDB98F3843A5E2479927BA9F', '');
UI.SetText('BF857CECC94B44B14E1C3F1413CE2C16', '');
UI.SetText('85329D5A83E1482FB97109F1CAE7723A', '');
UI.SetText('133FCA6EF933E06E82A3543DE5F39D82', '');
UI.SetText('B326C338ABAC12A22017009C130285FD', '');
UI.SetText('561AE3EEB41FD4B50E34A36B056EDB99', '');
UI.SetText('EEFE8203CB58D9242BAD48000991BB67', '');
UI.SetText('3141E4834CA5704801081EC8B05E68B7', '');
UI.SetText('D5AC8D60362EC54F24BD1C55C37AA1D4', '');
UI.SetText('E043BBAE94E1327E70C16107C51670AF', '');
UI.SetText('7E629F87157F9328EDEB8F148921875D', '');
UI.SetText('02B2665612B669DC69B9491D7425DD49', '');
UI.SetText('CBB643A0D6567898D9DF3D2F0183EA1A', '');
UI.SetText('53A948EB3A7C4776035B8824959A8A37', '');
UI.SetText('FCB4F7FDB831171878A2096AB6D24F2E', '');
UI.SetText('DCFA9591B7C39621D0DCAD6EA99F71CE', '');
UI.SetText('569C04088471AD7061DAB2B6945B3F42', '');
UI.SetText('3EEC0846E75E7D32ED6A733E7720B50C', '');
UI.SetText('ECD1BA3F8E2E8C7A60321513F3DB7CAF', '');
UI.SetText('C634D08DAD135DE57F7AAE164F6D0507', '');
//UI.SetText('FBFE52A3C80EB28DE279A3E19E7BA17F', '');
UI.SetText('2737EA81169C9B1767292FDEEFE0C6F1', '');
UI.SetText('40BF69D46504AC986C726795C0C9D60A', '');
UI.SetText('6497F86533BD0FA5A51235D74C1B8596', '');
UI.SetText('2E4295D692226A50C101588F2A94D2F1', '');
UI.SetText('EBE3605D4BE9E559B02E144F7DC8A734', '');
UI.SetText('26AF85C5353BF3DD83237F5452869725', '');
UI.SetText('EF8B784BB902C9367B467C84CEF4E0C2', '');
UI.SetText('50B93B64309F52F9AA22570A326533F9', '');
UI.SetText('04D33203C59F022DDB57019E1078AC3C', '');
UI.SetText('DD3D686AFE5103576DAD70BB809FA248', '');
UI.SetText('4B2A4F75D41AFE4D720BDB87F3782988', '');
UI.SetText('9E7EAC53004A66C2D64A197C2DD580F8', '');
UI.SetText('8D2FF43795C0D6D891C7886B4E51B634', '');
UI.SetText('7222AF24D9F01208FFC9DE5271000B2F', '');
UI.SetText('E12D919918E2D426A1BFAA160FBF2C52', '');
UI.SetText('0C20F7961523D3A7F5A23F7E66258E37', '');
UI.SetText('D5D27644DEEBB143F799D4A57710EE5C', '');
UI.SetText('3E2BF08557C12315DAB031F20AC2A88D', '');
UI.SetText('A313C46F152ABC0BAFF7197E3C48B9B7', '');
UI.SetText('6CA26AD5CAB9924BD73E69CBF3ACDA73', '');
UI.SetText('660F1A666F5E1665C9E1F2D4837C84B4', '');
UI.SetText('21F36BEFACC3A19D9BAE0F5C20813423', '');
UI.SetText('F58E8BF487BEB6E2092EF442AC7C7823', '');
UI.SetText('6B4747E127B16FF99972A5450F2E9F0E', '');
UI.SetText('CFD704D93BEAC8AD42F8B27037BE9A29', '');
UI.SetText('26A031F32E8CBCD51C8E42EA1E771FCF', '');
UI.SetText('4526688691249E903B669347898DA176', '');
UI.SetText('530DE32288D85F185E971A478A8084B1', '');
UI.SetText('016B4B9A7B82DB459BDA47A731DB6366', '');
UI.SetText('D08B623B37EF426A53B8BDBA92BCC680', '');
UI.SetText('3868A278293D4AECAF210779EAE39E42', '');
UI.SetText('0454CEE94E6CC4901599A98BF61EACBA', '');
UI.SetText('DD006ED5633D64EA85E4FCDACFC9C8D0', '');
UI.SetText('881994396B914524B467A71F88BE36B7', '');
UI.SetText('29AB1E70527BD15AF94C8335FF78B09F', '');
UI.SetText('D86C2DD2608C83B2C845D94979E90F1E', '');
UI.SetText('93710D52AD71D40D27C37131766F097A', '');
UI.SetText('E3E6B465DD120907EC24B5AD0076C416', '');
UI.SetText('45C493DEBD229BF1B0A1FD060A72C292', '');
UI.SetText('C1EAD5F545575A7C99F23D24905FC040', '');
UI.SetText('68DA188530FEF00DC6B2D9032A1CB32B', '');
UI.SetText('360723A9E8DFCE4784CC5EE6D0AFF80F', '');
UI.SetText('B05B2A8634E66ED7F3302C5265540DBD', '');
UI.SetText('4565534C70444BEF2E3E217397CCCBCD', '');
UI.SetText('B65F5196D733B4E7149DB0E4BB4C2816', '');
UI.SetText('B336C4B776B89CFA0C6A639AD3541F2C', '');
UI.SetText('39F48BA1676E09A7D8A549AC742D82D9', '');
UI.SetText('A2F4BE2EE80184BC9FB8EAB4721B4513', '');
UI.SetText('2D6938ADDC101548C0CF03A8B816AC21', '');
UI.SetText('73B2B7EEF774B95E01ED69441E0A0C52', '');
UI.SetText('E39B78BEB24E0F4250ACE57D98C09CFF', '');
UI.SetText('068B9C51BCF9E622686BB850B44C7101', '');
UI.SetText('143D894C3948AD411DD0407E7CF108D5', '');
UI.SetText('CC02F836CA453659E67EF71584201A0B', '');
UI.SetText('4AD722B106CE1B8012078E1FE9CB2B7E', '');
UI.SetText('E9F65EADC354CF5A19AE0A9940CCE119', '');
UI.SetText('B398C7596D4BAB4CA78FE6E7F07D5AF2', '');
UI.SetText('45076F0C261CF002E71292362AAA6A89', '');
UI.SetText('2C4D33A3A66ADBD16A5FEDD365885568', '');
UI.SetText('D669BA5C1322E56768F61C77936F0894', '');
UI.SetText('547A4F4B5617AB5CB946954E6C6DEB33', '');
UI.SetText('95BEDA8B3F96AFFB47BA9D20A8FE46C9', '');
UI.SetText('70C7527DF8E10F2DC4E3A82EDBA4C170', '');
UI.SetText('0703DA2A2AA9C92C9FDBF0F3B557689E', '');
UI.SetText('CE386B23DB69358E72C6A7878D466C65', '');
UI.SetText('71F5CAE123CDCC8D07CB9F6E47D7DF8E', '');
UI.SetText('82362E9B990187A4B8D994C0C0746B7E', '');
UI.SetText('5554B3AF8B019C7C391CAF4BEC088D57', '');
UI.SetText('5D82CC6AF05280D1E9E88B7C456FD1EC', '');
UI.SetText('19CF1F8B842D36290B794D77DC565B68', '');
UI.SetText('6EAB6380D43CA98AE6D4E488E6036801', '');
UI.SetText('069B106741556978D98D862C88F31587', '');
UI.SetText('492B67654466B9B2E73A8782F7840FBD', '');
UI.SetText('FEDF13AD4D400B7A3CD013E47EF8ECB7', '');
UI.SetText('5A036C4ACC562EE038A3DBFAF48765A7', '');
UI.SetText('49C66D8D7EB93540AA185D4FCFCEFD5C', '');
UI.SetText('B74F157569BCEC81DC2A25654AD8F648', '');
UI.SetText('73CF972BCEE3A4D33F8616A7B0085251', '');
UI.SetText('F8F89C76F813B85C690E07450C6E27AF', '');
UI.SetText('6AFE14A30E297A85F8D6DBE6A80F6540', '');
UI.SetText('EF52A2DA13F0FF9E3B8E28FB5E58B436', '');
UI.SetText('9C0989EA16AEECABE41AB96E78153B84', '');
UI.SetText('A2AB3A13C0B407C2ECDD0EB854BDEC09', '');
UI.SetText('EB8FA58362AA60BC13BF11D29F231057', '');
}
UI_INIT();
/*初始化Excel 在打开Excel文件前必须执行*/
Excel.Init('');
var FileName = UI.OpenFile('文件类型: Excel|*.xls', '');
/*检测是否为合格Excel文件*/
if (Excel.CheckExcelFile(FileName))
{
/* UI.ShowInfo('打开了一个Excel文件:' + FileName);*/
/* 打开Excel文件*/
Excel.OpenExcel(FileName);
Excel.SelectSheet('选择工作区');
var SheetName = Excel.GetActiveSheetName();
Excel.SetActiveSheet(SheetName);
/* 缓存Excel文件路径*/
//Cache.AddString('63E8D4A3C1ED94B8CF240C567925810C', FileName);
/* 缓存Excel工作区*/
//Cache.AddString('97F97825D72FD1158A061B4E068CDAD2', SheetName);
var Str_1 = '';
var Str_2 = '';
var Str_3 = '';
var Str_4 = '';
var Str_5 = '';
var Str_6 = '';
var Str_7 = '';
var Str_8 = '';
var Str_9 = '';
var Str_10 = '';
var Flag = new Number(0);
System.RunTimeLog('开始循环');
var i = 0;
var j = 0;
var RowNo = '';
var CurrName = '';
var Str_NO = 0;
var init = 0;
var boend = 0;
var MainFlag = ''; //户主标记
var MainNo = ''; //股份证书编号(18位)
var BoBreak = 0;
var NumCount = new Number(0); //持股人数
var nCount = new Number(0); //本excel文件总股数
var nSubCount = new Number(0); //本户主下总股数
var Str_Temp = '';
Str_NO = Excel.Cells(8, 2);
nCount = 0;
MainFlag = Code.Trim(Excel.Cells(6, 2));
System.RunTimeLog('nCount>>' + nCount);
for (i = 2; i < 100000; i++)
{
if (
(Code.Trim(Excel.Cells(1, i)) == '') &&
(Code.Trim(Excel.Cells(2, i)) == '') &&
(Code.Trim(Excel.Cells(3, i)) == '') &&
(Code.Trim(Excel.Cells(4, i)) == '') &&
(Code.Trim(Excel.Cells(5, i)) == '') &&
(Code.Trim(Excel.Cells(6, i)) == '') &&
(Code.Trim(Excel.Cells(7, i)) == '') &&
(Code.Trim(Excel.Cells(8, i)) == '') &&
(Code.Trim(Excel.Cells(9, i)) == '') &&
(Code.Trim(Excel.Cells(10, i)) == '')
)
{
break;
}
if (Code.Trim(Excel.Cells(10, i)) != '')
{
Str_Temp = '"' + Code.Trim() +'"';
nCount += Excel.CellsValue(10, i);
//System.RunTimeLog('parserFloat:' + Str_Temp + '>>' + nCount);
}
}
for (i = 2; i < 2000; i++)
{
System.RunTimeLog('循环:' + i);
if (
(Code.Trim(Excel.Cells(1, i)) == '') &&
(Code.Trim(Excel.Cells(2, i)) == '') &&
(Code.Trim(Excel.Cells(3, i)) == '') &&
(Code.Trim(Excel.Cells(4, i)) == '') &&
(Code.Trim(Excel.Cells(5, i)) == '') &&
(Code.Trim(Excel.Cells(6, i)) == '') &&
(Code.Trim(Excel.Cells(7, i)) == '') &&
(Code.Trim(Excel.Cells(8, i)) == '') &&
(Code.Trim(Excel.Cells(9, i)) == '') &&
(Code.Trim(Excel.Cells(10, i)) == '')
)
{
System.RunTimeLog('读取完Excel:' + i);
break;
}
/* 初始化变量*/
Str_1 = '';
Str_2 = '';
Str_3 = '';
Str_4 = '';
Str_5 = '';
Str_6 = '';
Str_7 = '';
Str_8 = '';
Str_9 = '';
Str_10 = '';
//System.RunTimeLog('Reset Flag');
RowNo = Excel.Cells(1, i);
CurrName = Excel.Cells(3, 3);
System.RunTimeLog('i:' + i + ' ' + Excel.Cells(2, i));
System.RunTimeLog('No:' + Str_NO + ' CurrName:' + CurrName);
Str_NO = Excel.Cells(3, 2);
MainFlag = Code.Trim(Excel.Cells(6, i));
//换证 if (Str_NO <> Excel.Cells(1, i))
if (MainFlag == '是')
{
MainNo = Code.Trim(Excel.Cells(3, i)); //股份证书编号(18位)
Flag = 0;
NumCount = 0; //持股人数
nSubCount = 0; //本户主下总股数
System.RunTimeLog('新户主 :' + 'MainNo:' + MainNo + ' name:' + Excel.Cells(5, i));
System.RunTimeLog('sub loop：' + MainNo );
UI.ShowInfo('请放好空白证书');
UI_INIT();
for (j = 2; j < 10000; j++)
{
if (MainNo == Code.Trim(Excel.Cells(3, j)))
{
Flag++; //累加打印行
NumCount++; //累加持股人数
Str_1 = Excel.Cells(5, j); //姓名
Str_2 = Excel.Cells(9, j); //性别
Str_3 = Excel.Cells(7, j); //与户主关系
Str_4 = Excel.Cells(8, j); //身份证号码
Str_5 = Excel.Cells(10, j); //持股数
nSubCount += Excel.CellsValue(10, j);
System.RunTimeLog('Flag :' + Flag + ' ' + ' 姓名:' + Str_1 + ' ' + 'MainNo:' + MainNo + ' Cell:' + Code.Trim(Excel.Cells(3, j)));
if (Flag == 1)
{
UI.SetText('7E9A6FDF9BCFD180399EC76290F13337', Str_1);
UI.SetText('33844FEA3321D45CB2CA13E708E632E8', Str_2);
UI.SetText('C1742476E514D9196A275E6514914477', Str_3);
UI.SetText('AC214649586947781DDC6ED01B2849FF', Str_4);
UI.SetText('561AE3EEB41FD4B50E34A36B056EDB99', Str_5);
}
if (Flag == 2)
{
UI.SetText('516DE63A2CCFD5E3750985305BCA564C', Str_1);
UI.SetText('2541E18DC666770B18E123E62234266D', Str_2);
UI.SetText('800BE6B74D7B5E9968A05CFDE493ED0F', Str_3);
UI.SetText('E7D4AAC268439B2F332446CCF3FD912E', Str_4);
UI.SetText('EEFE8203CB58D9242BAD48000991BB67', Str_5);
}
if (Flag == 3)
{
UI.SetText('6F854AF7C5969ACA33A2B0EBCA3569CA', Str_1);
UI.SetText('6C3098E2785BB7FDA45A8E506E0DB3D3', Str_2);
UI.SetText('2A62F5E7B0136572CDF136B454D34807', Str_3);
UI.SetText('0D9F9F783E0F3595CF8544B1DB99CE69', Str_4);
UI.SetText('3141E4834CA5704801081EC8B05E68B7', Str_5);
}
if (Flag == 4)
{
UI.SetText('BE3FFE6D6592F578833EE3AED1E07B30', Str_1);
UI.SetText('E8803DA58FA91EA4678014A28AC207A9', Str_2);
UI.SetText('3AC92206A4431F907EEBB9A62051AE7C', Str_3);
UI.SetText('DEA968CADC81774AEAC0D669F1A63EDB', Str_4);
UI.SetText('D5AC8D60362EC54F24BD1C55C37AA1D4', Str_5);
}
if (Flag == 5)
{
UI.SetText('21E27823F9229C77E7585CAC0267DFD6', Str_1);
UI.SetText('B4E19F19DFF4AE84315709C0AC617158', Str_2);
UI.SetText('0C9B3D31A1DA72A09FE70DB3739CED9E', Str_3);
UI.SetText('ACB43D3D8C97900AFCCD64EABDC38A03', Str_4);
UI.SetText('E043BBAE94E1327E70C16107C51670AF', Str_5);
}
if (Flag == 6)
{
UI.SetText('937E7C096525EF4AFAFF78D4CD29E1F0', Str_1);
UI.SetText('1B76ED0AA22AC0B16BF98CC19C02B099', Str_2);
UI.SetText('6B54CEAD468FB42874F467C7638AC5D4', Str_3);
UI.SetText('E0C3028D1B5178E01C9733A031990468', Str_4);
UI.SetText('7E629F87157F9328EDEB8F148921875D', Str_5);
}
if (Flag == 7)
{
UI.SetText('17A58E104A05DABF26AFF57607A114E6', Str_1);
UI.SetText('1820A034B8E8D99060CDA78076FF0249', Str_2);
UI.SetText('AC5E33A6E115C3B5E94942FEF24F8A55', Str_3);
UI.SetText('C73FBC69BDB98F3843A5E2479927BA9F', Str_4);
UI.SetText('02B2665612B669DC69B9491D7425DD49', Str_5);
}
if (Flag == 8)
{
UI.SetText('0EC7A6886E860B5A7F936104139799AF', Str_1);
UI.SetText('9A68DE7293C5924A509EA5A8E46DE7F7', Str_2);
UI.SetText('D0CB30F42D58CCC051713D982E3098B2', Str_3);
UI.SetText('BF857CECC94B44B14E1C3F1413CE2C16', Str_4);
UI.SetText('CBB643A0D6567898D9DF3D2F0183EA1A', Str_5);
}
if (Flag == 9)
{
UI.SetText('4A211A7A583D52353A3D76C2B3EDF989', Str_1);
UI.SetText('66BE5BF4360E5AD6FECEBD069E03AE72', Str_2);
UI.SetText('28C2C9B571D91AD80FC7FBECCD978991', Str_3);
UI.SetText('85329D5A83E1482FB97109F1CAE7723A', Str_4);
UI.SetText('53A948EB3A7C4776035B8824959A8A37', Str_5);
}
if (Flag == 10)
{
UI.SetText('1C98422FF1B3B77CD29F9C4C9D9CC458', Str_1);
UI.SetText('C4CFC9DBE003916504216F9B8E0DB184', Str_2);
UI.SetText('133FCA6EF933E06E82A3543DE5F39D82', Str_3);
UI.SetText('DCFA9591B7C39621D0DCAD6EA99F71CE', Str_4);
UI.SetText('569C04088471AD7061DAB2B6945B3F42', Str_5);
}
if (Flag == 11)
{
UI.SetText('B39D8A1768818CE7C293DAF2EBCE3D22', Str_1);
UI.SetText('EB548D196822CA8C1FAA07E173A585DD', Str_2);
UI.SetText('B326C338ABAC12A22017009C130285FD', Str_3);
UI.SetText('7289A8E6FA3C7B3B6075C528B4F479B1', Str_4);
UI.SetText('3EEC0846E75E7D32ED6A733E7720B50C', Str_5);
}
if (Flag == 12)
{
UI.SetText('9AD5A12BEB4F729B459CEC1DD8E5AD0A', Str_1);
UI.SetText('9699A3058085E965EBBDD1F340E2704B', Str_2);
UI.SetText('FCB4F7FDB831171878A2096AB6D24F2E', Str_3);
UI.SetText('9966751A80AA6BA929749F1915190E24', Str_4);
UI.SetText('ECD1BA3F8E2E8C7A60321513F3DB7CAF', Str_5);
}
} //if (MainNo = Code.Trim(Excel.Cells(3, j)))
else
{
if (
(Code.Trim(Excel.Cells(1, j)) == '') &&
(Code.Trim(Excel.Cells(2, j)) == '') &&
(Code.Trim(Excel.Cells(3, j)) == '') &&
(Code.Trim(Excel.Cells(4, j)) == '') &&
(Code.Trim(Excel.Cells(5, j)) == '') &&
(Code.Trim(Excel.Cells(6, j)) == '') &&
(Code.Trim(Excel.Cells(7, j)) == '') &&
(Code.Trim(Excel.Cells(8, j)) == '') &&
(Code.Trim(Excel.Cells(9, j)) == '') &&
(Code.Trim(Excel.Cells(10, j)) == '')
)
{
System.RunTimeLog('读取完Excel J循环:' + i);
break;
}
}
} //for (j = 2; j < 100; j++)
Str_8 = Excel.Cells(5, i); //本户姓名
Str_9 = Excel.Cells(4, i); //地址
UI.SetText('0C261BB9FF8AAB529E11BE6EE77BED0D', Str_8);
UI.SetText('A883E33D449FB9CE21FA0C05EF7AB9D8', Str_9);
UI.SetText('E7B79865230FBD2B28C84CFA4B682873', NumCount);
//System.RunTimeLog('sub loop：' + MainNo + Str_8 + Str_9 + NumCount);
//UI.SetText('FBFE52A3C80EB28DE279A3E19E7BA17F', nCount);
UI.SetText('C634D08DAD135DE57F7AAE164F6D0507', nSubCount);
//System.RunTimeLog('使用模板默认打印机打印 股份证书编号(18位):' + MainNo);
Print.DefaultPrint(); /*使用模板默认打印机打印*/;
} //if (MainFlag == '是')
} // for loop i
//Print.DefaultPrint(); /*使用模板默认打印机打印*/;
} else //2
{
UI.ShowError('无效的Excel文件, 文件路径:' + FileName);
}
微信公众账号|
销售人员微信
|
销售人员QQ
|
苏公网安备 32050802010829号
飚风™合同打印软件
