想要在excel文件中显示列名。 [英] want to display with Column name in excel file.

问题描述

您好，使用以下代码可以在Excel文件中显示表格数据。



但是我希望表格数据具有列名。

任何人都可以通过示例代码为我提供解决方案。

Hi with the below code am able to display table data in Excel file.

But i want table data with column names.
can anyone give solution for me with sample code.

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cnn;
            string connectionstring = null;
            string sql = null;
            string data = null;
            int i = 0;
            int j = 0;

            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;


            xlApp = new Microsoft.Office.Interop.Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

            connectionstring ="Data Source=HostName;Initial Catalog=MSNETDB;Integrated Security=True;Pooling=False";
            cnn = new SqlConnection(connectionstring);
            cnn.Open();
            
            sql = "SELECT * FROM SystemServiceInfo";
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet ds = new DataSet();
            dscmd.Fill(ds);

            for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
            {
                for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                {
                    data = ds.Tables[0].Rows[i].ItemArray[j].ToString();
                    xlWorkSheet.Cells[i + 1, j + 1] = data;
                }
            }
        
            
            xlApp.Visible = true;

< br $> b $ b



谢谢&重新发布

sam.198979

Thanks & Regrades
sam.198979

推荐答案

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection cnn;
            string connectionstring = null;
            string sql = null;
            string data = null;
            int i = 0;
            int j = 0;
 
            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Worksheet xlWorkSheet;
            object misValue = System.Reflection.Missing.Value;
 

            xlApp = new Microsoft.Office.Interop.Excel.Application();
            xlWorkBook = xlApp.Workbooks.Add(misValue);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
 
            connectionstring ="Data Source=HostName;Initial Catalog=MSNETDB;Integrated Security=True;Pooling=False";
            cnn = new SqlConnection(connectionstring);
            cnn.Open();
            
            sql = "SELECT * FROM SystemServiceInfo";
            SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
            DataSet ds = new DataSet();
            dscmd.Fill(ds);
 //fill titles
                for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                {
                    data = ds.Tables[0].Columns[j].Name.ToString();
                    xlWorkSheet.Cells[1, j + 1] = data;
                }           
//fill data
            for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
            {
                for (j = 0; j <= ds.Tables[0].Columns.Count - 1; j++)
                {
                    data = ds.Tables[0].Rows[i].ItemArray[j].ToString();
                    xlWorkSheet.Cells[i + 2, j + 1] = data;
                }
            }
        
            
            xlApp.Visible = true;

< br $>
快乐编码！

：）

Happy Coding!
:)

我建​​议你使用 OLEDB [ ^ ]逐行逐列读取Excel文件。



来自CP知识库的文章：

使用OLEDB读取和编写Excel [ ^ ]

使用Excel将excel文件导入C＃ OLEDB [<一个href =http://www.codeproject.com/Questions/487624/ImportplusexcelplusfileplustoplusC-23plususingplustarget =_ blanktitle =New Window> ^ ]

用于Microsoft Excel 2007的Microsoft OLEDB适配器 [ ^ ]

I would suggest you to use OLEDB[^] instead reading Excel file row by row, column by column.

Articles from CP Knowledge Base:
Reading and Writing Excel using OLEDB[^]
Import excel file to C# using OLEDB[^]
Microsoft OLEDB Adapter for Microsoft Excel 2007[^]

这篇关于想要在excel文件中显示列名。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！