在C#中将数据导出到Excell [英] Export data to Excell in C#

问题描述

嗨 我使用此代码

 excelApp = 新 Microsoft.Office.Interop.Excel.Application();
                        excelBook = excelApp.Workbooks.Add(XlSheetType.xlWorksheet);
                        excelWorksheet =(Worksheet)(excelBook.Worksheets [ 1 ]);;
                        excelApp.Visible =  true ;
                        excelWorksheet.DisplayRightToLeft =  true ;
                        rng1 = excelWorksheet.get_Range(" ，"  A1")；
                        rng1.Value2 = " ;
                        rng1.Font.Bold =  true ;
                        rng2 = excelWorksheet.get_Range(" ，"  B1")；
                        rng2.Value2 = " ;
                        rng2.Font.Bold =  true ;
                        rng3 = excelWorksheet.get_Range(" ，"  C1")；
                        rng3.Value2 = " ;
                        rng3.Font.Bold =  true ;
                        i =  1 ;
                         foreach (DataRow r 在 ds.Tables [ 0 ].Row)
                        {
                            i ++;
                            字符串 s = i.ToString();
                            范围r1 = excelWorksheet.get_Range("  + s，"  + s)；
                            r1.Value2 = r [ 0 ].ToString();
                            范围r2 = excelWorksheet.get_Range("  + s，"  + s)；
                            r2.Value2 = r [ 1 ].ToString();
                            范围r3 = excelWorksheet.get_Range("  + s，"  + s)；
                            r3.Value2 = r [ 2 ].ToString();
                        } 

用于将数据导出到Excell.
一段时间，我有一个错误！

"来自HRESULT:0x800AC472的异常""
请帮助我！

解决方案

尝试通过这些链接进行操作.
http://social.msdn.microsoft.com /forums/zh-CN/vsto/thread/9168f9f2-e5bc-4535-8d7d-4e374ab8ff09/ [ http://stackoverflow.com/questions/2411016/c-excel-interop-alternatives-to-waiting-to-handle-0x800ac472-错误 [excelApp = new Microsoft.Office.Interop.Excel.Application(); excelBook = excelApp.Workbooks.Add(XlSheetType.xlWorksheet); excelWorksheet =(Worksheet)(excelBook.Worksheets[1]); excelApp.Visible = true; excelWorksheet.DisplayRightToLeft = true; rng1 = excelWorksheet.get_Range("A1", "A1"); rng1.Value2 = "__ID__"; rng1.Font.Bold = true; rng2 = excelWorksheet.get_Range("B1", "B1"); rng2.Value2 = "ID"; rng2.Font.Bold = true; rng3 = excelWorksheet.get_Range("C1", "C1"); rng3.Value2 = "Title"; rng3.Font.Bold = true; i = 1; foreach (DataRow r in ds.Tables[0].Rows) { i++; string s = i.ToString(); Range r1 = excelWorksheet.get_Range("A" + s, "A" + s); r1.Value2 = r[0].ToString(); Range r2 = excelWorksheet.get_Range("B" + s, "B" + s); r2.Value2 = r[1].ToString(); Range r3 = excelWorksheet.get_Range("C" + s, "C" + s); r3.Value2 = r[2].ToString(); }

for Export data to Excell.
some time ,i have an Error!

"""Exception from HRESULT:0x800AC472"""
pleas help me!!

解决方案

Try going through these links.
http://social.msdn.microsoft.com/forums/en-US/vsto/thread/9168f9f2-e5bc-4535-8d7d-4e374ab8ff09/[^]
http://stackoverflow.com/questions/2411016/c-excel-interop-alternatives-to-waiting-to-handle-0x800ac472-error[^]

这篇关于在C#中将数据导出到Excell的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！