急：：servlet如何传送CSV文件到客户端，并且在客户端直接用excel打开？？

Question

msn:[email protected]   在先等待

Answer 1

我还是鞋垫代码吧
servlet中
response.setcontenttype("text/csv");
但是他又提示对话框，我现在不想要，想让它直接调用excel 打开

Answer 2

试试这个
response.setcontenttype("text/msexcel");

Answer 3

response.setContentType("text/msexcel");

Answer 4

http://www.csdn.net/develop/Read_Article.asp?Id=22939

Answer 5

response.setContentType("text/msexcel");
但是出现提示保存打开对话框？怎么办？另外如何控制excel中的数据格式阿
例如
     1 
     1
     1
all
我想让他们都靠右，如何处理，谢谢

Answer 6

在你的webapp中WEB-INF\的web.xml中加入mime-type试试，在我这里这样就可以。没有弹出对话框   <mime-mapping>
        <extension>xls</extension>
        <mime-type>text/msexcel</mime-type>
    </mime-mapping>
     <mime-mapping>
        <extension>csv</extension>
        <mime-type>text/msexcel</mime-type>
    </mime-mapping>

Answer 7

excel数据格式怎么控制呢，？
谢谢

Answer 8

httpServletResponse.setContentType("application/msexcel;charset=Shift_JIS");
      httpServletResponse.setHeader("Content-disposition", "inline;filename=temp.csv");//MIME type for EXCEL doc
     FileReader fr = new FileReader("F:/hysoft.csv");
     PrintWriter pr = httpServletResponse.getWriter();
     char c[] = new char[4096];
     int read = 0;
     while((read = fr.read(c)) != -1) {
        pr.write(c,0,read);     }
     fr.close();
     pr.close();

Answer 9

还是有提示的
<mime-mapping>
        <extension>xls</extension>
        <mime-type>text/msexcel</mime-type>-------------？？？application/msexcel
    </mime-mapping>
     <mime-mapping>
        <extension>csv</extension>
     <mime-type>text/msexcel</mime-type>-------------??appication/msexcel         </mime-mapping>

Answer 10

格式估计通过程序很难控制。mime-type中还有什么提示呀？

Answer 11

o                    .  .- .-
                                                        ./    .--...
                                   o          .-------- $    .--
                              o  分    o     /                 .......
                                            '                  ..
                             o   o    o      '........            ----
                                       o 分           .          --..
                            o    o         o           .   .---..   -
                                       o               .  '     -.
                                    o   o             /   '
                                   o  分               / ' ' '
                                   \-----/....... . '  ' '  '
                                    \ __/ -      - -'  '  ' '
                                                    '  '  ' '
                                     o              '   ' ' '
                                                    '   '  '
                                                     -..'.----------.
                                                        I   ----------
                                                 /////////.经典,请支持http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983http://expert.csdn.net/Expert/topic/2921/2921075.xml?temp=.9381983

Answer 12

客户端如果安装了Excel就会自动打开Excel并显示的：）