vb.net 2005下操作excel无法感知属性问题
<P>在vb.net 2005中 </P><P>Dim nExcel As Microsoft.Office.Interop.Excel.Application <BR>Dim nWorkBooks As Microsoft.Office.Interop.Excel.Workbooks <BR>Dim nWorkBook As Microsoft.Office.Interop.Excel.Workbook <BR>Dim nWorkSheet As Microsoft.Office.Interop.Excel.Worksheet <BR>Dim nRange As Microsoft.Office.Interop.Excel.Range </P>
<P>nExcel = New Microsoft.Office.Interop.Excel.Application() <BR>nWorkBooks = nExcel.Workbooks <BR>nWorkBook = nWorkBooks.Add() <BR>nWorkSheet = CType(nWorkBook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet) <BR>'上述语句正确 </P>
<P>要对第一个单元格设置格式等 <BR>nworksheet.cells(1,1). 之后无法感知相关属性(如字体,数据格式等),从而无法进行设置. <BR>是什么原因???如何更正??? <BR>请指教. <BR></P>
页:
[1]