Excel文件批量打印股权证软件|苏州飚风™软件有限公司

 

 

 

    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

微信公众账号

工作时间 服务电话(仅对付费用户,免费用户请勿拨打)

地址:江苏省.苏州市.中街路143号501F(近观前街)

苏ICP备11008091号-3 苏公网安备 32050802010829号
 微信交谈    苏州飚风软件有限公司 QQ:1872585922

热烈庆祝苏州飚风®软件有限公司成立11周年 (2010 - 2021)

 

 

 

苏州飚风®软件有限公司 2010 - 2021 © 版权所有