|
Excel View |
Top Previous Next |
|
Microsoft Excel® is powerful spreadsheet application written and distributed by Microsoft for Microsoft Windows and Macintosh.
Microsoft Excel features calculation, graphing tools, pivot tables and macro languages. Many users over the world use Excel everyday for their daily jobs. So why don't bring Excel power into Packet analysis? We can see many tools can export packet information into a csv (comma seperated values) to annouce they support Excel, however, that is a complete cheat to PacketBone's point of view.
PacketBone releases BoneLight as the first product support Excel in natural. BoneLight generate the Excel spreadsheets from trace files with List, Graphs, PivotTable and PivotGraph support. All those useful elements are generated automatically without manual operation involved. When people get the result, they can easily add, modify and remark relevant required freely into the spreadsheets. We are proudly to announce that although the spreadsheets generated has many dynamic graph and tables, there is no any VBA macro used in the full workbook. So distribution and reading the workbook can be surely secured without worrying about Macro-Viruses or similar risks.
BoneLight does require Office 2003/2007 installed on the machine to export enhanced Excel spreadsheets. However, the Office 2007 improves very much in the layout and color rendering. So we highly recommend the BoneLight users upgrade to Office 2007 to generate the Excelview for trace files.
There are currently 6 visible sheets implemented in the ExcelView of a trace file. Please notice that Excel 2007 and Excel 2003 has different limit on the row count of a sheet. Excel 2007 has a 1 million row limit in a single sheet. Excel 2003 has only 65536 in maximum for the row count in one sheet. So in Excel 2003 export result, if a trace file has more than 65535 packets, BoneLight will split those packets into multiple "Packets" sheet, in that case, you will get more than 6 visible sheets in the ExcelView.
The 5 visible worksheets are "Summary" "Packets" "Hosts" "Graphs"
|