如何将数据从datatable插入Excel范围识别C＃ [英] How to Insert data from datatable to Excel Range identified C#

问题描述

我希望从数据库中导出数据到已识别的工作表范围，包括excel文件中的旧数据。我尝试出口，但我不能。

请建议。谢谢！[在此输入图片说明] [1]



http://www.flickr.com/photos/118251321@N02/12743240805/

I'm want export data from database in to range identified of worksheet existing included old data in excel file. I try to export but i can't.
Please suggest. Thanks![enter image description here][1]

http://www.flickr.com/photos/118251321@N02/12743240805/

推荐答案

请阅读我对该问题的评论。



我建议从这里开始：

如何使用ADO.NET使用Visual Basic .NET在Excel工作簿中检索和修改记录 [ ^ ]

访问Microsoft Office来自.NET应用程序的数据 [ ^ ]

使用ADO.NET处理Excel文件 [ ^ ]



这并不难。试试！

Please, read my comment to the question.

I would suggest to start here:
How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET[^]
Accessing Microsoft Office Data from .NET Applications[^]
Using ADO.NET to work with Excel files[^]

It's not so hard. Try!

试试

{

if（dt == null || dt.Columns.Count == 0）

{

抛出新的异常（ExportToExcel：空或空输入表！\ n）;

}



Microsoft.Office.Interop.Excel.Application xlApp;

Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

Microsoft.Office .Interop.Excel._Worksheet xlWorkSheet;

Microsoft.Office.Interop.Excel.Range xlRange = null;

object misValue = Missing.Value;



xlApp = new Microsoft.Office.Interop.Excel.Application（）;

xlApp.Visible = false;



xlWorkBook = xlApp.Workbooks.Open（FileParth，misValue，false，misValue，misValue，misValue，true，misValue，misValue，misValue，mis Value，misValue，false，misValue，misValue）;

xlWorkSheet =（Microsoft.Office.Interop.Excel.Worksheet）xlWorkBook.Sheets [SheetName];

xlWorkSheet =（ Microsoft.Office.Interop.Excel.Worksheet）xlWorkBook.Sheets [1];

xlWorkSheet =（Microsoft.Office.Interop.Excel.Worksheet）xlWorkBook.ActiveSheet;

xlWorkSheet.Activate（）;



xlRange = xlWorkSheet.get_Range（StartRange，EndRange）;

int i = 0;

int j = 0;

//标题

for（i = 0;我< dt.Columns.Count; i ++）

{

xlRange.Cells [1，i + 1] = dt.Columns [i] .ColumnName;



}

//数据

for（i = 0; i< dt.Rows.Count; i ++）

{

for（j = 0; j< dt.Columns.Count; j ++）

{

xlRange.Cells [i + 2 ，j + 1] = dt.Rows [i] [j];

}

}

if（FileParth！= null || FileParth！=）

{

尝试

{

xlApp.ActiveWorkbook.SaveAs（FileParth）;

xlApp.Quit（）;



xlWorkSheet = null;

xlWorkBook = null;

xlApp = null;

}

catch（exception ex）

{

抛出新的异常（不能保存文件+ ex.Message;

}

}

其他

{

xlApp.Visible = true;

}

}

catch（例外情况）

{

抛出新的异常（ex.Message）;

}

try
{
if (dt == null || dt.Columns.Count == 0)
{
throw new Exception("ExportToExcel: Null or empty input table!\n");
}

Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel._Worksheet xlWorkSheet;
Microsoft.Office.Interop.Excel.Range xlRange = null;
object misValue = Missing.Value;

xlApp = new Microsoft.Office.Interop.Excel.Application();
xlApp.Visible = false;

xlWorkBook = xlApp.Workbooks.Open(FileParth, misValue, false, misValue, misValue, misValue, true, misValue, misValue, misValue, misValue, misValue, false, misValue, misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Sheets[SheetName];
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Sheets[1];
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.ActiveSheet;
xlWorkSheet.Activate();

xlRange = xlWorkSheet.get_Range(StartRange, EndRange);
int i = 0;
int j = 0;
//Header
for (i = 0; i < dt.Columns.Count; i++)
{
xlRange.Cells[1, i + 1] = dt.Columns[i].ColumnName;

}
//Datas
for (i = 0; i < dt.Rows.Count; i++)
{
for (j = 0; j < dt.Columns.Count; j++)
{
xlRange.Cells[i + 2, j + 1] = dt.Rows[i][j];
}
}
if (FileParth != null || FileParth != "")
{
try
{
xlApp.ActiveWorkbook.SaveAs(FileParth);
xlApp.Quit();

xlWorkSheet = null;
xlWorkBook = null;
xlApp = null;
}
catch (Exception ex)
{
throw new Exception("Can not save file" + ex.Message);
}
}
else
{
xlApp.Visible = true;
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}

这篇关于如何将数据从datatable插入Excel范围识别C＃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！