c - 如何使用c socket程序将捕获的数据包保存在LibreOffice Calc中而不是txt文件中？-6ren

c - 如何使用c socket程序将捕获的数据包保存在LibreOffice Calc中而不是txt文件中？

转载作者：行者123 更新时间：2023-12-03 11:52:10

我的项目是关于在客户端以混杂模式捕获数据包并在服务器端处理它(区分 tcp、udp、icmp)，这是在 ubuntu 13.04 中使用 C 套接字代码完成的。

截至目前，输出存储在一个 txt 文件中，但我想将这些数据包字段保存在 LibreOffice Calc 的单元格中，以便我可以编辑单元格，只选择那些需要的数据包。

不知道能不能做到？如果可能的话，有人可以帮助我吗？还有怎么做？

我的输出 txt 文件看起来是这样的(这里只显示了 udp 数据包)

 This Report is from the Task agent whose IP is 127.0.0.1


 ***********************UDP Packet*************************

Ethernet Header
|-Destination Address : 01-00-5E-00-00-02 
|-Source Address      : 00-00-0C-07-AC-3B 
|-Protocol            : 8 

IP Header
|-IP Version        : 4
|-IP Header Length  : 5 DWORDS or 20 Bytes
|-Type Of Service   : 192
|-IP Total Length   : 48  Bytes(Size of Packet)
|-Identification    : 0
|-TTL      : 1
|-Protocol : 17
|-Checksum : 61927
|-Source IP        : 172.16.59.3
|-Destination IP   : 224.0.0.2

UDP Header
|-Source Port      : 1985
|-Destination Port : 1985
|-UDP Length       : 28
|-UDP Checksum     : 42701

IP Header
01 00 5E 00 00 02 00 00 0C 07 AC 3B 08 00 45 C0         ..^........;..E.
00 30 00 00                                             .0..
UDP Header
00 00 01 11 F1 E7 AC 10                                 ........
Data Payload
00 00 10 03 0A 6E 3B 00 63 69 73 63 6F 00 00 00         .....n;.cisco...
AC 10 3B 01 00 00 00 00 00 00 00 00 00 00 00 00         ..;.............
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00                                       ......

###########################################################

我需要将所有这些字段保存在单元格(行)中。我该怎么做？？

edited part

这就是我在服务器端处理数据包的方式

FILE *logfile;
int infile;
struct sockaddr_in source,dest;
int tcp=0,udp=0,icmp=0,others=0,igmp=0,total=0,i,j;

int main()
{
int saddr_size,data_size;  
struct sockaddr saddr;   
unsigned char *buffer3 = (unsigned char *) malloc(1024);
char *fname = "/home/shishira/Desktop/packet_capture/task_agent_processed.txt";
infile=open("info_agent_report.txt",O_RDONLY);
if(infile==-1)
 {
    perror("cannot open info_agent_report file\n");
    return(1);
 }  

logfile=fopen("task_agent_processed.txt","w");
if(logfile==NULL)
 {
printf("Unable to create task_agent_processed file.");
 }

printf("\n Starting..\n");
saddr_size = sizeof saddr;     

do
{   

 data_size=read(infile,buffer3,1024);

 ProcessPacket(buffer3 , data_size);  

 }
while(data_size>0);


fclose(logfile);
close(infile);   
printf("\n");
printf(" Finished\n\n");
printf("-------------------\n\n");
return 0;
}

void ProcessPacket(unsigned char* buffer, int size)
{
 //Get the IP Header part of this packet , excluding the ethernet header
 struct iphdr *iph = (struct iphdr*)(buffer + sizeof(struct ethhdr));
 ++total;
 switch (iph->protocol) //Check the Protocol and do accordingly...
  {
  case 1:  //ICMP Protocol
    ++icmp;
    print_icmp_packet( buffer , size);
    break;

case 2:  //IGMP Protocol
    ++igmp;
    break;

case 6:  //TCP Protocol
    ++tcp;
    print_tcp_packet(buffer , size);
    break;

case 17: //UDP Protocol
    ++udp;
    print_udp_packet(buffer , size);
    break;

default: //Some Other Protocol like ARP etc.
    ++others;
    break;
}

printf("            TCP : %d   UDP : %d   ICMP : %d   Others : %d   Total : %d\r", tcp ,  

udp , icmp  , others , total);   
}


void print_udp_packet(unsigned char *Buffer , int Size)
{     
 unsigned short iphdrlen;

 struct iphdr *iph = (struct iphdr *)(Buffer +  sizeof(struct ethhdr));
 iphdrlen = iph->ihl*4;

 struct udphdr *udph = (struct udphdr*)(Buffer + iphdrlen  + sizeof(struct ethhdr));

 int header_size =  sizeof(struct ethhdr) + iphdrlen + sizeof udph;

 fprintf(logfile , "\n\n***********************UDP Packet*************************\n");

 print_ip_header(Buffer,Size);          

 fprintf(logfile , "\nUDP Header\n");
 fprintf(logfile , "   |-Source Port      : %d\n" , ntohs(udph->source));
 fprintf(logfile , "   |-Destination Port : %d\n" , ntohs(udph->dest));
 fprintf(logfile , "   |-UDP Length       : %d\n" , ntohs(udph->len));
 fprintf(logfile , "   |-UDP Checksum     : %d\n" , ntohs(udph->check));

 fprintf(logfile , "\n");
 fprintf(logfile , "IP Header\n");
 PrintData(Buffer , iphdrlen);

 fprintf(logfile , "UDP Header\n");
 PrintData(Buffer+iphdrlen , sizeof udph);

 fprintf(logfile , "Data Payload\n");   

 //Move the pointer ahead and reduce the size of string
 PrintData(Buffer + header_size , Size - header_size);

 fprintf(logfile , "\n###########################################################");
}
}
}

我刚刚在这里包含了 udp 数据包。在 fprintf 语句中，我用来打印文件处理程序为“logfile”的文件中的所有数据包。我得到的输出看起来像这样

最佳答案

例如，如果您需要将整个报告放到一个 Excel 单元格中，那么您可以在此输出的开头和结尾放置“”。然后你可以将它保存为 *.csv 文件并用 Excel、LibreOffice.Calc 等打开它。所以在这种情况下(“在开头和结尾)你将在第一个单元格中获得所有这些输出:

enter image description here

如果您需要在单元格之间不同地传播数据 - 使用逗号和“”:
“第一行，第一个单元格”，“第一行，第二个单元格”，...
“第二行，第一个单元格”，“第二行，第二个单元格”，...
...

例如:

user@host $ cat new1.csv 
"first row, first cell", "first row, second cell"
"second row, first cell", "second row, second cell"

然后它可以在 LibreOffice.Calc 中打开，结果如下:
enter image description here

更新:将问题的输出数据传播到不同的单元格:
我放了几个 , 和 " 从问题变成原始报告:

"This Report is from the Task agent whose IP is 127.0.0.1


 ***********************UDP Packet*************************"
"
Ethernet Header
|-Destination Address : 01-00-5E-00-00-02 
|-Source Address      : 00-00-0C-07-AC-3B 
|-Protocol            : 8 
","
IP Header
|-IP Version        : 4
|-IP Header Length  : 5 DWORDS or 20 Bytes
|-Type Of Service   : 192
|-IP Total Length   : 48  Bytes(Size of Packet)
|-Identification    : 0
|-TTL      : 1
|-Protocol : 17
|-Checksum : 61927
|-Source IP        : 172.16.59.3
|-Destination IP   : 224.0.0.2
","
UDP Header
|-Source Port      : 1985
|-Destination Port : 1985
|-UDP Length       : 28
|-UDP Checksum     : 42701
","
IP Header
01 00 5E 00 00 02 00 00 0C 07 AC 3B 08 00 45 C0         ..^........;..E.
00 30 00 00                                             .0..
UDP Header
00 00 01 11 F1 E7 AC 10                                 ........
Data Payload
00 00 10 03 0A 6E 3B 00 63 69 73 63 6F 00 00 00         .....n;.cisco...
AC 10 3B 01 00 00 00 00 00 00 00 00 00 00 00 00         ..;.............
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00         ................
00 00 00 00 00 00                                       ......

###########################################################"

它导致以下通过 excel 单元格传播:
enter image description here

关于c - 如何使用c socket程序将捕获的数据包保存在LibreOffice Calc中而不是txt文件中？，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/20235140/

文章推荐：在方法(类)中使用时，PHP 套接字绑定(bind)/监听不起作用

文章推荐： sockets - D 中的 MSG_WAITALL 标志

文章推荐： sockets - 具有自定义负载平衡功能的ZMQ socket

文章推荐： sockets - UNIX系统中的echo.sock是什么？

python - 解码十六进制(？)数据包
使用 Python 的 rtmplib 绑定(bind)并遇到一些问题。首先，我有这样的东西: import librtmp conn = librtmp.RTMP(...) conn.con
HTTP 数据包，发生了什么？
基本上，我是在查看 Motorstorm 排行榜时在 PS3 上窃听数据包。排行榜以 XML 格式发送到我的 ps3，但只有在我获得授权后。那么有人可以告诉我这三个数据包之间发生了什么，以及我如何在浏
握手后的 TCP 数据包
我正在努力了解 TCP，但解析大量 RFC 并没有帮助。我相信我了解连接和关闭握手，但我似乎无法找到任何总结实际数据流的内容。在连接和关闭握手之间 TCP 数据包看起来像什么？ (特别是标题) 最佳
Android::TCP 数据包
我正在尝试通过 RCON 端口与我的 Minecraft 服务器通信。虽然我不知道如何使用套接字和流的东西。四处寻找，我发现他们都有一些共同点。套接字、输入流和输出流。我在我的代码中试过了，但返回
networking - 过滤意外发送到我的端口的 UDP 数据包
我正在 UDP 之上设计一个简单的协议(protocol)，现在我意识到其他人可以将数据包发送到我正在监听的端口。这样的数据包对于我的应用程序来说显然是不正确的(我现在不担心安全问题) 是否有过滤这些
networking - 游戏服务器应该如何以定义的滴答率接收 udp 数据包？
我目前有一个具有可自定义滴答率的游戏服务器，但在本示例中，我们建议服务器每秒仅滴答一次或 1hz。我想知道如果客户端发送速率比服务器快，因为我当前的设置似乎不起作用，那么处理传入数据包的最佳方法是什么
c# - 以正确的字节顺序发送 UDP 数据包
我无法理解网络字节顺序以及通过 UDP 发送和接收数据的顺序。我正在使用 C#。我有一个结构保持: message.start_id = 0x7777CCCC; message.me
usb - USB 主机何时在控制读取传输结束时需要零长度的 IN 数据包？
我正在为 USB 设备编写代码。假设 USB 主机开始控制读取传输以从设备读取一些数据，并且请求的数据量(设置数据包中的 wLength)是端点 0 最大数据包大小的倍数。那么在主机接收到所有数据后(
Wireshark 数据包 'Data' 格式
我有一台 Windows PC、Marvell 交换机、Netgear 交换机和一台 Ubuntu 机器连接在一起(通过 Netgear 交换机)。我最近从 Windows PC 向 Marvell
sockets - 识别 DNS 数据包
在查看数据包字节码时，您将如何识别 dns 数据包。 IP header 的协议(protocol)字段会告诉后面有一个 UDP 帧，但是在 UDP 帧内没有协议(protocol)字段来指定接下来会
c# - 重组分片的 UDP 数据包
我有一个通过 udf 的 802.11 (wifi) 上各种类型的流量的 pcap。由于 MTU，udp(或更准确地说是 IP)对 wifi 数据包进行分段。我目前正在使用 SharpPcap 读取并
macos - 什么是 'k' 数据包？
我正在开发的 Core Audio 应用程序上有此崩溃日志。我目前正在调试它，所以我的问题不是关于崩溃本身，而是关于的含义“k”包 . 这是什么意思？我已阅读 this , 和 this (关于
sockets - 仅在混杂模式下接收的 UDP 数据包
我在一台 VM Ubuntu 16.04 机器上的 100 个多播组上生成 UDP 数据包，并在另一台 VM Ubuntu 16.04 机器上订阅这些组。两者都在由 Hyper-V 管理器运行的 HP
java - 为什么我的简单应用程序没有收到 UDP 数据包
这个问题在这里已经有了答案: How can I fix 'android.os.NetworkOnMainThreadException'? (66 个回答) 6年前关闭。我正在尝试创建一个简单的
java - 创建原始数据包以欺骗 UDP 数据包
我正在寻找使用 Java 来欺骗 UDP 数据包。是否有任何好的 Java 库可以让您创建自己的 RAW SOCKETS？最佳答案我会使用包装 libpcap 的 Java API . libpc
websocket - 无法读取我的 websocket 数据包
我在基于 Tyrus 的客户端和 tomcat Web 服务器之间使用没有压缩的 websocket。我在 tomcat 端看到消息传入和传出我的套接字，但如果我设置一个wireshark来观察它们传
java - 模拟器中未从本地主机收到 UDP 数据包
我的应用程序在模拟器中运行时无法接收 UDP 数据包。 UDP 数据包由“localhost”上的以下 java 程序通过端口 49999 发送。 DatagramSocket clien
java - 需要一种可中断的方式来监听工作线程中的 UDP 数据包
我正在开发一个 Google Glass 应用程序，它需要在工作线程中监听 UDP 数据包(与发送 UDP 数据包的现有系统集成)。我之前发布了一个问题(请参阅 here )并收到了一个答案，其中提供
java - 服务器未正确读取发送的 UDP 数据包
我正在从客户端向服务器发送两个数据包。我遇到的问题是，在服务器上读取的数据使两个字符串对于发送的最长字符串具有相同的长度。例如: 如果字符串 1 为:1234 字符串 2 为:abcdefghi 服务
java - 在同一类中发送和接收 UDP 数据包
我知道这是不好的做法，但是可以执行以下操作吗？ Send packet1 to UDP port 1 port 1 receives packet1 and sends it to port 2 po

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

c - 如何使用c socket程序将捕获的数据包保存在LibreOffice Calc中而不是txt文件中？