[問題] 請問在C++中，如何將資料輸出到EXCEL並依照行位呢?
大家好，小弟因為工作上的需要，得把程式碼中的值輸出到.XLS裡
我的輸出程式碼片段如下
#include "stdio.h"
typedef struct
{
float channel[57];
}Frame;
void main()
{
Frame LiveFrame;
Frame LiveFrame =
{
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f,
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f,
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f,
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f,
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f,
0.f, 0.f, 0.f, 0.f, 0.f, 0.f, 0.f
};
FILE *fp = fopen("E:\\motion1.xls", "a");
fprintf(fp, "%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n %f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n%f\n",
frame->channel[0], frame->channel[1], frame->channel[2],
frame->channel[3], frame->channel[4], frame->channel[5],
frame->channel[6], frame->channel[7], frame->channel[8],
frame->channel[9], frame->channel[10], frame->channel[11],
frame->channel[12], frame->channel[13], frame->channel[14],
frame->channel[15], frame->channel[16], frame->channel[17],
frame->channel[18], frame->channel[19], frame->channel[20],
frame->channel[21], frame->channel[22], frame->channel[23],
frame->channel[24], frame->channel[25], frame->channel[26],
frame->channel[27], frame->channel[28], frame->channel[29],
frame->channel[30], frame->channel[31], frame->channel[32],
frame->channel[33], frame->channel[34], frame->channel[35],
frame->channel[36], frame->channel[37], frame->channel[38],
frame->channel[39], frame->channel[40], frame->channel[41],
frame->channel[42], frame->channel[43], frame->channel[44],
frame->channel[45], frame->channel[46], frame->channel[47],
frame->channel[48], frame->channel[49], frame->channel[50],
frame->channel[51], frame->channel[52], frame->channel[53],
frame->channel[54], frame->channel[55], frame->channel[56]
);
fclose(fp);
}
這樣子的確能夠將我要的數值資料輸出到.XLS檔裡...
但是我希望每57筆資料就換個行位擺放，也就是每57筆就按照EXCEL檔中的A.B.C.D行位擺放
請問各位大大，小弟該怎麼做呢?
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 120.107.168.251
→
09/11 21:36, , 1F
09/11 21:36, 1F
→
09/11 21:36, , 2F
09/11 21:36, 2F
→
09/11 21:37, , 3F
09/11 21:37, 3F
→
09/11 21:43, , 4F
09/11 21:43, 4F
→
09/11 21:49, , 5F
09/11 21:49, 5F
→
09/11 21:49, , 6F
09/11 21:49, 6F
→
09/11 21:51, , 7F
09/11 21:51, 7F
→
09/11 21:52, , 8F
09/11 21:52, 8F
→
09/11 21:58, , 9F
09/11 21:58, 9F
→
09/11 22:59, , 10F
09/11 22:59, 10F
→
09/11 23:00, , 11F
09/11 23:00, 11F
→
09/11 23:28, , 12F
09/11 23:28, 12F
推
09/11 23:51, , 13F
09/11 23:51, 13F
推
09/12 00:55, , 14F
09/12 00:55, 14F
→
09/12 01:05, , 15F
09/12 01:05, 15F
→
09/12 01:09, , 16F
09/12 01:09, 16F
推
09/12 01:11, , 17F
09/12 01:11, 17F
推
09/12 01:13, , 18F
09/12 01:13, 18F
推
09/12 01:13, , 19F
09/12 01:13, 19F
推
09/12 01:17, , 20F
09/12 01:17, 20F
→
09/12 01:19, , 21F
09/12 01:19, 21F
→
09/12 02:10, , 22F
09/12 02:10, 22F
推
09/12 03:48, , 23F
09/12 03:48, 23F
→
09/12 03:49, , 24F
09/12 03:49, 24F
推
09/12 04:05, , 25F
09/12 04:05, 25F
推
09/12 13:06, , 26F
09/12 13:06, 26F
推
09/12 13:19, , 27F
09/12 13:19, 27F
推
09/12 14:21, , 28F
09/12 14:21, 28F
推
09/12 15:21, , 29F
09/12 15:21, 29F
推
09/12 16:12, , 30F
09/12 16:12, 30F
推
09/13 00:08, , 31F
09/13 00:08, 31F
→
09/13 00:08, , 32F
09/13 00:08, 32F