C#中 操作Excel

Question

xlBook.Sheets.Add(, after:=Sheets(Sheets.Count)).Name = i _Worksheet worksheet1 = (_Worksheet)sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);//添加第二个sheet

Answer 1

操作Excel建议使用第三方的插件。解决方法

Answer 2

xlBook.Sheets.Add(, after:=Sheets(Sheets.Count)).Name = i ;这行代码看起来怎么这么别扭?

Answer 3

不好意思 我的vs跑不起office工程，不能帮忙了，

Answer 4

一个Excel表里已经有3个工作表了,现在我想新建一张空表
book.Sheets.Add(Type.Missing,Type.Missing,Type.Missing,Type.Missing)
这行代码新建了一张空的工作表,我想用代码控制它 给它填充数据.麻烦高手了！
 if (l >= 4)
                            {
                                sheet = book.Sheets.Add(Type.Missing,Type.Missing,Type.Missing,Type.Missing) as Excel.Worksheet;
                                //Sheets.Add After:=Sheets("Sheet3");
                                //book.Sheets.Add(,after:=Sheets(Sheets.Count)).Name = i;                               //sheet=book.Sheets.get_Item(l) as Excel.Worksheet;
                                //sheet=(Excel.Worksheet)book.Worksheets[l];
                                sheet.Name =dataGridView1.Rows[i].Cells[1].Value.ToString();
                                int index = 0;
                                for (int k = 2; k < dataGridView1.Columns.Count; k++)
                                {
                                    if(k!=17)
                                    {
                                        index++;
                                        sheet.Cells[1, index] = this.dataGridView1.Columns[k].HeaderText;
                                    }
                                }