資源簡介
com.Ole.excel 源碼,不需要在服務器上安裝Excel,完全使用C#代碼實現,更多excel支持的高級功能可能沒有,但實際開發中基本夠用了.附加了一個示例和一個Table導出到excel的示例

代碼片段和文件信息
namespace?com.Ole.excel
{
????///?
????///?Contains?constant?values?pertaining?to?the?BIFF8?format?for?use?in?MyXLS.
????///?
public?static?class?BIFF8
{
????????///?
????????///?The?name?of?the?Workbook?stream?in?an?OLE2?Document.
????????///?
public?static?readonly?byte[]?NameWorkbook?=?new?byte[]?{
0x57?0x00?0x6F?0x00?0x72?0x00?0x6B?0x00?0x62?0x00?0x6F?0x00?0x6F?0x00?0x6B?0x00?
0x00?0x00};
????????
????????///?
????????///?The?name?of?the?SummaryInformation?stream?in?an?OLE2?Document.
????????///?
public?static?readonly?byte[]?NameSummaryInformation?=?new?byte[]?{
0x05?0x00?0x53?0x00?0x75?0x00?0x6D?0x00?0x6D?0x00?0x61?0x00?0x72?0x00?0x79?0x00
0x49?0x00?0x6E?0x00?0x66?0x00?0x6F?0x00?0x72?0x00?0x6D?0x00?0x61?0x00?0x74?0x00
0x69?0x00?0x6F?0x00?0x6E?0x00?0x00?0x00};
????????///?
????????///?The?name?of?the?DocumentSummaryInformation?stream?in?an?OLE2?Document.
????????///?
????????public?static?readonly?byte[]?NameDocumentSummaryInformation?=?new?byte[]?{
????????????0x05?0x00?0x44?0x00?0x6F?0x00?0x63?0x00?0x75?0x00?0x6D?0x00?0x65?0x00?0x6E?0x00
????????????0x74?0x00?0x53?0x00?0x75?0x00?0x6D?0x00?0x6D?0x00?0x61?0x00?0x72?0x00?0x79?0x00
????????????0x49?0x00?0x6E?0x00?0x66?0x00?0x6F?0x00?0x72?0x00?0x6D?0x00?0x61?0x00?0x74?0x00
????????????0x69?0x00?0x6F?0x00?0x6E?0x00?0x00?0x00};
????????///?
????????///?The?maximum?rows?a?BIFF8?document?may?contain.
????????///?
????????public?const?ushort?MaxRows?=?ushort.MaxValue;
????????///?
????????///?The?maximum?columns?a?BIFF8?document?may?contain.
????????///?
????????public?const?ushort?MaxCols?=?byte.MaxValue;
????????///?
????????///?The?maximum?number?of?bytes?in?a?BIFF8?record?(minus?4?bytes?for?
????????///?the?Record?ID?and?the?data?size?leaves?8224?bytes?for?data).
????????///?
????????public?const?ushort?MaxBytesPerRecord?=?8228;
????????///?
????????///?The?maximum?number?of?bytes?available?for?data?in?a?BIFF8?record
????????///?(plus?4?bytes?for?the?Record?ID?and?the?data?size?gives?8228?total
????????///?bytes).
????????///?
????????public?const?ushort?MaxDataBytesPerRecord?=?8224;
????????///?
????????///?The?Maximum?number?of?characters?that?can?be?written?to?or?read
????????///?from?a?Cell?in?Excel.??I‘m?guessing?it?is?short.MaxValue?instead?
????????///?of?ushort.MaxValue?to?allow?for?double-byte?chars?(Unicode).
????????///?
????????public?const?ushort?MaxCharactersPerCell?=?(ushort)short.MaxValue;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1419??2016-01-14?11:31??SalsNET.sln
?????文件?????126976??2016-01-14?13:43??SalsNET.Common\bin\Debug\SalsNET.Common.dll
?????文件????1234432??2016-01-14?13:43??SalsNET.Common\bin\Debug\SalsNET.Common.pdb
?????文件???????2777??2016-01-14?13:43??SalsNET.Common\Excel\BIFF8.cs
?????文件???????9810??2016-01-14?13:43??SalsNET.Common\Excel\ByteUtil\Bits.cs
?????文件??????11666??2016-01-14?13:43??SalsNET.Common\Excel\ByteUtil\Bytes.cs
?????文件????????427??2016-01-14?13:43??SalsNET.Common\Excel\CachedBlockRow.cs
?????文件??????26350??2016-01-14?13:43??SalsNET.Common\Excel\Cell.cs
?????文件????????761??2016-01-14?13:43??SalsNET.Common\Excel\CellCoordinate.cs
?????文件??????10336??2016-01-14?13:43??SalsNET.Common\Excel\Cells.cs
?????文件????????494??2016-01-14?13:43??SalsNET.Common\Excel\CellTypes.cs
?????文件???????1804??2016-01-14?13:43??SalsNET.Common\Excel\CharacterSets.cs
?????文件???????1806??2016-01-14?13:43??SalsNET.Common\Excel\Color.cs
?????文件??????14886??2016-01-14?13:43??SalsNET.Common\Excel\Colors.cs
?????文件???????8068??2016-01-14?13:43??SalsNET.Common\Excel\ColumnInfo.cs
?????文件???????3948??2016-01-14?13:43??SalsNET.Common\Excel\DataBand\DataBand.cs
?????文件????????454??2016-01-14?13:43??SalsNET.Common\Excel\EscapementTypes.cs
?????文件???????9858??2016-01-14?13:43??SalsNET.Common\Excel\Font.cs
?????文件????????843??2016-01-14?13:43??SalsNET.Common\Excel\FontFamilies.cs
?????文件???????2967??2016-01-14?13:43??SalsNET.Common\Excel\Fonts.cs
?????文件???????1469??2016-01-14?13:43??SalsNET.Common\Excel\FontWeight.cs
?????文件???????7953??2016-01-14?13:43??SalsNET.Common\Excel\Format.cs
?????文件???????6729??2016-01-14?13:43??SalsNET.Common\Excel\Formats.cs
?????文件????????533??2016-01-14?13:43??SalsNET.Common\Excel\FormulaRecord.cs
?????文件????????808??2016-01-14?13:43??SalsNET.Common\Excel\HorizontalAlignments.cs
?????文件????????114??2016-01-14?13:43??SalsNET.Common\Excel\IXFTarget.cs
?????文件???????1061??2016-01-14?13:43??SalsNET.Common\Excel\Linest
?????文件???????3325??2016-01-14?13:43??SalsNET.Common\Excel\MergeArea.cs
?????文件???????8681??2016-01-14?13:43??SalsNET.Common\Excel\Ole2\Directory.cs
?????文件???????1813??2016-01-14?13:43??SalsNET.Common\Excel\Ole2\Header.cs
............此處省略83個文件信息
- 上一篇:C#脫殼工具NETUnpack
- 下一篇:c#GDI+畫點最簡單的處理方式
評論
共有 條評論