关于用C#把DataTable数据倒入Excel文件的保存问题
foreach (DataRow myRow in dataT.Rows)
{
GridBook = GridApp.Workbooks.Open(strfn, obj, false, obj ,obj, obj, true,obj, obj, true, obj, obj, obj);
GridSht = (Excel.Worksheet)GridBook.Worksheets.get_Item(1);
GridSht.Visible = XlSheetVisibility.xlSheetVisible;
GridRange = GridSht.get_Range(GridSht.Cells[i,y], GridSht.Cells[i,y+dataT.Columns.Count-1]);
try
{
GridRange.Value = myRow.ItemArray;
}
catch (Exception Err)
{
strErr = Err.Message;
}
i++;
GridBook.Close(true, strfn, GridBook);
此程序在GridBook.Close(true, strfn, GridBook);时总是停滞,无法将当前的行保存进文件。请各位高人指点,谢谢~~~~~~~~~~~~~
问题点数:0、回复次数:2Top
1 楼yycghy(游泳的鱼)回复于 2003-12-02 16:32:25 得分 0
说的具体一点Top
2 楼littlehb(在JAVA与。NET之间彷徨)回复于 2003-12-02 17:02:17 得分 0
http://xml.sz.luohuedu.net/xml/ShowDetail.asp?id=BF0A54F9-C7C7-4200-BD9A-802AC1F5DE50Top




