通过文件结构直接生成xls文件

 以下代码演示了 直接通过excel可以识别的文件结构生成xls文件的方法，这样就可以不引用麻烦的ole了。

1. using  System;
2. using  System.Collections.Generic;
3. using  System.Text;
4. namespace  ConsoleApplication16
5. {
6.      class  Program
7.     {
8.          static   void  Main( string [] args)
9.         {
10.              //不通过OLE生成excel文件的方法
11.             ExcelWriter excel =  new  ExcelWriter(@ "c:/test.xls" );
12.             excel.BeginWrite();
13.             excel.WriteString(0, 0,  "Name" );
14.             excel.WriteString(0, 1,  "Score" );
15.             excel.WriteString(1, 0,  "jinjazz" ); 
16.             excel.WriteNumber(1, 1, 100);
17.             excel.WriteString(2, 0,  "游客" );
18.             excel.WriteNumber(2, 1, 0);
19.             excel.EndWrite();
20.         }
21.     }
22.      public   class  ExcelWriter
23.     {
24.         System.IO.FileStream _wirter;
25.          public  ExcelWriter( string  strPath)
26.         {
27.             _wirter =  new  System.IO.FileStream(strPath, System.IO.FileMode.OpenOrCreate);
28.         }
29.          /// <summary>
30.          /// 写入short数组
31.          /// </summary>
32.          /// <param name="values"></param>
33.          private   void  _writeFile( short [] values)
34.         {
35.              foreach  ( short  v  in  values)
36.             {
37.                  byte [] b = System.BitConverter.GetBytes(v);
38.                 _wirter.Write(b, 0, b.Length);
39.             }
40.         }
41.          /// <summary>
42.          /// 写文件头
43.          /// </summary>
44.          public   void  BeginWrite()
45.         {
46.             _writeFile( new   short [] { 0x809, 8, 0, 0x10, 0, 0 });
47.         }
48.          /// <summary>
49.          /// 写文件尾
50.          /// </summary>
51.          public   void  EndWrite()
52.         {
53.             _writeFile( new   short [] { 0xa, 0 });
54.             _wirter.Close();
55.         }
56.          /// <summary>
57.          /// 写一个数字到单元格x,y
58.          /// </summary>
59.          /// <param name="x"></param>
60.          /// <param name="y"></param>
61.          /// <param name="value"></param>
62.          public   void  WriteNumber( short  x,  short  y,  double  value)
63.         {
64.             _writeFile( new   short [] { 0x203, 14, x, y, 0 });
65.              byte [] b = System.BitConverter.GetBytes(value);
66.             _wirter.Write(b, 0, b.Length);
67.         }
68.          /// <summary>
69.          /// 写一个字符到单元格x,y
70.          /// </summary>
71.          /// <param name="x"></param>
72.          /// <param name="y"></param>
73.          /// <param name="value"></param>
74.          public   void  WriteString( short  x,  short  y,  string  value)
75.         {
76.              byte [] b = System.Text.Encoding.Default.GetBytes(value);
77.             _writeFile( new   short [] { 0x204, ( short )(b.Length + 8), x, y,0, ( short )b.Length });
78.             _wirter.Write(b, 0, b.Length);
79.         }
80.     }
81. }