1.先用tlbimp转换Excel组件,再在工程中引用
2.用DataSet作为数据源
2.用DataSet作为数据源
解决方案 »
- 问一个GDI+函数在C#怎么写的.
- 求高人指点.net问题
- MonthCalendar月历控件只能显示日期不能显示时间吗?
- 水晶报表如何过滤重复数据,并在行末汇总?
- 关于winform中c#打印的一个可能是比较弱智的问题。
- 各位大虾,有VS2008+Silverlight 2实例的都共享出来吧
- access远程访问
- 请问如何对excel打印进行页面设置
- 已经发了三帖了,问题还没解决。请 CSDN 上的大侠们看看这个问题,帮帮忙。
- FastReport Designer 在Win7下打开frx文件 在任务栏有响应的任务,但是没有窗口。没有办法最大化
- 如何在Web Services中用C#编一个发送邮件的方法??
- 救我啊
tlbimp是个什么,怎样调用,怎样吧Excel.olb转换成Excel.dll文件。
Excel.Application oExcel;
Excel.Workbook oBook;
Object oMissing = System.Reflection.Missing.Value;
oExcel = new Excel.Application();
oBook = oExcel.Workbooks.Add(oMissing);
for (int i=1;i<=4;i++)
{
oExcel.Cells[i,1]=i.ToString();
oExcel.Cells[i,2]="'bbb2";
oExcel.Cells[i,3]="'ccc3";
oExcel.Cells[i,4]="'aaa4";
}
2 利用水晶报表的CrystalReport对象SetDataSource设置datasetCrystalReport1 oRpt = new CrystalReport1();
oRpt.SetDataSource(dsOrders1);Form rptForm = new Form();
rptForm.Text = "Preview";
rptForm.FormBorderStyle = FormBorderStyle.FixedToolWindow;
rptForm.WindowState = System.Windows.Forms.FormWindowState.Maximized;
CrystalDecisions.Windows.Forms.CrystalReportViewer rptView =
new CrystalDecisions.Windows.Forms.CrystalReportViewer();
rptView.ReportSource = oRpt;
rptForm.Controls.Add(rptView);
rptView.Dock = System.Windows.Forms.DockStyle.Fill;
rptForm.Show();
http://expert.csdn.net/Expert/topic/1216/1216771.xml?temp=.4923212
http://www.chinabs.net/csharp/default.asp?infoid=50怎样吧Excel.olb转换成Excel.dll文件
==>解决方案中右击项目的Reference,选"Add reference...",浏览中找到excel.olb确定即可
怎样吧Excel.olb转换成Excel.dll文件
==>解决方案中右击项目的Reference,选"Add reference...",浏览中找到excel.olb确定即可我找这样办,可是在输入Excel后打点却没有.Application出现而是._Application
而且我用了using Excel;
还出现原来的Application.Exit()还会出现问题。
请问添加引用后,还需不需要using +个什么东西。
本程序测试通过
Dim cn As New SqlConnection(CnStr)
Dim sql As String = "select yp_id,yp_mc,yp_gg,dw_mc,yp_cd from yp,dw where yp_zdw=dw.dw_id"
Dim ap As New SqlDataAdapter(sql, cn)
Dim sty As New DataSet()
ap.Fill(sty, "YP")
Dim exc As New Excel.Application()
Dim workb As Workbooks = exc.Workbooks
Dim works As _Workbook = workb.Add(XlWBATemplate.xlWBATWorksheet)
Dim shs As Sheets = works.Worksheets
Dim sht As _Worksheet = shs.Item(1)
exc.Visible = True
Dim rw As DataRow
Dim I As Integer = 0
For Each rw In sty.Tables("YP").Rows
Dim x As Int32 = I + 1
Dim ra1 As Range = sht.Range("A" & x, "A" & x)
Dim ra2 As Range = sht.Range("B" & x, "B" & x)
Dim ra3 As Range = sht.Range("C" & x, "C" & x)
Dim ra4 As Range = sht.Range("D" & x, "D" & x)
Dim ra5 As Range = sht.Range("E" & x, "E" & x)
Dim ra6 As Range = sht.Range("F" & x, "F" & x)
Dim arg1 As New Object()
Dim arg2 As New Object()
Dim arg3 As New Object()
Dim arg4 As New Object()
Dim arg5 As New Object()
Dim arg6 As New Object()
arg1 = (I + 1).ToString
arg2 = Trim(rw("yp_id")).ToString
arg3 = Trim(rw("yp_mc")).ToString
arg4 = Trim(rw("dw_mc")).ToString
arg5 = Trim(rw("yp_gg")).ToString
arg6 = Trim(rw("yp_cd")).ToString
ra1.Value2 = arg1
ra2.Value2 = arg2
ra3.Value2 = arg3
ra4.Value2 = arg4
ra5.Value2 = arg5
ra6.Value2 = arg6
I += 1
Next
这一句出现问题,而且Excel打点后仍然不能出现Application(),
但Dim exc As New Excel.Workbook()这一句没问题。
请问你在这之前还做了哪些处理,谢谢!
我装的是Office 2000
在添加引用后,在工程的bin目录下也有Interop.Excel.dll,Interop.Office.dll和
Interop.VBIDE.dll这三个文件存在。
但就是会出现上述问题,真的不知道是什么原因。
不过我不知道还要在哪里引用,谢谢你不厌其烦回答我的问题!
会不是命名空间的问题,我还是刚用.Net不是很熟,希望你指教。