Excel填充问题 高手来咯```

Question

现在我有数行数据
1  2  3  4  5  6  7  8
1  2  3  4.1  5.1  6.1  7.1  8.1
1  2  3  4.2  5.2  6.2  7.2  8.2
2  3  4  5  6  7  8  9
2  3  4  5.1  6.1  7.1  8.1  9.1
2  3  4  5.2  6.2  7.2  8.2  9.2
.......................其中类似1 2 3 之内的可能是相同的数据.很象职工的一年不同月份的工资表现在要把数据填充到excel里 成如下格式1   2    3                1    2    3     
4   5    6   7    8        4    5    6     7   8
4.1 5.1  6.1 7.1  8.1      4.1  5.1   6.1   7.1   8.1
..........
也象:
职工1的基本信息  职工2的基本信息
职工1的工资数据  职工2的工资数据
.....          ......
职工3的基本信息  职工4的基本信息
职工3的工资数据  职工4的工资数据
.....就这样...该怎么填充!!??

Answer 1

自定义html语句，构造table的字符串来进行输出；

Answer 2

帮我看看哪里不对 谢谢 我只能取出头2个职工的数据 谢谢了        private void button2_Click(object sender, EventArgs e)
        {
           ............            try
            {
               .........
                DataSet dataSet = GetDataSet();               .....               
                                int jsxk;//奇数胸卡号
                int jxlabor;//奇数劳保                int osxk;//奇数胸卡号
                int oslabor;//奇数劳保                bool jo = false;//设奇偶数判断,已填充的职工胸卡号不满足本次读取的胸卡号则改变状态                for (int i = 0; i < RowCount; i++)//dataset里的总行数
                {
                    int hangshu = i + 3;//设置多个劳保填充行数                    try
                    {
                        Microsoft.Office.Interop.Excel.Range danweimcc = null;//标题                        
                        Microsoft.Office.Interop.Excel.Range xiongkahaoc = null;//胸卡号
                        Microsoft.Office.Interop.Excel.Range xingmingc = null;//姓名
                        Microsoft.Office.Interop.Excel.Range xingbiec = null;//性别
                        Microsoft.Office.Interop.Excel.Range gangweic = null;//岗位
                        Microsoft.Office.Interop.Excel.Range laobaoc = null;//劳保名称
                        Microsoft.Office.Interop.Excel.Range shuliangc = null;//数量
                        Microsoft.Office.Interop.Excel.Range jiliangdanweic = null;//计量单位
                        Microsoft.Office.Interop.Excel.Range guigec = null;//规格
                        //xiongkahao, xingming, xingbie, danweimc, gangweimc, laobaomc, shuliang, jldanwei,guige
                        danweimcc = oWorkSheet.get_Range("A" + "1", m_objOpt);//标题
                        //niandusj = oWorkSheet.get_Range("C" + "2", m_objOpt);                        if (jo == false)
                        {
                            jsxk = hangshu - i;
                            jxlabor = hangshu + 1;
                            xiongkahaoc = oWorkSheet.get_Range("B" + jsxk.ToString(), m_objOpt);//胸卡号
                            jsxkh = dataSet.Tables[0].Rows[i][0].ToString();
                            if (xiongkahaoc.Text.ToString() == "")
                            {
                                xiongkahaoc.Value2 = dataSet.Tables[0].Rows[i][0].ToString();
                                xiongkahaoc.NumberFormatLocal = "00000";                            }
                            xingmingc = oWorkSheet.get_Range("C" + jsxk.ToString(), m_objOpt);//姓名
                            if (xingmingc.Text.ToString() == "")
                            {
                                xingmingc.Value2 = dataSet.Tables[0].Rows[i][1].ToString();
                            }
                            xingbiec = oWorkSheet.get_Range("D" + jsxk.ToString(), m_objOpt);//性别
                            if (xingbiec.Text.ToString() == "")
                            {
                                xingbiec.Value2 = dataSet.Tables[0].Rows[i][2].ToString();
                            }
                            gangweic = oWorkSheet.get_Range("E" + jsxk.ToString(), m_objOpt);//岗位
                            if (gangweic.Text.ToString() == "")
                            {
                                gangweic.Value2 = dataSet.Tables[0].Rows[i][4].ToString();
                            }
                            if (xiongkahaoc.Text.ToString() == jsxkh)
                            {
                                laobaoc = oWorkSheet.get_Range("B" + jxlabor.ToString(), m_objOpt);//劳保名称
                                laobaoc.Value2 = dataSet.Tables[0].Rows[i][5].ToString();                                shuliangc = oWorkSheet.get_Range("C" + jxlabor.ToString(), m_objOpt);//数量
                                shuliangc.Value2 = dataSet.Tables[0].Rows[i][6];                                jiliangdanweic = oWorkSheet.get_Range("D" + jxlabor.ToString(), m_objOpt);//计量单位
                                jiliangdanweic.Value2 = dataSet.Tables[0].Rows[i][7].ToString();                                guigec = oWorkSheet.get_Range("E" + jxlabor.ToString(), m_objOpt);//规格
                                guigec.Value2 = dataSet.Tables[0].Rows[i][8].ToString();
                            }
                            else
                            {
                                jo = true;
                            }
                        }
                        if (jo == true)
                        {
                            osxk = hangshu - i;
                            oslabor = hangshu - 1;
                            xiongkahaoc = oWorkSheet.get_Range("H" + osxk.ToString(), m_objOpt);//胸卡号
                            osxkh = dataSet.Tables[0].Rows[i][0].ToString();
                            if (xiongkahaoc.Text.ToString() == "")
                            {
                                xiongkahaoc.Value2 = dataSet.Tables[0].Rows[i][0].ToString();
                                xiongkahaoc.NumberFormatLocal = "00000";                            }
                            xingmingc = oWorkSheet.get_Range("I" + osxk.ToString(), m_objOpt);//姓名
                            if (xingmingc.Text.ToString() == "")
                            {
                                xingmingc.Value2 = dataSet.Tables[0].Rows[i][1].ToString();
                            }
                            xingbiec = oWorkSheet.get_Range("J" + osxk.ToString(), m_objOpt);//性别
                            if (xingbiec.Text.ToString() == "")
                            {
                                xingbiec.Value2 = dataSet.Tables[0].Rows[i][2].ToString();
                            }
                            gangweic = oWorkSheet.get_Range("K" + osxk.ToString(), m_objOpt);//岗位
                            if (gangweic.Text.ToString() == "")
                            {
                                gangweic.Value2 = dataSet.Tables[0].Rows[i][4].ToString();
                            }
                            if (xiongkahaoc.Text.ToString() == osxkh)
                            {
                                laobaoc = oWorkSheet.get_Range("H" + oslabor.ToString(), m_objOpt);//劳保名称
                                laobaoc.Value2 = dataSet.Tables[0].Rows[i][5].ToString();                                shuliangc = oWorkSheet.get_Range("I" + oslabor.ToString(), m_objOpt);//数量
                                shuliangc.Value2 = dataSet.Tables[0].Rows[i][6];                                jiliangdanweic = oWorkSheet.get_Range("J" + oslabor.ToString(), m_objOpt);//计量单位
                                jiliangdanweic.Value2 = dataSet.Tables[0].Rows[i][7].ToString();                                guigec = oWorkSheet.get_Range("K" + oslabor.ToString(), m_objOpt);//规格
                                guigec.Value2 = dataSet.Tables[0].Rows[i][8].ToString();
                            }
                            else
                            {
                                jo = false;
                            }                        }
                        if (danweimcc.Text.ToString().Replace("$", "") == "biaoti")
                        {
                            danweimcc.Value2 = danweimc + dateTimePicker1.Value.Year + "年" + dateTimePicker1.Value.Month + "月" + "劳保清单";
                        }
                    }                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    //}
                }
               ...........