求助：航天开票系统文本接口导出的文本文件如何转换为ELCEL文件

cwcczp

如题？谢谢！！！

[此贴子已经被作者于2006-11-29 10:44:06编辑过]

PDJ72

<p>1、先粘贴，然后用数据中的分列</p><p>2、用数据中的外部数据导入</p>

cwcczp

<p>谢谢！！是否有办法转换成以下固定的格式：</p><p>发票号&nbsp;&nbsp;&nbsp; 发票代码&nbsp;&nbsp;&nbsp; 产品名称&nbsp;&nbsp;&nbsp;&nbsp; 规格型号&nbsp;&nbsp;&nbsp;数量&nbsp;&nbsp;&nbsp; 单价&nbsp;&nbsp;&nbsp;&nbsp; 金额 &nbsp;&nbsp; 购货方名称&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 购货方税号&nbsp;&nbsp;&nbsp;&nbsp;作废否&nbsp;</p><p>注：我一张发票可能开好几个产品。</p><p>谢谢！！！！&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p><p></p>

[此贴子已经被作者于2006-11-29 13:46:10编辑过]

caimaorong

<p>是什么版本的呀</p><p></p>

cwcczp

<p>6.0的，一机多票。</p>

徒然客

导出未打印税票数据生成的文本格式说明如下:<br/>SJJK0101~~销售单据传入~~2004-04-07--2004-04-07税票导出<br/>10903609193~~1~~昆明家乐福超市有限公司~~530103738067404~~昆明市南屏街88号世纪广场0871-3623495~~中国银行昆明市东风行05589208092001~~订单号(44D374522)~~杨协新~~夏荧~~~~2004-04-07~~中国民生银行深南支行8742502-22200-01-001383<br/>蒙牛29TI-9000~~台~~29TI-9000~~2~~2905.98~~.17~~1510~~122.22~~494.02~~20.78~~<br/>10903609194~~1~~昆明家乐福超市有限公司~~530103738067404~~昆明市南屏街88号世纪广场0871-3623495~~中国银行昆明市东风支05589208092001~~订单号(44D374523P)~~杨协新~~夏荧~~~~2004-04-07~~中国民生银行深南支行8742502-22200-01-001383<br/>蒙牛43PTV300S~~台~~43PTV300S~~1~~5982.05~~.17~~1510~~251.28~~1016.95~~42.72~~<br/>10903609195~~2~~昆明家乐福超市有限公司~~530103738067404~~昆明市南屏街88号世纪广场0871-3623495~~中国银行昆明市东风支05589208092001~~订单号(44D374443P)~~杨协新~~夏荧~~~~2004-04-07~~中国民生银行深南支行8742502-22200-01-001383<br/>蒙牛25N61AA~~台~~25N61AA~~2~~1914.53~~.17~~1510~~80.48~~325.47~~13.68~~<br/>蒙牛TFT15AAB~~台~~TFT15AAB~~1~~3290.6~~.17~~1510~~138.32~~559.4~~23.52~~<br/>......<br/>......<br/>其中文本第一行是未打印发票的日期范围,也就是操作员在界面上选择的日期范围.<br/>第二和第三行写入单据头'10903609193为单据号，1为商品行数，昆明家乐福超市有限公司为购方名称，530103738067404为购方税号，昆明市南屏街88号世纪广场0871-3623495为购方地址电话，中国银行昆明市东风行05589208092001为购方银行账号，订单号(44D374522)为备注，杨协新为复核人，夏荧为收款人(也即开单人)，2004-04-07为单据日期，中国民生银行深南支行8742502-22200-01-001383为销方银行帐号(因版面布局所限,其实单据头在文本当中只是一行)<br/>以下是单据号10903609193的销售明细<br/>蒙牛29TI-9000为货物名称，台为单位，29TI-9000为规格，2为数量，2905.98为不含税金额，.17为税率，1510为商品税目，122.22为折扣金额，494.02为税额，20.78为折扣税额<br/>其他销售单据和单据清单内容依次类推.

徒然客

<p>以上是航天导出的固定格式。根据版本的不同似乎还有微小的变化。</p><p>由于格式是固定的。你可以使用excel的分列功能加工。</p><p>如果更进一步的话就要用vba编程转化了。</p>

shouqian2008

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>cwcczp</i>在2006-11-29 13:45:31的发言：</b><br/><p>谢谢！！是否有办法转换成以下固定的格式：</p><p>发票号&nbsp;&nbsp;&nbsp; 发票代码&nbsp;&nbsp;&nbsp; 产品名称&nbsp;&nbsp;&nbsp;&nbsp; 规格型号&nbsp;&nbsp;&nbsp;数量&nbsp;&nbsp;&nbsp; 单价&nbsp;&nbsp;&nbsp;&nbsp; 金额 &nbsp;&nbsp; 购货方名称&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 购货方税号&nbsp;&nbsp;&nbsp;&nbsp;作废否&nbsp;</p><p>注：我一张发票可能开好几个产品。</p><p>谢谢！！！！&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p><p></p><br/></div><p>我公司的税控机接口软件可以达到您的这个要求,详细的资料请看附件! </p><p>&nbsp; </p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 10.7pt; TEXT-ALIGN: left; mso-char-indent-count: 1.0; mso-char-indent-size: 10.7pt; mso-pagination: widow-orphan;"><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">广州市瑞威计算机科技有限公司是一家专门致力于提供企业内部管理系统与防伪税控开票系统联网方案及相关产品研发和服务的企业，主要产品是</span><span lang="EN-US" style="LETTER-SPACING: 0.1pt;"><font face="Times New Roman">“</font></span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">瑞威税控接口管理系统</span><span lang="EN-US" style="LETTER-SPACING: 0.1pt;"><font face="Times New Roman">”</font></span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">（英文名：</span><span lang="EN-US" style="LETTER-SPACING: 0.1pt;"><font face="Times New Roman">LuckyTax</font></span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">，软著登字第</span><span lang="EN-US" style="LETTER-SPACING: 0.1pt;"><font face="Times New Roman">045698</font></span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">号，软件产品登记号：粤</span><span lang="EN-US" style="LETTER-SPACING: 0.1pt;"><font face="Times New Roman">DGY-2006-0050</font></span><span style="FONT-FAMILY: 宋体; LETTER-SPACING: 0.1pt; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman';">）。是省粤税公司认定的可为防伪税控用户开发税控接口软件产品的供应商。</span><span lang="EN-US" style="FONT-SIZE: 12pt; FONT-FAMILY: 'Arial Unicode MS'; LETTER-SPACING: 0.1pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'; mso-font-kerning: 0pt;">
                        <p></p></span></p><p></p><p></p><p><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; LETTER-SPACING: 0.1pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">&nbsp;&nbsp;&nbsp; </span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">经过几年的积累和发展，瑞威接口管理系统凭借其</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">安全、优质、成熟</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">的软件产品和</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">规范、热情、诚信、快速</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">"</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">的服务风格已成为行业品牌，奠定了公司在税控接口行业的领军地位。我们认为：优秀的人才</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">+</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">先进的产品</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">+</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">周到的服务</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">+</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">权威的认可，是我们快速成长的原因。</span></p><br/> lEkNEc1J.rar (35.74 KB, 下载次数: 44)

2007-2-1 14:49 上传

点击文件名下载附件
税控机接口系统可实现你的要求

<br/>

[此贴子已经被作者于2007-2-1 14:49:25编辑过]

cynthia02

<p>不好意思,文本接口文件是花钱买的吗?</p>

cpawei

我公司也有同样的问题，后来在<a href="http://auction1.taobao.com/auction/0/item_detail-0db2-df560fe865fd3968edcc167216d4baa8.jhtml">http://auction1.taobao.com/auction/0/item_detail-0db2-df560fe865fd3968edcc167216d4baa8.jhtml</a>买了个小软件，问题全解决了!这个软件非常有用啊，你也试一试！