从Excel读取数据批量制作ps图片的脚本.rar

<?xml version="1.0"?> <?mso-application progid="Excel.Sheet"?> <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Created>1996-12-17T01:32:42Z</Created> <LastSaved>2019-05-11T02:19:38Z</LastSaved> <Version>14.00</Version> </DocumentProperties> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"> <RemovePersonalInformation/> </OfficeDocumentSettings> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"> <WindowHeight>4530</WindowHeight> <WindowWidth>8505</WindowWidth> <WindowTopX>3780</WindowTopX> <WindowTopY>-270</WindowTopY> <ProtectStructure>False</ProtectStructure> <ProtectWindows>False</ProtectWindows> </ExcelWorkbook> <Styles> <Style ss:ID="Default" ss:Name="Normal"> <Alignment ss:Vertical="Bottom"/> <Borders/> <Font ss:FontName="宋体" x:CharSet="134" ss:Size="12"/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s89" ss:Name="常规 126"> <Alignment ss:Vertical="Center"/> <Borders/> <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s98" ss:Name="常规 133"> <Alignment ss:Vertical="Center"/> <Borders/> <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/> <Interior/> <NumberFormat/> <Protection/> </Style> <Style ss:ID="s206"> <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:FontName="宋体" x:CharSet="134" ss:Bold="1"/> <Interior/> </Style> <Style ss:ID="s210"> <Alignment ss:Horizontal="Left" ss:Vertical="Center"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000" ss:Bold="1"/> </Style> <Style ss:ID="s211"> <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/> <Borders> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:FontName="宋体" x:CharSet="134" ss:Bold="1"/> <Interior/> </Style> <Style ss:ID="s224" ss:Parent="s98"> <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:FontName="宋体" x:CharSet="134"/> <Interior/> </Style> <Style ss:ID="s323" ss:Parent="s89"> <Alignment ss:Horizontal="Left" ss:Vertical="Center"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/> </Borders> <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/> <Interior/> </Style> </Styles> <Worksheet ss:Name="Sheet1"> <Table ss:ExpandedColumnCount="5" ss:ExpandedRowCount="9" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"> <Column ss:AutoFitWidth="0" ss:Width="95.25"/> <Column ss:AutoFitWidth="0" ss:Width="80.25"/> <Column ss:AutoFitWidth="0" ss:Width="161.25"/> <Column ss:Index="5" ss:AutoFitWidth="0" ss:Width="93.75"/> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s206"><Data ss:Type="String">姓名</Data></Cell> <Cell ss:StyleID="s210"><Data ss:Type="String">工号</Data></Cell> <Cell ss:StyleID="s211"><Data ss:Type="String">部门</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">张珊珊</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311001</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">李思思</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311002</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">王武武</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311003</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">赵柳柳</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311004</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">钱琪琪</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311005</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0" ss:Height="19.5"> <Cell ss:StyleID="s224"><Data ss:Type="String">孙坝坝</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311006</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">周久久</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311007</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> <Row ss:AutoFitHeight="0"> <Cell ss:StyleID="s224"><Data ss:Type="String">吴怡一</Data></Cell> <Cell ss:StyleID="s224"><Data ss:Type="Number">7421311008</Data></Cell> <Cell ss:StyleID="s323"><Data ss:Type="String">质检</Data></Cell> </Row> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Unsynced/> <Selected/> <Panes> <Pane> <Number>3</Number> <ActiveRow>11</ActiveRow> <ActiveCol>4</ActiveCol> </Pane> </Panes> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet2"> <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"> <Row ss:AutoFitHeight="0"/> </Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <Unsynced/> <ProtectObjects>False</ProtectObjects> <ProtectScenarios>False</ProtectScenarios> </WorksheetOptions> </Worksheet> <Worksheet ss:Name="Sheet3"> <Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25"> <Row ss:Aut